explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ityM

Settings
# exclusive inclusive rows x rows loops node
1. 1.814 184,836.414 ↑ 10.9 844 1

Append (cost=0.57..3,083,599.36 rows=9,188 width=95) (actual time=6.663..184,836.414 rows=844 loops=1)

  • Buffers: shared hit=11903 read=509665 dirtied=5
  • I/O Timings: read=85988.763
2. 1,210.371 1,210.371 ↓ 1.2 844 1

Index Scan using item_event_contract_id_idx on item_event_temp (cost=0.57..2,712.64 rows=701 width=93) (actual time=6.660..1,210.371 rows=844 loops=1)

  • Index Cond: (contract_id = '56088684'::bigint)
  • Buffers: shared hit=35 read=764
  • I/O Timings: read=1172.242
3. 0.005 183,624.229 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=550,692.15..3,080,886.72 rows=8,487 width=95) (actual time=183,624.229..183,624.229 rows=0 loops=1)

  • Buffers: shared hit=11868 read=508901 dirtied=5
  • I/O Timings: read=84816.521
4. 34.913 183,624.224 ↓ 0.0 0 1

Gather (cost=550,692.15..3,080,801.85 rows=8,487 width=137) (actual time=183,624.224..183,624.224 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=11868 read=508901 dirtied=5
  • I/O Timings: read=84816.521
5. 45,983.202 183,589.311 ↓ 0.0 0 3

Hash Join (cost=549,692.15..3,078,953.15 rows=3,536 width=137) (actual time=183,589.311..183,589.311 rows=0 loops=3)

  • Hash Cond: (ibe.revision_at_id = r.id)
  • Buffers: shared hit=41794 read=1536996 dirtied=6
  • I/O Timings: read=250572.898
6. 130,489.936 130,489.936 ↑ 1.2 35,457,759 3

Parallel Seq Scan on item_billing_event ibe (cost=0.00..1,971,205.87 rows=44,202,387 width=28) (actual time=1.216..130,489.936 rows=35,457,759 loops=3)

  • Buffers: shared hit=3640 read=1525542 dirtied=1
  • I/O Timings: read=244286.352
7. 222.369 7,116.173 ↑ 1.4 104,016 3

Hash (cost=547,829.14..547,829.14 rows=149,041 width=75) (actual time=7,116.173..7,116.173 rows=104,016 loops=3)

  • Buckets: 262144 Batches: 1 Memory Usage: 8549kB
  • Buffers: shared hit=38098 read=11454 dirtied=5
  • I/O Timings: read=6286.546
8. 6,893.804 6,893.804 ↑ 1.4 104,016 3

Index Scan using revision_contract_id_idx1 on revision r (cost=0.58..547,829.14 rows=149,041 width=75) (actual time=2.818..6,893.804 rows=104,016 loops=3)

  • Index Cond: (contract_id = '56088684'::bigint)
  • Buffers: shared hit=38098 read=11454 dirtied=5
  • I/O Timings: read=6286.546