explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jKCD

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

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

2. 0.000 0.000 ↓ 0.0

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

  • Sort Key: r.global_line_no
3. 0.000 0.000 ↓ 0.0

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

4. 0.000 0.000 ↓ 0.0

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

5. 0.000 0.000 ↓ 0.0

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

  • Recheck Cond: (batch_id = 1,463,313)
6. 0.000 0.000 ↓ 0.0

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 rows= loops=)

  • Index Cond: (batch_id = 1,463,313)
7. 0.000 0.000 ↓ 0.0

Index Scan using uq_raw_file_record_type on raw_file_record_type t (cost=0.57..4.57 rows=1 width=21) (actual rows= loops=)

  • Index Cond: ((fc_instance_id = 1,109,796) AND (raw_record_id = rfbm.raw_record_id))
  • Filter: ((record_type)::text = 'HEADER'::text)
8. 0.000 0.000 ↓ 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) (actual rows= loops=)

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