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?
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
