Postgres Pro
Downloads
Home   >   mailing lists

Re: What is equivalent of v$sesstat and v$sql_plan in postgres? - Mailing list pgsql-performance

From MichaelDBA
Subject Re: What is equivalent of v$sesstat and v$sql_plan in postgres?
Date
Msg-id aa556770-f569-21ff-5c00-3b54cf9fc741@sqlexec.com
Whole thread Raw
In response to What is equivalent of v$sesstat and v$sql_plan in postgres?  (kunwar singh <krishsingh.111@gmail.com>)
List pgsql-performance
Tree view
RDS does allow you to now create your customized extensions via the pg_tle extension.  Regarding your desire to capture session metrics and sql plan information, I do not know anything that can do that in PG.
Regards,
Michael Vitale

kunwar singh wrote on 4/20/2023 9:37 AM:
If not , how can I get the same functionality by writing a query/job/procedure?

Something which doesn't require me to install a plugin , it is RDS PostgreSQL so cannot install /enable plugin without downtime to a critical production database

v$sesstat use case - I run a query , I would like to see what all metrics in postgres change for my session

v$sql_plan use case - I want to capture all operations for all plans and do analysis on those.

--
Cheers,
Kunwar


Regards,

Michael Vitale

Michaeldba@sqlexec.com

703-600-9343 


Attachment

pgsql-performance by date:

Previous
From: kunwar singh
Date:
Subject: What is equivalent of v$sesstat and v$sql_plan in postgres?
Next
From: Clemens Eisserer
Date:
Subject: Re: speeding up grafana sensor-data query on raspberry pi 3