explain.depesz.com

PostgreSQL's explain analyze made readable

Result: erOt

Settings
# exclusive inclusive rows x rows loops node
1. 15,287.121 22,174.866 ↑ 1.1 542,141 1

Bitmap Heap Scan on fact_contract fact_contract (cost=26,667.66..443,248.67 rows=617,819 width=221) (actual time=6,916.857..22,174.866 rows=542,141 loops=1)

  • Heap Blocks: exact=61419
  • Buffers: shared read=69960 dirtied=58045 written=7757
2. 6,887.745 6,887.745 ↓ 1.2 755,387 1

Bitmap Index Scan on fact_contract_client_sk_idx (cost=0..26,513.2 rows=617,819 width=0) (actual time=6,887.745..6,887.745 rows=755,387 loops=1)

  • Index Cond: (fact_contract.client_sk = 11)
  • Buffers: shared read=8541