Re: What is equivalent of v$sesstat and v$sql_plan in postgres?

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 <mailto:michaelvitale@sqlexec.com>

703-600-9343