explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Yotp : update from

Settings
# exclusive inclusive rows x rows loops node
1. 92,605.840 112,418.380 ↓ 0.0 0 1

Update on stuff.interface_events (cost=382.50..543,375.14 rows=60,000,062 width=20) (actual time=112,418.380..112,418.380 rows=0 loops=1)

  • Buffers: shared hit=60265544 read=398262 dirtied=355590 written=33181
  • I/O Timings: read=1985.631 write=381.139
2. 11,150.611 19,812.540 ↑ 2.0 30,000,000 1

Hash Join (cost=382.50..543,375.14 rows=60,000,062 width=20) (actual time=2,215.695..19,812.540 rows=30,000,000 loops=1)

  • Output: interface_events.device_id, device.interface_id, interface_events.ctid, device.ctid
  • Inner Unique: true
  • Hash Cond: (interface_events.device_id = device.id)
  • Buffers: shared hit=155 read=265487 dirtied=222847 written=28036
  • I/O Timings: read=1985.293 write=314.074
3. 8,652.218 8,652.218 ↑ 2.0 30,000,000 1

Seq Scan on stuff.interface_events (cost=0.00..385,487.12 rows=60,000,062 width=10) (actual time=2,205.783..8,652.218 rows=30,000,000 loops=1)

  • Output: interface_events.device_id, interface_events.ctid
  • Buffers: shared read=265487 dirtied=222847 written=28036
  • I/O Timings: read=1985.293 write=314.074
4. 5.345 9.711 ↑ 1.0 35,000 1

Hash (cost=225.00..225.00 rows=35,000 width=14) (actual time=9.710..9.711 rows=35,000 loops=1)

  • Output: device.interface_id, device.ctid, device.id
  • Buckets: 65536 Batches: 1 Memory Usage: 2153kB
  • Buffers: shared hit=155
5. 4.366 4.366 ↑ 1.0 35,000 1

Seq Scan on stuff.device (cost=0.00..225.00 rows=35,000 width=14) (actual time=0.015..4.366 rows=35,000 loops=1)

  • Output: device.interface_id, device.ctid, device.id
  • Buffers: shared hit=155
Planning time : 0.147 ms
Execution time : 112,418.650 ms