explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LiTA

Settings
# exclusive inclusive rows x rows loops node
1. 67.985 20,891.859 ↓ 0.0 0 1

Insert on pg_temp_11.tmp_scopeobjfilref (cost=1,480.74..2,953.06 rows=3 width=12) (actual time=20,891.859..20,891.859 rows=0 loops=1)

  • Buffers: local hit=3023296 read=1315 dirtied=347 written=768
2. 11,753.636 20,823.874 ↓ 21,388.7 64,166 1

Nested Loop (cost=1,480.74..2,953.06 rows=3 width=12) (actual time=4.614..20,823.874 rows=64,166 loops=1)

  • Output: kwoi.idkey, kwsrp.idfilref, kwois.idkey
  • Join Filter: ((ass.path)::text = (kwsrp.path)::text)
  • Rows Removed by Join Filter: 148223460
  • Buffers: local hit=2958441 read=966 written=566
3. 73.727 279.496 ↓ 64,166.0 64,166 1

Nested Loop (cost=1,480.74..2,896.51 rows=1 width=524) (actual time=4.332..279.496 rows=64,166 loops=1)

  • Output: kwoi.idkey, kwois.idkey, ass.path
  • Buffers: local hit=199303 read=966 written=566
4. 54.593 77.437 ↓ 16,041.5 64,166 1

Hash Join (cost=1,480.74..2,895.28 rows=4 width=532) (actual time=4.308..77.437 rows=64,166 loops=1)

  • Output: asl.objectid, asl.objectkind, kwois.idkey, ass.path
  • Hash Cond: ((asl.sourceid = kwois.objectid) AND (asl.sourcekind = kwois.objectkind))
  • Buffers: local hit=6928 read=491 written=264
5. 18.582 18.582 ↓ 1.1 64,313 1

Seq Scan on pg_temp_11.amt_sourcelinks asl (cost=0.00..984.00 rows=57,400 width=24) (actual time=0.037..18.582 rows=64,313 loops=1)

  • Output: asl.linkid, asl.objectid, asl.objectkind, asl.sourceid, asl.sourcekind
  • Buffers: local read=410 written=216
6. 0.830 4.262 ↓ 2.6 2,311 1

Hash (cost=1,467.30..1,467.30 rows=896 width=530) (actual time=4.262..4.262 rows=2,311 loops=1)

  • Output: kwois.idkey, kwois.objectid, kwois.objectkind, ass.sourceid, ass.path
  • Buckets: 1024 Batches: 1 Memory Usage: 356kB
  • Buffers: local hit=6928 read=81 written=48
7. 0.892 3.432 ↓ 2.6 2,311 1

Nested Loop (cost=0.00..1,467.30 rows=896 width=530) (actual time=0.048..3.432 rows=2,311 loops=1)

  • Output: kwois.idkey, kwois.objectid, kwois.objectkind, ass.sourceid, ass.path
  • Buffers: local hit=6928 read=81 written=48
8. 0.229 0.229 ↓ 2.6 2,311 1

Seq Scan on pg_temp_11.amt_sources ass (cost=0.00..72.96 rows=896 width=520) (actual time=0.009..0.229 rows=2,311 loops=1)

  • Output: ass.sourceid, ass.sourcekind, ass.path
  • Buffers: local hit=64
9. 2.311 2.311 ↑ 1.0 1 2,311

Index Scan using idx_kb_work_objectids_objectid_objectkind on pg_temp_11.kb_work_objectids kwois (cost=0.00..1.55 rows=1 width=10) (actual time=0.001..0.001 rows=1 loops=2,311)

  • Output: kwois.objectid, kwois.objectkind, kwois.idkey, kwois.objtyp
  • Index Cond: (kwois.objectid = ass.sourceid)
  • Buffers: local hit=6864 read=81 written=48
10. 128.332 128.332 ↑ 1.0 1 64,166

Index Scan using idx_kb_work_objectids_objectid_objectkind on pg_temp_11.kb_work_objectids kwoi (cost=0.00..0.30 rows=1 width=10) (actual time=0.002..0.002 rows=1 loops=64,166)

  • Output: kwoi.objectid, kwoi.objectkind, kwoi.idkey, kwoi.objtyp
  • Index Cond: ((kwoi.objectid = asl.objectid) AND (kwoi.objectkind = asl.objectkind))
  • Buffers: local hit=192375 read=475 written=302
11. 8,790.742 8,790.742 ↓ 3.8 2,311 64,166

Seq Scan on pg_temp_11.kb_work_scoperefpath kwsrp (cost=0.00..49.02 rows=602 width=520) (actual time=0.001..0.137 rows=2,311 loops=64,166)

  • Output: kwsrp.idfilref, kwsrp.path, kwsrp.isexisting
  • Buffers: local hit=2759138