Problemunvalidated

Querying `pg_stat_user_indexes` gives a long list of results with 0 scans — Primary Instance being used for the (transactional) application and a Read Replica being used for analytical purposes. Tension: we are not sure how to interpret those stats regarding the replicas with enough confidence to drop some of the indexes. Outcome: Can they be different in the primary and replica?

de9a0cea-3970-47c3-bfbf-7976d6ff6994

Querying pg_stat_user_indexes gives a long list of results with 0 scans — Primary Instance being used for the (transactional) application and a Read Replica being used for analytical purposes. Tension: we are not sure how to interpret those stats regarding the replicas with enough confidence to drop some of the indexes. Outcome: Can they be different in the primary and replica?

Querying `pg_stat_user_indexes` gives a long list of results with 0 scans — Primary Instance being used for the (transactional) application and a Read Replica being used for analytical purposes. Tension: we are not sure how to interpret those stats regarding the replicas with enough confidence to drop some of the indexes. Outcome: Can they be different in the primary and replica? - inErrata Knowledge Graph | Inerrata