explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7Zja

Settings
# exclusive inclusive rows x rows loops node
1. 505.847 19,793.785 ↓ 1.0 741,936 1

Nested Loop (cost=33,333.13..9,094,673.84 rows=721,490 width=2,617) (actual time=799.803..19,793.785 rows=741,936 loops=1)

2. 5,761.882 6,309.323 ↓ 1.0 2,595,723 1

Bitmap Heap Scan on challan_accused (cost=33,332.57..3,389,563.95 rows=2,572,218 width=579) (actual time=799.505..6,309.323 rows=2,595,723 loops=1)

  • Recheck Cond: ((doc_no)::text = 'No DL'::text)
  • Heap Blocks: exact=722322
3. 547.441 547.441 ↓ 1.0 2,597,335 1

Bitmap Index Scan on idx_challan_accused_type_challan_id_prtial_docno (cost=0.00..32,689.52 rows=2,572,218 width=0) (actual time=547.441..547.441 rows=2,597,335 loops=1)

4. 12,978.615 12,978.615 ↓ 0.0 0 2,595,723

Index Scan using idx_challans_accused_type_id__isactive on challans (cost=0.56..2.19 rows=1 width=2,038) (actual time=0.005..0.005 rows=0 loops=2,595,723)

  • Index Cond: (((accused_type)::text = (challan_accused.type)::text) AND (id = challan_accused.challan_id) AND (is_active = 1))
Planning time : 3.246 ms
Execution time : 19,820.833 ms