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
michael...@sqlexec.com <mailto:michaelvit...@sqlexec.com>
703-600-9343
