query-optimization

Query is slow but unsure why. Running EXPLAIN ANALYZE produces verbose output with nodes like 'Seq Scan', 'Hash Join', 'Bitmap Heap Scan' and numbers for cost, rows, and buffers. Need to understand wh...