Do I trust “cost” or “actual time” more when using Postgres EXPLAIN ANALYZE?
I’m trying to improve the performance of one of our most expensive queries. I’m running EXPLAIN ANALYZE on the sandbox postgres 15 database, which has a much smaller dataset than the production postgres 15 database, and also likely doesn’t have the same data patterns that we have in production as well.