explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XQw5

Settings
# exclusive inclusive rows x rows loops node
1. 235,140.393 238,780.780 ↑ 239,496.6 16 1

Hash Right Join (cost=87,032.95..499,551.78 rows=3,831,946 width=92) (actual time=1,664.984..238,780.780 rows=16 loops=1)

  • Hash Cond: (ii.id = ifi.integration_item_id)
  • Buffers: shared hit=101,823, local hit=1, temp read=41,824 written=41,818
2. 3,640.073 3,640.073 ↓ 1.0 6,949,435 1

Seq Scan on integration_item ii (cost=0.00..169,959.81 rows=6,820,081 width=45) (actual time=0.027..3,640.073 rows=6,949,435 loops=1)

  • Buffers: shared hit=101,759
3. 0.136 0.314 ↑ 239,496.6 16 1

Hash (cost=1,711.62..1,711.62 rows=3,831,946 width=55) (actual time=0.314..0.314 rows=16 loops=1)

  • Buckets: 2,097,152 Batches: 4 Memory Usage: 16,385kB
  • Buffers: shared hit=64, local hit=1
4. 0.033 0.178 ↑ 239,496.6 16 1

Nested Loop (cost=18.06..1,711.62 rows=3,831,946 width=55) (actual time=0.108..0.178 rows=16 loops=1)

  • Buffers: shared hit=64, local hit=1
5. 0.032 0.065 ↑ 12.5 16 1

HashAggregate (cost=17.62..19.62 rows=200 width=16) (actual time=0.061..0.065 rows=16 loops=1)

  • Group Key: COALESCE(merged_items.exist_file_item_id, merged_items.new_file_item_id)
  • Buffers: local hit=1
6. 0.033 0.033 ↑ 38.1 16 1

Seq Scan on merged_items (cost=0.00..16.10 rows=610 width=16) (actual time=0.029..0.033 rows=16 loops=1)

  • Buffers: local hit=1
7. 0.080 0.080 ↑ 1.0 1 16

Index Scan using integration_file_item_pkey on integration_file_item ifi (cost=0.43..8.45 rows=1 width=55) (actual time=0.005..0.005 rows=1 loops=16)

  • Index Cond: (id = COALESCE(merged_items.exist_file_item_id, merged_items.new_file_item_id))
  • Buffers: shared hit=64