| From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
|---|---|
| To: | "Subramanian,Ramachandran" <ramachandran(dot)subramanian(at)alte-leipziger(dot)de> |
| Cc: | "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Is it possible to turn on pg_stat_extensions at a database level |
| Date: | 2026-03-12 09:30:05 |
| Message-ID: | abKHnbVxwkrGL1Fb@depesz.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Thu, Mar 12, 2026 at 08:54:04AM +0000, Subramanian,Ramachandran wrote:
> I have turned on pg_stat_extension for an instance. This instance has many databases. I want to confine the statistics to only one database.
> Is it possible to do this?
Do you mean pg_stat_statements?
If no - sorry, never heard of pg_stat_extension.
If yes - nope. stats are global. You can limit what you're analysing
from stats by adding appropriate where condition, like:
SELECT
*
FROM
pg_stat_statements AS pss
JOIN pg_database AS d ON pss.dbid = d.oid
WHERE
d.datname = 'postgres';
Best regards,
depesz
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Subramanian,Ramachandran | 2026-03-12 09:33:29 | AW: Is it possible to turn on pg_stat_extensions at a database level |
| Previous Message | Subramanian,Ramachandran | 2026-03-12 08:54:04 | Is it possible to turn on pg_stat_extensions at a database level |