Thread

1. What is equivalent of v$sesstat and v$sql_plan in postgres?

   kunwar singh <krishsingh.111@gmail.com> — 2023-04-20T13:37:24Z

   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
   

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

   MichaelDBA <michaeldba@sqlexec.com> — 2023-04-20T13:40:47Z

   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