Re: speeding up grafana sensor-data query on raspberry pi 3

Hi, I was too lazy to switch to a ARMv8 rootfs, instead I used an ARMv7 postgresql 15.2 docker image running via podman to try the suggestions. The performance improvements offered by the new postgresql features is really impressive! 5318.382 ms: original query 2372.618 ms: with date_bin 2154.5

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 ge

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

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 se