explain.depesz.com

PostgreSQL's explain analyze made readable

Result: e9j9 : itg-S_7828

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 10,100.267 ↑ 2,069.0 1 1

Unique (cost=8,716,169.94..8,716,195.80 rows=2,069 width=45) (actual time=10,100.266..10,100.267 rows=1 loops=1)

  • Output: l0.lobj_id, l0.settings_path, l0.settings_objectid, l0.lobj_id
  • Buffers: shared hit=3,125,418
2. 0.040 10,100.266 ↑ 2,069.0 1 1

Sort (cost=8,716,169.94..8,716,175.11 rows=2,069 width=45) (actual time=10,100.265..10,100.266 rows=1 loops=1)

  • Output: l0.lobj_id, l0.settings_path, l0.settings_objectid, l0.lobj_id
  • Sort Key: l0.settings_path, l0.lobj_id, l0.settings_objectid
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=3,125,418
3. 94.985 10,100.226 ↑ 2,069.0 1 1

Merge Semi Join (cost=0.84..8,716,055.99 rows=2,069 width=45) (actual time=9,711.507..10,100.226 rows=1 loops=1)

  • Output: l0.lobj_id, l0.settings_path, l0.settings_objectid, l0.lobj_id
  • Merge Cond: (l0.lobj_id = f.lobj_id)
  • Buffers: shared hit=3,125,415
4. 153.358 153.358 ↑ 1.1 391,820 1

Index Scan using ixu_o_folder_id on dalimes.o_folder l0 (cost=0.42..30,130.79 rows=414,196 width=45) (actual time=0.012..153.358 rows=391,820 loops=1)

  • Output: l0.ss_useversioningfolder, l0.settings_template, l0.node_id, l0.ts_deletion, l0.ts_lastchange, l0.ts_creation, l0.lobj_id, l0.settings_uuid, l0.settings_folderregexp, l0.commentushort, l0.settings_folderexclregexp, l0.lobj_n
  • Index Cond: (l0.ts_deletion = 0)
  • Buffers: shared hit=61,052
5. 840.485 9,851.883 ↑ 2,071.0 1 1

Index Scan using ixu_o_folder_id on dalimes.o_folder f (cost=0.42..8,684,863.84 rows=2,071 width=8) (actual time=9,463.168..9,851.883 rows=1 loops=1)

  • Output: f.ss_useversioningfolder, f.settings_template, f.node_id, f.ts_deletion, f.ts_lastchange, f.ts_creation, f.lobj_id, f.settings_uuid, f.settings_folderregexp, f.commentushort, f.settings_folderexclregexp, f.lobj_name, f.setti
  • Index Cond: (f.ts_deletion = 0)
  • Filter: (f.settings_depth = (SubPlan 1))
  • Rows Removed by Filter: 409,608
  • Buffers: shared hit=3,064,363
6.          

SubPlan (for Index Scan)

7. 819.218 9,011.398 ↑ 1.0 1 409,609

Aggregate (cost=20.88..20.89 rows=1 width=8) (actual time=0.022..0.022 rows=1 loops=409,609)

  • Output: count(DISTINCT objectaccess.depth)
  • Buffers: shared hit=3,001,389
8. 121.363 8,192.180 ↓ 0.0 0 409,609

Nested Loop Semi Join (cost=0.85..20.87 rows=6 width=8) (actual time=0.020..0.020 rows=0 loops=409,609)

  • Output: objectaccess.depth
  • Buffers: shared hit=3,001,389
9. 5,734.526 5,734.526 ↑ 1.0 6 409,609

Index Only Scan using ix_objectaccess_object_id on dalimes.objectaccess (cost=0.43..16.34 rows=6 width=16) (actual time=0.004..0.014 rows=6 loops=409,609)

  • Output: objectaccess.object_id, objectaccess.entry_id, objectaccess.depth
  • Index Cond: (objectaccess.object_id = f.lobj_id)
  • Filter: (objectaccess.entry_id = ANY ('{-1,15041,333,444,3563,3565,3590,3944,3946,3948,3950,3954,3956,3958,3962,3964,3966,3968,3970,3974,3976,3978,3980,3982,3984,3986,3988,3990,3992,3994,3996,3998,4000,4002,4004,
  • Rows Removed by Filter: 2
  • Heap Fetches: 3,268,567
  • Buffers: shared hit=1,772,862
10. 698.275 2,336.291 ↓ 0.0 0 2,336,291

Materialize (cost=0.42..4.45 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=2,336,291)

  • Output: l0_1.lobj_id
  • Buffers: shared hit=1,228,527
11. 1,638.016 1,638.016 ↓ 0.0 0 409,504

Index Scan using ix_o_folder_objectid on dalimes.o_folder l0_1 (cost=0.42..4.45 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=409,504)

  • Output: l0_1.lobj_id
  • Index Cond: ((l0_1.settings_objectid = 11,062,203) AND (l0_1.ts_deletion = 0) AND (l0_1.lobj_id = f.lobj_id))
  • Filter: ((l0_1.settings_path)::text ~~ '%/01_Brief/Client_Supplied%'::text)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=1,228,527
Planning time : 4.255 ms
Execution time : 10,100.590 ms