explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sLm0 : d14853

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 1,446.961 ↓ 2.5 5 1

Unique (cost=98,155.69..98,155.75 rows=2 width=42) (actual time=1,446.958..1,446.961 rows=5 loops=1)

  • Output: l0.lobj_id, l0.lobj_name, l0.ts_lastchange, l0.lobj_id, l2.page_activefilerelease, l2.page_lastpagerelease, (COALESCE((SubPlan 2), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 4), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying)), (COALESCE((SubPlan 6), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 8), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying)), (COALESCE((SubPlan 10), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 12), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying)), (COALESCE((SubPlan 14), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 16), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying)), (COALESCE((SubPlan 18), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 20), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying)), l0.lobj_id
  • Buffers: shared hit=506575 dirtied=2
2. 0.092 1,446.958 ↓ 2.5 5 1

Sort (cost=98,155.69..98,155.69 rows=2 width=42) (actual time=1,446.958..1,446.958 rows=5 loops=1)

  • Output: l0.lobj_id, l0.lobj_name, l0.ts_lastchange, l0.lobj_id, l2.page_activefilerelease, l2.page_lastpagerelease, (COALESCE((SubPlan 2), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 4), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying)), (COALESCE((SubPlan 6), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 8), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying)), (COALESCE((SubPlan 10), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 12), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying)), (COALESCE((SubPlan 14), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 16), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying)), (COALESCE((SubPlan 18), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 20), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying)), l0.lobj_id
  • Sort Key: l0.lobj_name, l0.lobj_id, l0.ts_lastchange, l2.page_activefilerelease, l2.page_lastpagerelease, (COALESCE((SubPlan 2), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 4), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying)), (COALESCE((SubPlan 6), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 8), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying)), (COALESCE((SubPlan 10), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 12), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying)), (COALESCE((SubPlan 14), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 16), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying)), (COALESCE((SubPlan 18), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 20), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying))
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=506575 dirtied=2
3. 0.361 1,446.866 ↓ 2.5 5 1

Nested Loop Left Join (cost=97,888.09..98,155.68 rows=2 width=42) (actual time=1,446.537..1,446.866 rows=5 loops=1)

  • Output: l0.lobj_id, l0.lobj_name, l0.ts_lastchange, l0.lobj_id, l2.page_activefilerelease, l2.page_lastpagerelease, COALESCE((SubPlan 2), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 4), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying), COALESCE((SubPlan 6), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 8), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying), COALESCE((SubPlan 10), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 12), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying), COALESCE((SubPlan 14), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 16), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying), COALESCE((SubPlan 18), (('<ListDef:Formatter><ListDef:FArg>'::text || (('BlobFormatter'::text || (('</ListDef:FArg><ListDef:FArg>'::text || (concat((SubPlan 20), '</ListDef:FArg></ListDef:Formatter>'::character varying))::text))::text))::text))::character varying), l0.lobj_id
  • Buffers: shared hit=506566 dirtied=2
4. 0.009 1,446.155 ↓ 2.5 5 1

Nested Loop (cost=97,887.66..97,904.16 rows=2 width=34) (actual time=1,446.117..1,446.155 rows=5 loops=1)

  • Output: l0.lobj_id, l0.lobj_name, l0.ts_lastchange
  • Buffers: shared hit=506385 dirtied=2
5. 0.003 1,446.106 ↓ 2.5 5 1

Unique (cost=97,887.23..97,887.24 rows=2 width=8) (actual time=1,446.103..1,446.106 rows=5 loops=1)

  • Output: pageorderparent.object_id
  • Buffers: shared hit=506365 dirtied=2
6. 0.013 1,446.103 ↓ 2.5 5 1

Sort (cost=97,887.23..97,887.23 rows=2 width=8) (actual time=1,446.102..1,446.103 rows=5 loops=1)

  • Output: pageorderparent.object_id
  • Sort Key: pageorderparent.object_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=506365 dirtied=2
7. 0.002 1,446.090 ↓ 2.5 5 1

Append (cost=1.28..97,887.22 rows=2 width=8) (actual time=1,428.705..1,446.090 rows=5 loops=1)

  • Buffers: shared hit=506365 dirtied=2
8. 0.008 1,061.843 ↓ 0.0 0 1

Nested Loop Semi Join (cost=1.28..48,960.01 rows=1 width=8) (actual time=1,061.843..1,061.843 rows=0 loops=1)

  • Output: pageorderparent.object_id
  • Buffers: shared hit=253170 dirtied=2
9. 0.013 1,061.820 ↓ 5.0 5 1

Nested Loop (cost=0.99..48,926.31 rows=1 width=16) (actual time=1,016.504..1,061.820 rows=5 loops=1)

  • Output: pageorderparent.object_id, pageorderparent.parent_id
  • Buffers: shared hit=253160 dirtied=2
10. 1,061.777 1,061.777 ↓ 5.0 5 1

Index Scan using ix_mdt_pageorder_key on dalimes.mdt_pageorder mtd0 (cost=0.56..48,917.86 rows=1 width=8) (actual time=1,016.489..1,061.777 rows=5 loops=1)

  • Output: mtd0.val_id, mtd0.lobj_id, mtd0.ns_id, mtd0.data_key, mtd0.data_value, mtd0.data_extid, mtd0.data_type, mtd0.ts_deletion
  • Index Cond: ((mtd0.ts_deletion = 0) AND ((mtd0.data_key)::text = 'shotitemid'::text) AND (mtd0.ns_id = 47))
  • Filter: ((mtd0.data_value)::text = '662014'::text)
  • Rows Removed by Filter: 357156
  • Buffers: shared hit=253140 dirtied=2
11. 0.030 0.030 ↑ 1.0 1 5

Index Only Scan using pk_pageorderparent on dalimes.pageorderparent (cost=0.43..8.45 rows=1 width=16) (actual time=0.006..0.006 rows=1 loops=5)

  • Output: pageorderparent.object_id, pageorderparent.parent_id
  • Index Cond: (pageorderparent.object_id = mtd0.lobj_id)
  • Heap Fetches: 5
  • Buffers: shared hit=20
12. 0.015 0.015 ↓ 0.0 0 5

Index Scan using ixu_o_folder_id on dalimes.o_folder f (cost=0.28..16.99 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=5)

  • 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.settings_volumeid, f.commentulong, f.ostt_list, f.settings_objectid, f.lastchangeuser_code, f.settings_category, f.settings_color, f.ostt_value, f.settings_productname, f.creationuser_code, f.settings_depth, f.settings_insertmetadata, f.settings_rgroupname, f.syshierarchy, f.settings_path, f.lobj_isroot, f.settings_fileexclregexp, f.settings_smartviewname, f.settings_fileregexp, f.lobj_version, f.parent_node_id, f.settings_wgroupname, f.settings_filepattern
  • Index Cond: ((f.lobj_id = pageorderparent.parent_id) AND (f.ts_deletion = 0))
  • Filter: (f.settings_depth = (SubPlan 21))
  • Buffers: shared hit=10
13.          

SubPlan (for Index Scan)

14. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=16.67..16.68 rows=1 width=8) (never executed)

  • Output: count(DISTINCT objectaccess_1.depth)
15. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_objectaccess on dalimes.objectaccess objectaccess_1 (cost=0.42..16.67 rows=1 width=8) (never executed)

  • Output: objectaccess_1.object_id, objectaccess_1.entry_id, objectaccess_1.depth
  • Index Cond: (objectaccess_1.object_id = f.lobj_id)
  • Filter: (objectaccess_1.entry_id = ANY ('{-1,3939,4306,5483,3586,5482}'::bigint[]))
  • Heap Fetches: 0
16. 0.003 384.245 ↓ 5.0 5 1

Nested Loop Semi Join (cost=1.70..48,927.19 rows=1 width=8) (actual time=366.861..384.245 rows=5 loops=1)

  • Output: pageorderparent_1.object_id
  • Buffers: shared hit=253195
17. 0.008 384.182 ↓ 5.0 5 1

Nested Loop (cost=0.99..48,926.31 rows=1 width=16) (actual time=366.837..384.182 rows=5 loops=1)

  • Output: pageorderparent_1.object_id, pageorderparent_1.parent_id
  • Buffers: shared hit=253160
18. 384.144 384.144 ↓ 5.0 5 1

Index Scan using ix_mdt_pageorder_key on dalimes.mdt_pageorder mtd0_1 (cost=0.56..48,917.86 rows=1 width=8) (actual time=366.824..384.144 rows=5 loops=1)

  • Output: mtd0_1.val_id, mtd0_1.lobj_id, mtd0_1.ns_id, mtd0_1.data_key, mtd0_1.data_value, mtd0_1.data_extid, mtd0_1.data_type, mtd0_1.ts_deletion
  • Index Cond: ((mtd0_1.ts_deletion = 0) AND ((mtd0_1.data_key)::text = 'shotitemid'::text) AND (mtd0_1.ns_id = 47))
  • Filter: ((mtd0_1.data_value)::text = '662014'::text)
  • Rows Removed by Filter: 357156
  • Buffers: shared hit=253140
19. 0.030 0.030 ↑ 1.0 1 5

Index Only Scan using pk_pageorderparent on dalimes.pageorderparent pageorderparent_1 (cost=0.43..8.45 rows=1 width=16) (actual time=0.006..0.006 rows=1 loops=5)

  • Output: pageorderparent_1.object_id, pageorderparent_1.parent_id
  • Index Cond: (pageorderparent_1.object_id = mtd0_1.lobj_id)
  • Heap Fetches: 5
  • Buffers: shared hit=20
20. 0.015 0.060 ↑ 1.0 1 5

Nested Loop (cost=0.70..0.86 rows=1 width=16) (actual time=0.012..0.012 rows=1 loops=5)

  • Output: objectaccess.object_id, o_job.lobj_id
  • Join Filter: (objectaccess.object_id = o_job.lobj_id)
  • Buffers: shared hit=35
21. 0.020 0.020 ↑ 1.0 1 5

Index Only Scan using pk_objectaccess on dalimes.objectaccess (cost=0.42..0.54 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=5)

  • Output: objectaccess.object_id, objectaccess.entry_id, objectaccess.depth
  • Index Cond: (objectaccess.object_id = pageorderparent_1.parent_id)
  • Filter: (objectaccess.entry_id = ANY ('{-1,3939,4306,5483,3586,5482}'::bigint[]))
  • Rows Removed by Filter: 2
  • Heap Fetches: 15
  • Buffers: shared hit=20
22. 0.025 0.025 ↑ 1.0 1 5

Index Only Scan using ixu_o_job_id on dalimes.o_job (cost=0.29..0.31 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=5)

  • Output: o_job.lobj_id, o_job.ts_deletion, o_job.syshierarchy, o_job.lobj_name
  • Index Cond: ((o_job.lobj_id = pageorderparent_1.parent_id) AND (o_job.ts_deletion = 0))
  • Heap Fetches: 5
  • Buffers: shared hit=15
23. 0.040 0.040 ↑ 1.0 1 5

Index Scan using ixu_o_pageorder_idlist on dalimes.o_pageorder l0 (cost=0.43..8.45 rows=1 width=34) (actual time=0.008..0.008 rows=1 loops=5)

  • Output: l0.commentushort, l0.settings_pagespreadnumber, l0.lobj_version, l0.ostt_value, l0.archive_arcid, l0.settings_uuid, l0.parent_node_id, l0.settings_rolemasks, l0.ss_virtualspreadnumber, l0.commentulong, l0.lobj_name, l0.lobj_id, l0.lastchangeuser_code, l0.archive_restoreid, l0.references_pageordername, l0.node_id, l0.references_pageordercolor, l0.settings_parameterset, l0.ts_creation, l0.settings_priority, l0.syshierarchy, l0.settings_wflname, l0.creationuser_code, l0.ts_deletion, l0.ts_lastchange, l0.lobj_isroot, l0.ostt_list
  • Index Cond: ((l0.ts_deletion = 0) AND (l0.lobj_id = pageorderparent.object_id))
  • Buffers: shared hit=20
24. 0.135 0.135 ↑ 1.0 1 5

Index Scan using ixu_o_pageorder_page_id on dalimes.o_pageorder_page l2 (cost=0.43..0.56 rows=1 width=16) (actual time=0.027..0.027 rows=1 loops=5)

  • Output: l2.dates_adventrydate, l2.page_version, l2.page_externalreference, l2.page_ctlwmergetype, l2.page_bleedtop, l2.dates_fileentrydate, l2.page_activefilerelease, l2.page_lastfilerelease, l2.lobj_id, l2.pe_preferredsectionvariant, l2.parent_node_id, l2.page_preferredfolio, l2.page_workingfilebag, l2.syshierarchy, l2.dates_textentrydate, l2.page_isfilereleaselocked, l2.node_id, l2.page_color, l2.page_bleedright, l2.page_simulation, l2.page_bleedleft, l2.page_bleedbottom, l2.page_trimsizex, l2.ts_deletion, l2.page_info, l2.page_trimsizey, l2.page_lockuser, l2.page_ucrtype, l2.page_preferredvariant, l2.page_iccname, l2.page_type, l2.page_lastpagerelease, l2.page_workingfilerelease
  • Index Cond: ((l2.lobj_id = l0.lobj_id) AND (l2.ts_deletion = 0) AND ((l2.syshierarchy)::text = '001.001.001'::text))
  • Buffers: shared hit=20
25.          

SubPlan (for Nested Loop Left Join)

26. 0.030 0.070 ↑ 1.0 1 5

Index Scan using ixu_mdt_pageorder_lobjidkey on dalimes.mdt_pageorder (cost=4.37..12.39 rows=1 width=18) (actual time=0.014..0.014 rows=1 loops=5)

  • Output: mdt_pageorder.data_value
  • Index Cond: ((mdt_pageorder.ts_deletion = 0) AND (mdt_pageorder.lobj_id = l0.lobj_id) AND ((mdt_pageorder.data_key)::text = 'tag'::text) AND (mdt_pageorder.ns_id = $0))
  • Buffers: shared hit=25
27.          

Initplan (for Index Scan)

28. 0.040 0.040 ↑ 1.0 1 1

Seq Scan on dalimes.metadatans (cost=0.00..3.80 rows=1 width=4) (actual time=0.016..0.040 rows=1 loops=1)

  • Output: metadatans.ns_id
  • Filter: (((metadatans.ns_label)::text = 'Retouching Options'::text) AND (metadatans.ts_deletion = 0))
  • Rows Removed by Filter: 119
  • Buffers: shared hit=2
29. 0.000 0.000 ↓ 0.0 0

Index Scan using ixu_mdt_pageorder_lobjidkey on dalimes.mdt_pageorder mdt_pageorder_1 (cost=4.37..12.39 rows=1 width=8) (never executed)

  • Output: mdt_pageorder_1.data_extid
  • Index Cond: ((mdt_pageorder_1.ts_deletion = 0) AND (mdt_pageorder_1.lobj_id = l0.lobj_id) AND ((mdt_pageorder_1.data_key)::text = 'tag'::text) AND (mdt_pageorder_1.ns_id = $2))
30.          

Initplan (for Index Scan)

31. 0.000 0.000 ↓ 0.0 0

Seq Scan on dalimes.metadatans metadatans_1 (cost=0.00..3.80 rows=1 width=4) (never executed)

  • Output: metadatans_1.ns_id
  • Filter: (((metadatans_1.ns_label)::text = 'Retouching Options'::text) AND (metadatans_1.ts_deletion = 0))
32. 0.027 0.045 ↑ 1.0 1 5

Index Scan using ixu_mdt_pageorder_lobjidkey on dalimes.mdt_pageorder mdt_pageorder_2 (cost=4.37..12.39 rows=1 width=18) (actual time=0.009..0.009 rows=1 loops=5)

  • Output: mdt_pageorder_2.data_value
  • Index Cond: ((mdt_pageorder_2.ts_deletion = 0) AND (mdt_pageorder_2.lobj_id = l0.lobj_id) AND ((mdt_pageorder_2.data_key)::text = 'retouch'::text) AND (mdt_pageorder_2.ns_id = $4))
  • Buffers: shared hit=25
33.          

Initplan (for Index Scan)

34. 0.018 0.018 ↑ 1.0 1 1

Seq Scan on dalimes.metadatans metadatans_2 (cost=0.00..3.80 rows=1 width=4) (actual time=0.006..0.018 rows=1 loops=1)

  • Output: metadatans_2.ns_id
  • Filter: (((metadatans_2.ns_label)::text = 'Selection Information'::text) AND (metadatans_2.ts_deletion = 0))
  • Rows Removed by Filter: 119
  • Buffers: shared hit=2
35. 0.000 0.000 ↓ 0.0 0

Index Scan using ixu_mdt_pageorder_lobjidkey on dalimes.mdt_pageorder mdt_pageorder_3 (cost=4.37..12.39 rows=1 width=8) (never executed)

  • Output: mdt_pageorder_3.data_extid
  • Index Cond: ((mdt_pageorder_3.ts_deletion = 0) AND (mdt_pageorder_3.lobj_id = l0.lobj_id) AND ((mdt_pageorder_3.data_key)::text = 'retouch'::text) AND (mdt_pageorder_3.ns_id = $6))
36.          

Initplan (for Index Scan)

37. 0.000 0.000 ↓ 0.0 0

Seq Scan on dalimes.metadatans metadatans_3 (cost=0.00..3.80 rows=1 width=4) (never executed)

  • Output: metadatans_3.ns_id
  • Filter: (((metadatans_3.ns_label)::text = 'Selection Information'::text) AND (metadatans_3.ts_deletion = 0))
38. 0.005 0.020 ↓ 0.0 0 5

Index Scan using ixu_mdt_pageorder_lobjidkey on dalimes.mdt_pageorder mdt_pageorder_4 (cost=4.37..12.39 rows=1 width=18) (actual time=0.004..0.004 rows=0 loops=5)

  • Output: mdt_pageorder_4.data_value
  • Index Cond: ((mdt_pageorder_4.ts_deletion = 0) AND (mdt_pageorder_4.lobj_id = l0.lobj_id) AND ((mdt_pageorder_4.data_key)::text = 'swatch'::text) AND (mdt_pageorder_4.ns_id = $8))
  • Buffers: shared hit=20
39.          

Initplan (for Index Scan)

40. 0.015 0.015 ↑ 1.0 1 1

Seq Scan on dalimes.metadatans metadatans_4 (cost=0.00..3.80 rows=1 width=4) (actual time=0.005..0.015 rows=1 loops=1)

  • Output: metadatans_4.ns_id
  • Filter: (((metadatans_4.ns_label)::text = 'Selection Information'::text) AND (metadatans_4.ts_deletion = 0))
  • Rows Removed by Filter: 119
  • Buffers: shared hit=2
41. 0.003 0.020 ↓ 0.0 0 5

Index Scan using ixu_mdt_pageorder_lobjidkey on dalimes.mdt_pageorder mdt_pageorder_5 (cost=4.37..12.39 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=5)

  • Output: mdt_pageorder_5.data_extid
  • Index Cond: ((mdt_pageorder_5.ts_deletion = 0) AND (mdt_pageorder_5.lobj_id = l0.lobj_id) AND ((mdt_pageorder_5.data_key)::text = 'swatch'::text) AND (mdt_pageorder_5.ns_id = $10))
  • Buffers: shared hit=20
42.          

Initplan (for Index Scan)

43. 0.017 0.017 ↑ 1.0 1 1

Seq Scan on dalimes.metadatans metadatans_5 (cost=0.00..3.80 rows=1 width=4) (actual time=0.006..0.017 rows=1 loops=1)

  • Output: metadatans_5.ns_id
  • Filter: (((metadatans_5.ns_label)::text = 'Selection Information'::text) AND (metadatans_5.ts_deletion = 0))
  • Rows Removed by Filter: 119
  • Buffers: shared hit=2
44. 0.013 0.030 ↑ 1.0 1 5

Index Scan using ixu_mdt_pageorder_lobjidkey on dalimes.mdt_pageorder mdt_pageorder_6 (cost=4.37..12.39 rows=1 width=18) (actual time=0.005..0.006 rows=1 loops=5)

  • Output: mdt_pageorder_6.data_value
  • Index Cond: ((mdt_pageorder_6.ts_deletion = 0) AND (mdt_pageorder_6.lobj_id = l0.lobj_id) AND ((mdt_pageorder_6.data_key)::text = 'selection'::text) AND (mdt_pageorder_6.ns_id = $12))
  • Buffers: shared hit=25
45.          

Initplan (for Index Scan)

46. 0.017 0.017 ↑ 1.0 1 1

Seq Scan on dalimes.metadatans metadatans_6 (cost=0.00..3.80 rows=1 width=4) (actual time=0.006..0.017 rows=1 loops=1)

  • Output: metadatans_6.ns_id
  • Filter: (((metadatans_6.ns_label)::text = 'Selection Information'::text) AND (metadatans_6.ts_deletion = 0))
  • Rows Removed by Filter: 119
  • Buffers: shared hit=2
47. 0.000 0.000 ↓ 0.0 0

Index Scan using ixu_mdt_pageorder_lobjidkey on dalimes.mdt_pageorder mdt_pageorder_7 (cost=4.37..12.39 rows=1 width=8) (never executed)

  • Output: mdt_pageorder_7.data_extid
  • Index Cond: ((mdt_pageorder_7.ts_deletion = 0) AND (mdt_pageorder_7.lobj_id = l0.lobj_id) AND ((mdt_pageorder_7.data_key)::text = 'selection'::text) AND (mdt_pageorder_7.ns_id = $14))
48.          

Initplan (for Index Scan)

49. 0.000 0.000 ↓ 0.0 0

Seq Scan on dalimes.metadatans metadatans_7 (cost=0.00..3.80 rows=1 width=4) (never executed)

  • Output: metadatans_7.ns_id
  • Filter: (((metadatans_7.ns_label)::text = 'Selection Information'::text) AND (metadatans_7.ts_deletion = 0))
50. 0.014 0.030 ↑ 1.0 1 5

Index Scan using ixu_mdt_pageorder_lobjidkey on dalimes.mdt_pageorder mdt_pageorder_8 (cost=4.37..12.39 rows=1 width=18) (actual time=0.006..0.006 rows=1 loops=5)

  • Output: mdt_pageorder_8.data_value
  • Index Cond: ((mdt_pageorder_8.ts_deletion = 0) AND (mdt_pageorder_8.lobj_id = l0.lobj_id) AND ((mdt_pageorder_8.data_key)::text = 'shotitemid'::text) AND (mdt_pageorder_8.ns_id = $16))
  • Buffers: shared hit=25
51.          

Initplan (for Index Scan)

52. 0.016 0.016 ↑ 1.0 1 1

Seq Scan on dalimes.metadatans metadatans_8 (cost=0.00..3.80 rows=1 width=4) (actual time=0.008..0.016 rows=1 loops=1)

  • Output: metadatans_8.ns_id
  • Filter: (((metadatans_8.ns_label)::text = 'Workflow Information'::text) AND (metadatans_8.ts_deletion = 0))
  • Rows Removed by Filter: 119
  • Buffers: shared hit=2
53. 0.000 0.000 ↓ 0.0 0

Index Scan using ixu_mdt_pageorder_lobjidkey on dalimes.mdt_pageorder mdt_pageorder_9 (cost=4.37..12.39 rows=1 width=8) (never executed)

  • Output: mdt_pageorder_9.data_extid
  • Index Cond: ((mdt_pageorder_9.ts_deletion = 0) AND (mdt_pageorder_9.lobj_id = l0.lobj_id) AND ((mdt_pageorder_9.data_key)::text = 'shotitemid'::text) AND (mdt_pageorder_9.ns_id = $18))
54.          

Initplan (for Index Scan)

55. 0.000 0.000 ↓ 0.0 0

Seq Scan on dalimes.metadatans metadatans_9 (cost=0.00..3.80 rows=1 width=4) (never executed)

  • Output: metadatans_9.ns_id
  • Filter: (((metadatans_9.ns_label)::text = 'Workflow Information'::text) AND (metadatans_9.ts_deletion = 0))
Planning time : 10.117 ms
Execution time : 1,447.598 ms