explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vxyX : d14853-new index

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.743 ↓ 2.5 5 1

Unique (cost=337.41..337.47 rows=2 width=42) (actual time=0.742..0.743 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=301 dirtied=2
2. 0.039 0.741 ↓ 2.5 5 1

Sort (cost=337.41..337.41 rows=2 width=42) (actual time=0.741..0.741 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=301 dirtied=2
3. 0.242 0.702 ↓ 2.5 5 1

Nested Loop Left Join (cost=69.80..337.40 rows=2 width=42) (actual time=0.457..0.702 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=301 dirtied=2
4. 0.009 0.225 ↓ 2.5 5 1

Nested Loop (cost=69.37..85.87 rows=2 width=34) (actual time=0.180..0.225 rows=5 loops=1)

  • Output: l0.lobj_id, l0.lobj_name, l0.ts_lastchange
  • Buffers: shared hit=125
5. 0.002 0.171 ↓ 2.5 5 1

Unique (cost=68.94..68.95 rows=2 width=8) (actual time=0.170..0.171 rows=5 loops=1)

  • Output: pageorderparent.object_id
  • Buffers: shared hit=105
6. 0.006 0.169 ↓ 2.5 5 1

Sort (cost=68.94..68.95 rows=2 width=8) (actual time=0.169..0.169 rows=5 loops=1)

  • Output: pageorderparent.object_id
  • Sort Key: pageorderparent.object_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=105
7. 0.001 0.163 ↓ 2.5 5 1

Append (cost=1.40..68.93 rows=2 width=8) (actual time=0.122..0.163 rows=5 loops=1)

  • Buffers: shared hit=105
8. 0.002 0.083 ↓ 0.0 0 1

Nested Loop Semi Join (cost=1.40..50.87 rows=1 width=8) (actual time=0.083..0.083 rows=0 loops=1)

  • Output: pageorderparent.object_id
  • Buffers: shared hit=40
9. 0.004 0.071 ↓ 5.0 5 1

Nested Loop (cost=1.12..17.17 rows=1 width=16) (actual time=0.041..0.071 rows=5 loops=1)

  • Output: pageorderparent.object_id, pageorderparent.parent_id
  • Buffers: shared hit=30
10. 0.037 0.037 ↓ 5.0 5 1

Index Scan using ix_mdt_pageorder_value on dalimes.mdt_pageorder mtd0 (cost=0.69..8.71 rows=1 width=8) (actual time=0.030..0.037 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.ns_id = 47) AND ((mtd0.data_key)::text = 'shotitemid'::text) AND ((mtd0.data_value)::text = '662014'::text))
  • Buffers: shared hit=10
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.005..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.010 0.010 ↓ 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.002..0.002 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 0.079 ↓ 5.0 5 1

Nested Loop Semi Join (cost=1.82..18.05 rows=1 width=8) (actual time=0.039..0.079 rows=5 loops=1)

  • Output: pageorderparent_1.object_id
  • Buffers: shared hit=65
17. 0.009 0.031 ↓ 5.0 5 1

Nested Loop (cost=1.12..17.17 rows=1 width=16) (actual time=0.016..0.031 rows=5 loops=1)

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

Index Scan using ix_mdt_pageorder_value on dalimes.mdt_pageorder mtd0_1 (cost=0.69..8.71 rows=1 width=8) (actual time=0.011..0.012 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.ns_id = 47) AND ((mtd0_1.data_key)::text = 'shotitemid'::text) AND ((mtd0_1.data_value)::text = '662014'::text))
  • Buffers: shared hit=10
19. 0.010 0.010 ↑ 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.002..0.002 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.005 0.045 ↑ 1.0 1 5

Nested Loop (cost=0.70..0.86 rows=1 width=16) (actual time=0.009..0.009 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.025 0.025 ↑ 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.005..0.005 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.015 0.015 ↑ 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.003..0.003 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.045 0.045 ↑ 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.009..0.009 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.040 0.040 ↑ 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.008..0.008 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.016 0.065 ↑ 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.010..0.013 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=29 dirtied=2
27.          

Initplan (for Index Scan)

28. 0.049 0.049 ↑ 1.0 1 1

Seq Scan on dalimes.metadatans (cost=0.00..3.80 rows=1 width=4) (actual time=0.017..0.049 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.018 0.035 ↑ 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.007..0.007 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.017 0.017 ↑ 1.0 1 1

Seq Scan on dalimes.metadatans metadatans_2 (cost=0.00..3.80 rows=1 width=4) (actual time=0.004..0.017 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.006 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.014 0.014 ↑ 1.0 1 1

Seq Scan on dalimes.metadatans metadatans_4 (cost=0.00..3.80 rows=1 width=4) (actual time=0.003..0.014 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.007 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.013 0.013 ↑ 1.0 1 1

Seq Scan on dalimes.metadatans metadatans_5 (cost=0.00..3.80 rows=1 width=4) (actual time=0.003..0.013 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.015 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.006..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.015 0.015 ↑ 1.0 1 1

Seq Scan on dalimes.metadatans metadatans_6 (cost=0.00..3.80 rows=1 width=4) (actual time=0.004..0.015 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.011 0.025 ↑ 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.005..0.005 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.014 0.014 ↑ 1.0 1 1

Seq Scan on dalimes.metadatans metadatans_8 (cost=0.00..3.80 rows=1 width=4) (actual time=0.005..0.014 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 : 4.917 ms
Execution time : 1.223 ms