explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ymcK

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.002 178,890.077 ↓ 0.0 0 1

Limit (cost=34,084.10..34,084.11 rows=1 width=1,557) (actual time=178,890.077..178,890.077 rows=0 loops=1)

  • Buffers: shared hit=50,186 read=6,631
  • I/O Timings: read=38,493.455
2. 0.016 178,890.075 ↓ 0.0 0 1

Sort (cost=34,084.10..34,084.11 rows=1 width=1,557) (actual time=178,890.075..178,890.075 rows=0 loops=1)

  • Sort Key: r.global_line_no
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=50,186 read=6,631
  • I/O Timings: read=38,493.455
3. 0.000 178,890.059 ↓ 0.0 0 1

Nested Loop (cost=364.01..34,084.09 rows=1 width=1,557) (actual time=178,890.059..178,890.059 rows=0 loops=1)

  • Join Filter: (t.raw_record_id = r.raw_record_id)
  • Buffers: shared hit=50,183 read=6,631
  • I/O Timings: read=38,493.455
4. 0.002 178,890.059 ↓ 0.0 0 1

Nested Loop (cost=363.44..34,079.49 rows=1 width=29) (actual time=178,890.059..178,890.059 rows=0 loops=1)

  • Buffers: shared hit=50,183 read=6,631
  • I/O Timings: read=38,493.455
5. 117,953.686 178,890.057 ↓ 0.0 0 1

Bitmap Heap Scan on raw_file_record_type t (cost=362.87..33,891.00 rows=41 width=21) (actual time=178,890.057..178,890.057 rows=0 loops=1)

  • Recheck Cond: (fc_instance_id = '1109796'::bigint)
  • Filter: ((record_type)::text = 'HEADER'::text)
  • Rows Removed by Filter: 3,528,000
  • Heap Blocks: exact=30,601
  • Buffers: shared hit=50,183 read=6,631
  • I/O Timings: read=38,493.455
6. 60,936.371 60,936.371 ↓ 204.2 3,657,036 1

Bitmap Index Scan on uq_raw_file_record_type (cost=0.00..362.86 rows=17,906 width=0) (actual time=60,936.371..60,936.371 rows=3,657,036 loops=1)

  • Index Cond: (fc_instance_id = '1109796'::bigint)
  • Buffers: shared hit=22,949 read=3,266
  • I/O Timings: read=18,722.685
7. 0.000 0.000 ↓ 0.0 0

Index Scan using raw_file_records_batch_id_mapping_raw_record_id_idx on raw_file_records_batch_id_mapping rfbm (cost=0.57..4.59 rows=1 width=8) (never executed)

  • Index Cond: (raw_record_id = t.raw_record_id)
  • Filter: (batch_id = 1,463,409)
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 = rfbm.raw_record_id)
  • Filter: ((fc_instance_id = '1109796'::bigint) AND (file_id = '9763622'::bigint))