From: | MichaelDBA <MichaelDBA(at)sqlexec(dot)com> |
---|---|
To: | kunwar singh <krishsingh(dot)111(at)gmail(dot)com> |
Cc: | pgsql-performance(at)lists(dot)postgresql(dot)org |
Subject: | Re: What is equivalent of v$sesstat and v$sql_plan in postgres? |
Date: | 2023-04-20 13:40:47 |
Message-ID: | aa556770-f569-21ff-5c00-3b54cf9fc741@sqlexec.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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(at)sqlexec(dot)com <mailto:michaelvitale(at)sqlexec(dot)com>
703-600-9343
From | Date | Subject | |
---|---|---|---|
Next Message | Clemens Eisserer | 2023-04-20 16:39:35 | Re: speeding up grafana sensor-data query on raspberry pi 3 |
Previous Message | kunwar singh | 2023-04-20 13:37:24 | What is equivalent of v$sesstat and v$sql_plan in postgres? |