[PERFORM] Planner statistics vs. count(*)

Hi Everybody. I am going to replace some 'select count(*) from ... where ...' queries which run on large tables (10M+ rows) with something like 'explain select * from ... where ' and parse planner output after that to find out its forecast about number of rows the query is going to retrieve.

Re: [PERFORM] Planner statistics vs. count(*)

evgeny gridasov wrote: Hi Everybody. I am going to replace some 'select count(*) from ... where ...' queries which run on large tables (10M+ rows) with something like 'explain select * from ... where ' and parse planner output after that to find out its forecast about number of rows the