explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9ch

Settings
# exclusive inclusive rows x rows loops node
1. 0.093 132,611.724 ↓ 78.5 157 1

GroupAggregate (cost=415,286.00..415,286.07 rows=2 width=16) (actual time=132,611.518..132,611.724 rows=157 loops=1)

  • Group Key: parser_record_data_metrics.raw_record_id
  • Buffers: shared hit=1249 read=10915
  • I/O Timings: read=131420.216
2. 0.080 132,611.631 ↓ 78.5 157 1

Unique (cost=415,286.00..415,286.02 rows=2 width=16) (actual time=132,611.508..132,611.631 rows=157 loops=1)

  • Buffers: shared hit=1249 read=10915
  • I/O Timings: read=131420.216
3. 0.157 132,611.551 ↓ 155.0 310 1

Sort (cost=415,286.00..415,286.01 rows=2 width=16) (actual time=132,611.507..132,611.551 rows=310 loops=1)

  • Sort Key: parser_record_data_metrics.raw_record_id, parser_record_data_metrics.fp_inst_id
  • Sort Method: quicksort Memory: 39kB
  • Buffers: shared hit=1249 read=10915
  • I/O Timings: read=131420.216
4. 0.052 132,611.394 ↓ 155.0 310 1

Append (cost=0.57..415,285.99 rows=2 width=16) (actual time=0.022..132,611.394 rows=310 loops=1)

  • Buffers: shared hit=1249 read=10915
  • I/O Timings: read=131420.216
5. 1.036 1.036 ↓ 302.0 302 1

Index Scan using parser_record_data_metrics_fp_inst_id_idx on parser_record_data_metrics (cost=0.57..10,668.66 rows=1 width=16) (actual time=0.022..1.036 rows=302 loops=1)

  • Index Cond: (fp_inst_id >= 376602)
  • Filter: (((consumer_code)::text <> 'GENEVA'::text) AND (parser_id = 2874) AND (feed_id = 7986) AND (file_date = '2019-10-31 00:00:00'::timestamp without time zone) AND (knowledge_end_date > now()))
  • Rows Removed by Filter: 820
  • Buffers: shared hit=367
6. 115,838.885 132,610.306 ↓ 8.0 8 1

Bitmap Heap Scan on kickout_records (cost=5,645.44..404,617.31 rows=1 width=16) (actual time=29,563.909..132,610.306 rows=8 loops=1)

  • Recheck Cond: (effective_begin_date = '2019-10-31'::date)
  • Filter: ((fp_inst_id >= 376602) AND ((consumer_code)::text <> 'GENEVA'::text) AND (parser_id = 2874) AND (feed_id = 7986))
  • Rows Removed by Filter: 286270
  • Heap Blocks: exact=9962
  • Buffers: shared hit=882 read=10915
  • I/O Timings: read=131420.216
7. 16,771.421 16,771.421 ↓ 1.0 297,807 1

Bitmap Index Scan on kickout_records_effdt_idx (cost=0.00..5,645.43 rows=292,383 width=0) (actual time=16,771.421..16,771.421 rows=297,807 loops=1)

  • Index Cond: (effective_begin_date = '2019-10-31'::date)
  • Buffers: shared hit=857 read=978
  • I/O Timings: read=16125.517