| From: | legrand legrand <legrand_legrand(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_stat_statements: can we extend the object names to the qualified names? |
| Date: | 2018-11-27 21:10:09 |
| Message-ID: | 1543353009578-0.post@n3.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2018-11-27 21:17:21 | Re: pg_stat_statements: can we extend the object names to the qualified names? |
| Previous Message | Sergei Agalakov | 2018-11-27 20:37:47 | pg_stat_statements: can we extend the object names to the qualified names? |