explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TU2n

Settings
# exclusive inclusive rows x rows loops node
1. 84.214 201,712.152 ↓ 0.0 0 1

Insert on endtoend_840_central.adg_work_object_list (cost=0.00..4,255.47 rows=10,485 width=4) (actual time=201,712.152..201,712.152 rows=0 loops=1)

  • Buffers: shared hit=1795 read=212 dirtied=8 written=204
2. 102,997.119 201,627.938 ↑ 27.2 386 1

Nested Loop Anti Join (cost=0.00..4,255.47 rows=10,485 width=4) (actual time=60.784..201,627.938 rows=386 loops=1)

  • Output: oi.object_id
  • Join Filter: ((oip.object_id = oi.object_id) AND (oip.object_checksum = oi.object_checksum))
  • Rows Removed by Join Filter: 47021863
  • Buffers: shared hit=1024 read=206 written=204
3. 133.397 133.397 ↑ 1.1 9,561 1

Seq Scan on endtoend_840_central.dss_object_info oi (cost=0.00..2,035.99 rows=10,485 width=8) (actual time=5.132..133.397 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: 104178
  • Buffers: shared hit=409 read=206 written=204
4. 98,477.002 98,497.422 ↓ 4,919.0 4,919 9,561

Materialize (cost=0.00..2,035.99 rows=1 width=8) (actual time=0.003..10.302 rows=4,919 loops=9,561)

  • Output: oip.object_id, oip.object_checksum
  • Buffers: shared hit=615
5. 20.420 20.420 ↓ 9,836.0 9,836 1

Seq Scan on endtoend_840_central.dss_object_info oip (cost=0.00..2,035.99 rows=1 width=8) (actual time=7.850..20.420 rows=9,836 loops=1)

  • Output: oip.object_id, oip.object_checksum
  • Filter: (oip.snapshot_id = 15)
  • Rows Removed by Filter: 103903
  • Buffers: shared hit=615