A part of the answer would be to store
explain (verbose on) select count(*) from t1;
result in pg_stat_statements for the corresponding query...
(Verbose On) gives the "qualified names":
QUERY PLAN
---------------------------------------
Aggregate (cost=19.38..19.39 rows=1 width=8)
Output: count(*)
-> Seq Scan on s1.t1 (cost=0.00..17.50 rows=750 width=0)
Output: a1, a2, a3, a4, a5, a6
Extension pg_store_plans
https://github.com/ossc-db/pg_store_plans
can do it.
Extesion auto_explain can help also.
There are also some tryies to extend pg_stat_statements
with plans see
https://www.postgresql-archive.org/FEATURE-PATCH-pg-stat-statements-with-plans-td5940964.html
Regards
PAscal
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
