explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uRMD

Settings
# exclusive inclusive rows x rows loops node
1. 13.703 304.137 ↑ 19.4 386 1

Hash Anti Join (cost=2,303.28..4,648.27 rows=7,493 width=4) (actual time=275.232..304.137 rows=386 loops=1)

  • Output: oi.object_id
  • Hash Cond: ((oi.object_id = oip.object_id) AND (oi.object_checksum = oip.object_checksum))
  • Buffers: shared hit=656 read=649
2. 187.981 187.981 ↓ 1.0 9,561 1

Seq Scan on endtoend_840_central.dss_object_info oi (cost=0.00..2,154.99 rows=9,176 width=8) (actual time=172.552..187.981 rows=9,561 loops=1)

  • Output: oi.snapshot_id, oi.object_id, oi.object_type_id, oi.object_checksum
  • Filter: (oi.snapshot_id = 11)
  • Rows Removed by Filter: 110776
  • Buffers: shared hit=289 read=362
3. 13.714 102.453 ↑ 1.0 9,836 1

Hash (cost=2,154.99..2,154.99 rows=9,886 width=8) (actual time=102.453..102.453 rows=9,836 loops=1)

  • Output: oip.object_id, oip.object_checksum
  • Buckets: 16384 Batches: 1 Memory Usage: 513kB
  • Buffers: shared hit=364 read=287
4. 88.739 88.739 ↑ 1.0 9,836 1

Seq Scan on endtoend_840_central.dss_object_info oip (cost=0.00..2,154.99 rows=9,886 width=8) (actual time=68.662..88.739 rows=9,836 loops=1)

  • Output: oip.object_id, oip.object_checksum
  • Filter: (oip.snapshot_id = 15)
  • Rows Removed by Filter: 110501
  • Buffers: shared hit=364 read=287