Hello,
I was comparing pg_stat_plans with oracle’s statspack which provides plan statistics (at level 6). Does pg_stat_plans provide plan node level statistics like statspack? Explain analyze already has statistics like estimated startup cost, estimated total cost, estimated number of rows retrieved, actual startup time, actual total time, total runtime and actual number of rows retrieved , per node. Would this be useful for pg_stat_plans to have in its view?
Regards
Sameer
Hello,
I was comparing pg_stat_plans with oracle’s statspack which provides plan statistics (at level 6). Does pg_stat_plans provide plan node level statistics like statspack? Explain analyze already has statistics like estimated startup cost, estimated total cost, estimated number of rows retrieved, actual startup time, actual total time, total runtime and actual number of rows retrieved , per node. Would this be useful for pg_stat_plans to have in its view?
Regards
Sameer