explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wKlQ

Settings
# exclusive inclusive rows x rows loops node
1. 644.078 15,368.614 ↓ 1.0 742,189 1

Nested Loop (cost=33,333.13..9,094,763.84 rows=721,490 width=2,617) (actual time=629.704..15,368.614 rows=742,189 loops=1)

2. 3,921.056 4,337.912 ↓ 1.0 2,596,656 1

Bitmap Heap Scan on challan_accused (cost=33,332.57..3,389,563.95 rows=2,572,218 width=579) (actual time=629.535..4,337.912 rows=2,596,656 loops=1)

  • Recheck Cond: ((doc_no)::text = 'No DL'::text)
  • Heap Blocks: exact=722494
3. 416.856 416.856 ↓ 1.0 2,598,311 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=416.856..416.856 rows=2,598,311 loops=1)

4. 10,386.624 10,386.624 ↓ 0.0 0 2,596,656

Index Scan using idx_challans_accused_type_id__isactive on challans (cost=0.56..2.19 rows=1 width=2,038) (actual time=0.004..0.004 rows=0 loops=2,596,656)

  • Index Cond: (((accused_type)::text = (challan_accused.type)::text) AND (id = challan_accused.challan_id) AND (is_active = 1))
Planning time : 1.277 ms
Execution time : 15,389.756 ms