Skip site navigation (1) Skip section navigation (2)

Re: number of rows returned from SELECT

From: "Andrew Hammond" <andrew(dot)george(dot)hammond(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: number of rows returned from SELECT
Date: 2006-07-29 00:16:14
Message-ID: 1154132173.955394.213920@75g2000cwc.googlegroups.com (view raw or flat)
Thread:
Lists: pgsql-novice
> What's the most efficient way of determining the number of rows that
> _would_ be returned after/for a SELECT? Or is this impossible without...
> actually... _doing_ a SELECT?

You can't determine it without running the query. However you can ask
for a estimate.  Take a look at EXPLAIN.


In response to

pgsql-novice by date

Next:From: Michael FuhrDate: 2006-07-29 00:33:00
Subject: Re: number of rows returned from SELECT
Previous:From: CoreyDate: 2006-07-28 23:26:24
Subject: number of rows returned from SELECT

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group