explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 08YDU

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 502.855 ↓ 0.0 0 1

Limit (cost=62,971.87..62,971.87 rows=1 width=1,557) (actual time=502.855..502.855 rows=0 loops=1)

2. 0.016 502.853 ↓ 0.0 0 1

Sort (cost=62,971.87..62,971.87 rows=1 width=1,557) (actual time=502.853..502.853 rows=0 loops=1)

  • Sort Key: r.global_line_no
  • Sort Method: quicksort Memory: 25kB
3. 0.001 502.837 ↓ 0.0 0 1

Nested Loop (cost=1,031.79..62,971.86 rows=1 width=1,557) (actual time=502.837..502.837 rows=0 loops=1)

4. 2.111 502.836 ↓ 0.0 0 1

Nested Loop (cost=1,031.23..62,967.26 rows=1 width=29) (actual time=502.836..502.836 rows=0 loops=1)

5. 118.386 196.725 ↑ 1.2 8,000 1

Bitmap Heap Scan on raw_file_records_batch_id_mapping rfbm (cost=1,030.66..19,213.26 rows=9,560 width=8) (actual time=86.015..196.725 rows=8,000 loops=1)

  • Recheck Cond: (batch_id = 1,463,313)
  • Heap Blocks: exact=59
6. 78.339 78.339 ↑ 1.2 8,000 1

Bitmap Index Scan on raw_file_records_batch_id_mapping_batch_id_idx (cost=0.00..1,028.27 rows=9,560 width=0) (actual time=78.339..78.339 rows=8,000 loops=1)

  • Index Cond: (batch_id = 1,463,313)
7. 304.000 304.000 ↓ 0.0 0 8,000

Index Scan using uq_raw_file_record_type on raw_file_record_type t (cost=0.57..4.57 rows=1 width=21) (actual time=0.038..0.038 rows=0 loops=8,000)

  • Index Cond: ((fc_instance_id = 1,109,796) AND (raw_record_id = rfbm.raw_record_id))
  • Filter: ((record_type)::text = 'HEADER'::text)
  • Rows Removed by Filter: 1
8. 0.000 0.000 ↓ 0.0 0

Index Scan using raw_file_records_raw_record_id_idx on raw_file_records r (cost=0.57..4.58 rows=1 width=1,552) (never executed)

  • Index Cond: (raw_record_id = t.raw_record_id)
  • Filter: ((fc_instance_id = 1,109,796) AND (file_id = 9,763,622))