From: | dba consultant <dbaconsultant1515(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Problematic read queries |
Date: | 2021-03-06 14:24:40 |
Message-ID: | CAKzgp+xNsDPuqZxqT01=xm0Gs3-D5wSBcEcd7uVzP=BSf8Fm8w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Team,
We have recently configured replica to our postgres instance.
Now the application team wants to move problematic read queries to read
replica.
We have enabled pg_stat_statements extension.
1. How can I get most load causing queries from pg_stat_statements view
whether we can calculate it from column 'rows' or 'shared_blk_hit' or
'max_time' or we have to look into any specific columns for that particular
query?
2. I just want only read queries which should move to read replica: I could
see a few select queries calling functions, but functions have
insert,update statements so in that case whether it will be only select
query or insert,update query?
Thanks in advance.
Regards,
DBA
From | Date | Subject | |
---|---|---|---|
Next Message | Andrus | 2021-03-06 17:53:11 | Re: Log files polluted with permission denied error messages after every 10 seconds |
Previous Message | Andrus | 2021-03-06 08:47:00 | Re: Log files polluted with permission denied error messages after every 10 seconds |