Explain Analyze Guide

• Compare estimated rows vs actual rows.
• Check nodes: Seq Scan, Index Scan, Bitmap Heap Scan, Sort, Nested Loop, Hash Join, HashAggregate.
• Use EXPLAIN (ANALYZE, BUFFERS) to inspect I/O patterns.
• Refresh statistics with ANALYZE when estimates drift.

EXPLAIN (ANALYZE, BUFFERS)
SELECT dms.*
FROM dms dms
JOIN dms_variable dv ON dv.dms_id = dms.id
WHERE dv.dms_master_codify_code = 'DOCUMENT_TYPE';