Hello Experts!
We have a PgSQL instance running with HA (secondary is being in sync with streaming replication). Both the ends, we have same version, but not sure a few SQLs behave badly in the secondary:
Primary:
PostgreSQL 12.20 (Ubuntu 12.20-0ubuntu0.20.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.2) 9.4.0, 64-bit
OS: Ubuntu 20.04.6 LTS \n \l
Secondary:
ostgreSQL 12.20 (Ubuntu 12.20-0ubuntu0.20.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.2) 9.4.0, 64-bit
OS: Ubuntu 20.04.6 LTS \n \l
The application consumes more data from secondary, hence the server has extra vCPUs.
Can you please advise what needs to be checked.
FYI, I am attaching the query with the different execution plans.
Regards
Siraj
Attachment:
bad-explain-secondary
Description: Binary data
Attachment:
explain-primary
Description: Binary data
Attachment:
query
Description: Binary data
