explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7XXl

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,431.41..5,143.24 rows=2,917 width=882) (actual rows= loops=)

  • Hash Cond: ((w.claim_id)::bpchar = (c.claim_id)::bpchar)
2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on cl_claim_workflows w (cost=58.89..3,697.80 rows=2,917 width=420) (actual rows= loops=)

  • Recheck Cond: (((wf_status)::text = 'Closed'::text) AND (wf_status_end_ts IS NULL) AND ((wf_type)::text = 'Claim'::text))
3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ix_cl_claim_workflows_test_status (cost=0.00..58.16 rows=2,917 width=0) (actual rows= loops=)

  • Index Cond: ((wf_status)::text = 'Closed'::text)
4. 0.000 0.000 ↓ 0.0

Hash (cost=1,127.23..1,127.23 rows=19,623 width=462) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on cl_claims c (cost=0.00..1,127.23 rows=19,623 width=462) (actual rows= loops=)