Postgres Pro
Downloads
Home   >   mailing lists

how to get the total number of records in report - Mailing list pgsql-performance

From AI Rumman
Subject how to get the total number of records in report
Date
Msg-id AANLkTimLXyfHRzo+PdrXmcMf_JKJL+L_EegusSeh1T-v@mail.gmail.com
Whole thread Raw
Responses Re: how to get the total number of records in report  (Josh Kupershmidt <schmiddy@gmail.com>)
Re: how to get the total number of records in report  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-performance
Tree view
At present for reporting I use following types of query: 
select crm.*, crm_cnt.cnt
from crm,
(select count(*) as cnt from crm) crm_cnt;
Here count query is used to find the total number of records. 
Same FROM clause is copied in both the part of the query.
Is there any other good alternative way to get this similar value?


pgsql-performance by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Stored procedure declared as VOLATILE => no good optimization is done
Next
From: Nikolai Zhubr
Date:
Subject: Re: Index scan / Index cond limitation or ?