explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RPpl

Settings
# exclusive inclusive rows x rows loops node
1. 7,427.751 448,553.744 ↓ 216.7 112,704 1

Sort (cost=5,317,578.91..5,317,580.21 rows=520 width=1,330) (actual time=446,822.191..448,553.744 rows=112,704 loops=1)

  • Output: e.id, e.name, e.originalname, e.entitytypeid, e.created, e.releasetypeid, e.uid, e.publicationid, e.first_price_publication_date, ((SubPlan 3)), ((SubPlan 4)), ((SubPlan 10)), ((SubPlan 13)), ((SubPlan 16))
  • Sort Key: e.id
  • Sort Method: external sort Disk: 1751520kB
  • Buffers: shared hit=121443873 read=31084 dirtied=5739, temp read=218940 written=218940
2.          

CTE entity

3. 367.802 3,186.183 ↓ 216.7 112,704 1

Nested Loop Left Join (cost=1.13..313,770.88 rows=520 width=135) (actual time=0.061..3,186.183 rows=112,704 loops=1)

  • Output: e_1.id, e_1.name, e_1.originalname, e_1.entitytypeid, date_part('epoch'::text, (e_1.creationtimestamp)::timestamp without time zone), t_entity_publication.releasetypeid, e_1.uid, t_entity_publication.id, fpp.first_price_publication_date
  • Inner Unique: true
  • Join Filter: ((fpp.showcaseid)::text = (t_entity_publication.showcaseid)::text)
  • Buffers: shared hit=1236351 read=2 dirtied=27
4. 130.601 2,480.269 ↓ 216.7 112,704 1

Nested Loop (cost=0.84..313,598.12 rows=520 width=128) (actual time=0.052..2,480.269 rows=112,704 loops=1)

  • Output: e_1.id, e_1.name, e_1.originalname, e_1.entitytypeid, e_1.creationtimestamp, e_1.uid, t_entity_publication.releasetypeid, t_entity_publication.id, t_entity_publication.showcaseid
  • Inner Unique: true
  • Buffers: shared hit=990992 dirtied=8
5. 655.703 1,672.082 ↓ 215.9 112,931 1

Index Scan using i_entity_publication on video.t_entity_publication (cost=0.42..312,480.55 rows=523 width=26) (actual time=0.042..1,672.082 rows=112,931 loops=1)

  • Output: t_entity_publication.id, t_entity_publication.entityid, t_entity_publication.showcaseid, t_entity_publication.deleted, t_entity_publication.published, t_entity_publication.creationtimestamp, t_entity_publication.publicationtimestamp, t_entity_publication.publishto, t_entity_publication.publishfrom, t_entity_publication.finished, t_entity_publication.releasetypeid
  • Index Cond: ((t_entity_publication.showcaseid)::text = 'gamma'::text)
  • Filter: ((NOT t_entity_publication.deleted) AND (t_entity_publication.id = (SubPlan 1)))
  • Rows Removed by Filter: 2148
  • Buffers: shared hit=538962 dirtied=8
6.          

SubPlan (forIndex Scan)

7. 338.793 1,016.379 ↑ 1.0 1 112,931

Aggregate (cost=2.64..2.65 rows=1 width=8) (actual time=0.009..0.009 rows=1 loops=112,931)

  • Output: max(t_entity_publication_1.id)
  • Buffers: shared hit=454515 dirtied=1
8. 677.586 677.586 ↑ 1.0 1 112,931

Index Scan using i_entity_publication on video.t_entity_publication t_entity_publication_1 (cost=0.42..2.64 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=112,931)

  • Output: t_entity_publication_1.id, t_entity_publication_1.entityid, t_entity_publication_1.showcaseid, t_entity_publication_1.deleted, t_entity_publication_1.published, t_entity_publication_1.creationtimestamp, t_entity_publication_1.publicationtimestamp, t_entity_publication_1.publishto, t_entity_publication_1.publishfrom, t_entity_publication_1.finished, t_entity_publication_1.releasetypeid
  • Index Cond: ((t_entity_publication_1.entityid = t_entity_publication.entityid) AND ((t_entity_publication_1.showcaseid)::text = (t_entity_publication.showcaseid)::text))
  • Filter: (t_entity_publication_1.published OR (NOT t_entity_publication_1.finished))
  • Buffers: shared hit=454515 dirtied=1
9. 677.586 677.586 ↑ 1.0 1 112,931

Index Scan using pk_t_entity on video.t_entity e_1 (cost=0.42..2.13 rows=1 width=113) (actual time=0.006..0.006 rows=1 loops=112,931)

  • Output: e_1.id, e_1.uid, e_1.entitytypeid, e_1.sourceid, e_1.creationtimestamp, e_1.deleted, e_1.name, e_1.originalname, e_1.needspublication, e_1.publicationtimestamp, e_1.metadatachecked, e_1.entitychanged, e_1.modificationtimestamp, e_1.publicationpricecategoryid, e_1.publishto, e_1.publishfrom, e_1.typograftimestamp, e_1.statusid, e_1.anonsmetadatachecked
  • Index Cond: (e_1.id = t_entity_publication.entityid)
  • Filter: ((((t_entity_publication.releasetypeid = 1) AND e_1.metadatachecked) OR ((t_entity_publication.releasetypeid = 2) AND e_1.anonsmetadatachecked) OR t_entity_publication.published) AND (e_1.entitytypeid = ANY ('{3,4,5,6,7,8,9,11,13,17,18,20,21,22,23,26,27,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45}'::integer[])))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=452030
10. 338.112 338.112 ↓ 0.0 0 112,704

Index Scan using t_entity_price_first_date_publication_entityid_showcaseid_pk on video.t_entity_price_first_date_publication fpp (cost=0.29..0.31 rows=1 width=21) (actual time=0.003..0.003 rows=0 loops=112,704)

  • Output: fpp.entityid, fpp.entityuid, fpp.showcaseid, fpp.first_price_publication_date
  • Index Cond: ((fpp.entityid = e_1.id) AND ((fpp.showcaseid)::text = 'gamma'::text))
  • Buffers: shared hit=245359 read=2 dirtied=19
11. 7,779.113 441,125.993 ↓ 216.7 112,704 1

CTE Scan on entity e (cost=0.00..5,003,784.57 rows=520 width=1,330) (actual time=8.039..441,125.993 rows=112,704 loops=1)

  • Output: e.id, e.name, e.originalname, e.entitytypeid, e.created, e.releasetypeid, e.uid, e.publicationid, e.first_price_publication_date, (SubPlan 3), (SubPlan 4), (SubPlan 10), (SubPlan 13), (SubPlan 16)
  • Buffers: shared hit=121443873 read=31084 dirtied=5739
12.          

SubPlan (forCTE Scan)

13. 2,366.784 2,366.784 ↑ 3.6 10 112,704

Index Scan using ix_entity_link_entity on video.t_entity_link l (cost=0.43..38.21 rows=36 width=32) (actual time=0.006..0.021 rows=10 loops=112,704)

  • Output: ROW(l.entitypid, l.roleid, l.ismain, l.rank, l.description)
  • Index Cond: (l.entityid = e.id)
  • Filter: (((l.roleid >= '-1'::integer) AND (l.roleid <= 22)) OR (l.roleid = ANY ('{24,25,28,29,30,31,32,33,34,36,38,40,41,42}'::integer[])))
  • Buffers: shared hit=1483654 read=290 dirtied=5691
14. 338.112 4,620.864 ↑ 1.6 7 112,704

Append (cost=0.57..26.13 rows=11 width=32) (actual time=0.021..0.041 rows=7 loops=112,704)

  • Buffers: shared hit=1858651 read=237
15. 495.408 2,254.080 ↑ 1.0 1 112,704

Nested Loop (cost=0.57..7.81 rows=1 width=32) (actual time=0.017..0.020 rows=1 loops=112,704)

  • Output: ROW(t.id, t.code, t.datatype, m.valuetext, m.valuenum, m.valuedate, m.listitem, v.valueid, v.valuetext, v.valuedescription, date_part('epoch'::text, m.valuets))
  • Join Filter: (m.listitem = v.valueid)
  • Rows Removed by Join Filter: 2
  • Buffers: shared hit=911535 read=237
16. 274.704 1,465.152 ↑ 1.0 1 112,704

Nested Loop (cost=0.57..6.56 rows=1 width=150) (actual time=0.011..0.013 rows=1 loops=112,704)

  • Output: m.valuetext, m.valuenum, m.valuedate, m.listitem, m.valuets, m.metadatatypeid, t.id, t.code, t.datatype
  • Buffers: shared hit=852831 read=237
17. 1,014.336 1,014.336 ↑ 1.0 1 112,704

Index Scan using ix_entity_metadata on video.t_entity_metadata m (cost=0.42..4.19 rows=1 width=129) (actual time=0.007..0.009 rows=1 loops=112,704)

  • Output: m.id, m.metadatatypeid, m.languageid, m.entityid, m.valuetext, m.valuenum, m.valuedate, m.listitem, m.valuets
  • Index Cond: ((m.metadatatypeid = 105) AND (m.languageid = ANY ('{1,2}'::integer[])) AND (m.entityid = e.id))
  • Buffers: shared hit=735423 read=237
18. 176.112 176.112 ↑ 1.0 1 58,704

Index Scan using pk_td_metadata_type on video.td_metadata_type t (cost=0.14..2.36 rows=1 width=21) (actual time=0.002..0.003 rows=1 loops=58,704)

  • Output: t.id, t.name, t.description, t.code, t.datatype, t.localizable, t.masktype, t.editmask, t.listattached, t.multivalue, t.expliciteditor, t.displaytype, t.userdefined, t.visibleinfilter, t.groupid
  • Index Cond: (t.id = 105)
  • Buffers: shared hit=117408
19. 293.520 293.520 ↓ 5.0 5 58,704

Seq Scan on video.t_metadata_lookup_values v (cost=0.00..1.24 rows=1 width=1,040) (actual time=0.004..0.005 rows=5 loops=58,704)

  • Output: v.id, v.metadatatypeid, v.valueid, v.valuetext, v.valuenum, v.valuedate, v.valuedescription
  • Filter: (v.metadatatypeid = 105)
  • Rows Removed by Filter: 14
  • Buffers: shared hit=58704
20. 676.135 2,028.672 ↑ 1.7 6 112,704

Hash Join (cost=6.81..18.21 rows=10 width=32) (actual time=0.007..0.018 rows=6 loops=112,704)

  • Output: ROW(t_1.id, t_1.code, t_1.datatype, m_1.valuetext, m_1.valuenum, m_1.valuedate, m_1.listitem, 0, NULL::text, NULL::text, date_part('epoch'::text, m_1.valuets))
  • Inner Unique: true
  • Hash Cond: (m_1.metadatatypeid = t_1.id)
  • Buffers: shared hit=947116
21. 1,352.448 1,352.448 ↑ 1.4 7 112,704

Index Scan using ix_entity_metadata_entity on video.t_entity_metadata m_1 (cost=0.42..11.77 rows=10 width=129) (actual time=0.005..0.012 rows=7 loops=112,704)

  • Output: m_1.id, m_1.metadatatypeid, m_1.languageid, m_1.entityid, m_1.valuetext, m_1.valuenum, m_1.valuedate, m_1.listitem, m_1.valuets
  • Index Cond: (m_1.entityid = e.id)
  • Filter: (m_1.languageid = ANY ('{1,2}'::integer[]))
  • Buffers: shared hit=943948
22. 0.038 0.089 ↑ 1.0 135 1

Hash (cost=4.70..4.70 rows=135 width=21) (actual time=0.089..0.089 rows=135 loops=1)

  • Output: t_1.id, t_1.code, t_1.datatype
  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
  • Buffers: shared hit=3
23. 0.051 0.051 ↑ 1.0 135 1

Seq Scan on video.td_metadata_type t_1 (cost=0.00..4.70 rows=135 width=21) (actual time=0.013..0.051 rows=135 loops=1)

  • Output: t_1.id, t_1.code, t_1.datatype
  • Filter: (t_1.id <> 105)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=3
24. 57,063.627 423,767.040 ↑ 2.1 32 112,704

Hash Join (cost=35.26..9,419.63 rows=68 width=32) (actual time=0.111..3.760 rows=32 loops=112,704)

  • Output: ROW((SubPlan 5), f.filepath, f.filetypeid, f.filesize, fp.shardname, (SubPlan 6), f.uid, f.id, f.parentid, fp.unixpath, f.fileurl, (SubPlan 9))
  • Inner Unique: true
  • Hash Cond: (f.partitionid = fp.id)
  • Buffers: shared hit=115970243 read=28728 dirtied=1
25. 3,719.080 14,989.632 ↑ 2.1 32 112,704

Hash Join (cost=16.75..196.09 rows=68 width=224) (actual time=0.013..0.133 rows=32 loops=112,704)

  • Output: f.id, f.filetypeid, f.filepath, f.filesize, f.uid, f.parentid, f.fileurl, f.partitionid, ft.id
  • Inner Unique: true
  • Hash Cond: (f.filetypeid = ft.id)
  • Buffers: shared hit=3098807 read=14274 dirtied=1
26. 11,270.400 11,270.400 ↑ 2.5 40 112,704

Index Scan using ix_entity_file on video.t_entity_file f (cost=0.43..179.51 rows=98 width=220) (actual time=0.007..0.100 rows=40 loops=112,704)

  • Output: f.id, f.uid, f.deleted, f.entityid, f.filetypeid, f.languageid, f.creationtimestamp, f.filepath, f.filesize, f.partitionid, f.isdirectory, f.groupuid, f.checksum, f.parentid, f.fileurl, f.hidden
  • Index Cond: (f.entityid = e.id)
  • Filter: ((NOT f.deleted) AND (NOT f.hidden))
  • Rows Removed by Filter: 28
  • Buffers: shared hit=3098801 read=14274 dirtied=1
27. 0.051 0.152 ↓ 1.1 319 1

Hash (cost=12.55..12.55 rows=301 width=4) (actual time=0.152..0.152 rows=319 loops=1)

  • Output: ft.id
  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
  • Buffers: shared hit=6
28. 0.101 0.101 ↓ 1.1 319 1

Seq Scan on video.td_file_type ft (cost=0.00..12.55 rows=301 width=4) (actual time=0.012..0.101 rows=319 loops=1)

  • Output: ft.id
  • Filter: ((ft.direction = 2) OR (ft.direction = 3))
  • Rows Removed by Filter: 118
  • Buffers: shared hit=6
29. 0.083 0.243 ↑ 1.0 378 1

Hash (cost=13.78..13.78 rows=378 width=37) (actual time=0.243..0.243 rows=378 loops=1)

  • Output: fp.shardname, fp.unixpath, fp.id
  • Buckets: 1024 Batches: 1 Memory Usage: 35kB
  • Buffers: shared hit=10
30. 0.160 0.160 ↑ 1.0 378 1

Seq Scan on video.td_file_partition fp (cost=0.00..13.78 rows=378 width=37) (actual time=0.036..0.160 rows=378 loops=1)

  • Output: fp.shardname, fp.unixpath, fp.id
  • Buffers: shared hit=10
31.          

SubPlan (forHash Join)

32. 39,079.282 259,344.326 ↑ 3.3 3 3,552,662

Append (cost=1.81..53.07 rows=10 width=32) (actual time=0.032..0.073 rows=3 loops=3,552,662)

  • Buffers: shared hit=90899590 read=14428
33. 7,105.306 21,315.972 ↑ 5.0 1 3,552,662

Hash Join (cost=1.81..4.30 rows=5 width=32) (actual time=0.005..0.006 rows=1 loops=3,552,662)

  • Output: ROW(fmt.id, fmt.code, fmt.datatype, fm.valuetext, fm.valuenum, fm.valuedate, date_part('epoch'::text, fm.valuets))
  • Inner Unique: true
  • Hash Cond: (fm.metadatatypeid = fmt.id)
  • Buffers: shared hit=12217842 read=14426
34. 14,210.648 14,210.648 ↑ 5.0 1 3,552,662

Index Scan using ix_entity_file_metadata_entity_file on video.t_entity_file_metadata fm (cost=0.43..2.89 rows=5 width=26) (actual time=0.004..0.004 rows=1 loops=3,552,662)

  • Output: fm.id, fm.metadatatypeid, fm.languageid, fm.entityfileid, fm.valuetext, fm.valuenum, fm.valuedate, fm.valuets
  • Index Cond: (fm.entityfileid = f.id)
  • Buffers: shared hit=12217841 read=14426
35. 0.007 0.018 ↑ 1.0 17 1

Hash (cost=1.17..1.17 rows=17 width=524) (actual time=0.018..0.018 rows=17 loops=1)

  • Output: fmt.id, fmt.code, fmt.datatype
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
36. 0.011 0.011 ↑ 1.0 17 1

Seq Scan on video.td_file_metadata_types fmt (cost=0.00..1.17 rows=17 width=524) (actual time=0.008..0.011 rows=17 loops=1)

  • Output: fmt.id, fmt.code, fmt.datatype
  • Buffers: shared hit=1
37. 20,229.310 74,605.902 ↓ 0.0 0 3,552,662

Hash Join (cost=4.18..16.11 rows=1 width=32) (actual time=0.021..0.021 rows=0 loops=3,552,662)

  • Output: ROW(12, 'description', fmt_1.datatype, keydict.description, fm_1.valuenum, fm_1.valuedate, date_part('epoch'::text, fm_1.valuets))
  • Hash Cond: ((keydict.id)::text = (fm_1.valuetext)::text)
  • Buffers: shared hit=16328260
38. 1,086.662 1,086.662 ↑ 17.5 8 543,331

Seq Scan on video.td_langkey keydict (cost=0.00..11.40 rows=140 width=554) (actual time=0.001..0.002 rows=8 loops=543,331)

  • Output: keydict.id, keydict.description
  • Buffers: shared hit=543331
39. 14,210.648 53,289.930 ↓ 0.0 0 3,552,662

Hash (cost=4.16..4.16 rows=1 width=26) (actual time=0.015..0.015 rows=0 loops=3,552,662)

  • Output: fm_1.valuenum, fm_1.valuedate, fm_1.valuets, fm_1.valuetext, fmt_1.datatype
  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
  • Buffers: shared hit=15784929
40. 7,105.324 39,079.282 ↓ 0.0 0 3,552,662

Nested Loop (cost=0.43..4.16 rows=1 width=26) (actual time=0.011..0.011 rows=0 loops=3,552,662)

  • Output: fm_1.valuenum, fm_1.valuedate, fm_1.valuets, fm_1.valuetext, fmt_1.datatype
  • Join Filter: (fm_1.metadatatypeid = fmt_1.id)
  • Rows Removed by Join Filter: 1
  • Buffers: shared hit=15784929
41. 17,763.310 17,763.310 ↑ 1.0 1 3,552,662

Seq Scan on video.td_file_metadata_types fmt_1 (cost=0.00..1.21 rows=1 width=8) (actual time=0.004..0.005 rows=1 loops=3,552,662)

  • Output: fmt_1.id, fmt_1.name, fmt_1.description, fmt_1.code, fmt_1.datatype, fmt_1.localizable, fmt_1.requirednumber
  • Filter: ((fmt_1.code)::text = 'langkey'::text)
  • Rows Removed by Filter: 16
  • Buffers: shared hit=3552662
42. 14,210.648 14,210.648 ↑ 5.0 1 3,552,662

Index Scan using ix_entity_file_metadata_entity_file on video.t_entity_file_metadata fm_1 (cost=0.43..2.89 rows=5 width=26) (actual time=0.004..0.004 rows=1 loops=3,552,662)

  • Output: fm_1.id, fm_1.metadatatypeid, fm_1.languageid, fm_1.entityfileid, fm_1.valuetext, fm_1.valuenum, fm_1.valuedate, fm_1.valuets
  • Index Cond: (fm_1.entityfileid = f.id)
  • Buffers: shared hit=12232267
43. 2,479.790 3,552.662 ↓ 0.0 0 3,552,662

Result (cost=1.75..4.93 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=3,552,662)

  • Output: (ROW(12, 'description', fmt_2.datatype, keydict_1.name, fm_2.valuenum, fm_2.valuedate, date_part('epoch'::text, fm_2.valuets)))
  • One-Time Filter: (f.filetypeid = ANY ('{3,10,179,183,187,193,200,232,234,330,331,347,348,349,350,351,352,353,354,394,395,396}'::integer[]))
  • Buffers: shared hit=741509 read=1
44. 238.436 1,072.872 ↑ 1.0 1 119,208

Nested Loop (cost=1.75..4.93 rows=1 width=32) (actual time=0.009..0.009 rows=1 loops=119,208)

  • Output: ROW(12, 'description', fmt_2.datatype, keydict_1.name, fm_2.valuenum, fm_2.valuedate, date_part('epoch'::text, fm_2.valuets))
  • Inner Unique: true
  • Buffers: shared hit=741509 read=1
45. 238.401 596.040 ↑ 1.0 1 119,208

Hash Join (cost=1.59..4.07 rows=1 width=536) (actual time=0.004..0.005 rows=1 loops=119,208)

  • Output: fm_2.valuenum, fm_2.valuedate, fm_2.valuets, fm_2.metadatatypeid, keydict_1.name
  • Hash Cond: ((fm_2.valuetext)::text = (keydict_1.code)::text)
  • Buffers: shared hit=503114
46. 357.624 357.624 ↑ 1.7 3 119,208

Index Scan using ix_entity_file_metadata_entity_file on video.t_entity_file_metadata fm_2 (cost=0.43..2.89 rows=5 width=26) (actual time=0.002..0.003 rows=3 loops=119,208)

  • Output: fm_2.id, fm_2.metadatatypeid, fm_2.languageid, fm_2.entityfileid, fm_2.valuetext, fm_2.valuenum, fm_2.valuedate, fm_2.valuets
  • Index Cond: (fm_2.entityfileid = f.id)
  • Buffers: shared hit=503113
47. 0.004 0.015 ↑ 1.0 7 1

Hash (cost=1.07..1.07 rows=7 width=554) (actual time=0.015..0.015 rows=7 loops=1)

  • Output: keydict_1.name, keydict_1.code
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
48. 0.011 0.011 ↑ 1.0 7 1

Seq Scan on video.td_language keydict_1 (cost=0.00..1.07 rows=7 width=554) (actual time=0.009..0.011 rows=7 loops=1)

  • Output: keydict_1.name, keydict_1.code
  • Buffers: shared hit=1
49. 238.396 238.396 ↑ 1.0 1 119,198

Index Scan using pk_td_file_metadata_types on video.td_file_metadata_types fmt_2 (cost=0.14..0.82 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=119,198)

  • Output: fmt_2.id, fmt_2.name, fmt_2.description, fmt_2.code, fmt_2.datatype, fmt_2.localizable, fmt_2.requirednumber
  • Index Cond: (fmt_2.id = fm_2.metadatatypeid)
  • Filter: ((fmt_2.code)::text = 'contentlanguage'::text)
  • Buffers: shared hit=238395 read=1
50. 24,868.634 71,053.240 ↑ 1.0 2 3,552,662

Nested Loop (cost=0.28..10.74 rows=2 width=32) (actual time=0.010..0.020 rows=2 loops=3,552,662)

  • Output: ROW(fmt_3.id, fmt_3.code, fmt_3.datatype, tp.valuetext, NULL::text, NULL::text, NULL::timestamp without time zone)
  • Inner Unique: true
  • Buffers: shared hit=45826714 read=1
51. 10,657.986 10,657.986 ↑ 1.0 5 3,552,662

Seq Scan on video.td_file_metadata_type fmt_3 (cost=0.00..1.05 rows=5 width=524) (actual time=0.002..0.003 rows=5 loops=3,552,662)

  • Output: fmt_3.id, fmt_3.name, fmt_3.description, fmt_3.code, fmt_3.datatype, fmt_3.localizable
  • Buffers: shared hit=3552662
52. 35,526.620 35,526.620 ↓ 0.0 0 17,763,310

Index Scan using ix_file_type_param on video.td_file_type_param tp (cost=0.28..2.06 rows=1 width=19) (actual time=0.002..0.002 rows=0 loops=17,763,310)

  • Output: tp.id, tp.metadatatypeid, tp.filetypeid, tp.valuetext, tp.valuenum, tp.valuedate, tp.valuets
  • Index Cond: ((tp.metadatatypeid = fmt_3.id) AND (tp.filetypeid = f.filetypeid))
  • Buffers: shared hit=42274052 read=1
53. 3,552.514 49,737.268 ↓ 0.0 0 3,552,662

Nested Loop (cost=1.28..16.89 rows=1 width=32) (actual time=0.014..0.014 rows=0 loops=3,552,662)

  • Output: ROW(14, t_2.name, t_2.id, t_2.uid, alias.valuetext, date_part('epoch'::text, (t_2.creationtimestamp)::timestamp without time zone), NULL::timestamp without time zone)
  • Inner Unique: true
  • Buffers: shared hit=15785265
54. 10,657.758 46,184.606 ↓ 0.0 0 3,552,662

Nested Loop (cost=0.86..15.95 rows=2 width=116) (actual time=0.013..0.013 rows=0 loops=3,552,662)

  • Output: fm_3.valuenum, alias.valuetext, alias.entityid
  • Buffers: shared hit=15785117
55. 3,552.662 35,526.620 ↓ 0.0 0 3,552,662

Nested Loop (cost=0.43..4.16 rows=1 width=4) (actual time=0.010..0.010 rows=0 loops=3,552,662)

  • Output: fm_3.valuenum
  • Join Filter: (fm_3.metadatatypeid = fmt_4.id)
  • Rows Removed by Join Filter: 1
  • Buffers: shared hit=15784929
56. 17,763.310 17,763.310 ↑ 1.0 1 3,552,662

Seq Scan on video.td_file_metadata_types fmt_4 (cost=0.00..1.21 rows=1 width=4) (actual time=0.004..0.005 rows=1 loops=3,552,662)

  • Output: fmt_4.id, fmt_4.name, fmt_4.description, fmt_4.code, fmt_4.datatype, fmt_4.localizable, fmt_4.requirednumber
  • Filter: ((fmt_4.code)::text = 'tag_id'::text)
  • Rows Removed by Filter: 16
  • Buffers: shared hit=3552662
57. 14,210.648 14,210.648 ↑ 5.0 1 3,552,662

Index Scan using ix_entity_file_metadata_entity_file on video.t_entity_file_metadata fm_3 (cost=0.43..2.89 rows=5 width=8) (actual time=0.004..0.004 rows=1 loops=3,552,662)

  • Output: fm_3.id, fm_3.metadatatypeid, fm_3.languageid, fm_3.entityfileid, fm_3.valuetext, fm_3.valuenum, fm_3.valuedate, fm_3.valuets
  • Index Cond: (fm_3.entityfileid = f.id)
  • Buffers: shared hit=12232267
58. 0.228 0.228 ↑ 2.0 1 38

Index Scan using ix_entity_metadata_entity on video.t_entity_metadata alias (cost=0.43..11.77 rows=2 width=112) (actual time=0.005..0.006 rows=1 loops=38)

  • Output: alias.id, alias.metadatatypeid, alias.languageid, alias.entityid, alias.valuetext, alias.valuenum, alias.valuedate, alias.listitem, alias.valuets
  • Index Cond: (alias.entityid = (fm_3.valuenum)::bigint)
  • Filter: (alias.metadatatypeid = 132)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=188
59. 0.148 0.148 ↑ 1.0 1 37

Index Scan using pk_t_entity on video.t_entity t_2 (cost=0.42..0.47 rows=1 width=88) (actual time=0.004..0.004 rows=1 loops=37)

  • Output: t_2.id, t_2.uid, t_2.entitytypeid, t_2.sourceid, t_2.creationtimestamp, t_2.deleted, t_2.name, t_2.originalname, t_2.needspublication, t_2.publicationtimestamp, t_2.metadatachecked, t_2.entitychanged, t_2.modificationtimestamp, t_2.publicationpricecategoryid, t_2.publishto, t_2.publishfrom, t_2.typograftimestamp, t_2.statusid, t_2.anonsmetadatachecked
  • Index Cond: (t_2.id = alias.entityid)
  • Filter: (t_2.entitytypeid = 36)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=148
60. 18,957.156 39,079.282 ↓ 0.0 0 3,552,662

Hash Join (cost=2.38..3.60 rows=1 width=516) (actual time=0.010..0.011 rows=0 loops=3,552,662)

  • Output: q.code
  • Inner Unique: true
  • Hash Cond: (q.id = ftq.qualityid)
  • Buffers: shared hit=5125205
61. 2,358.816 2,358.816 ↑ 1.0 17 786,272

Seq Scan on pricing.td_content_quality q (cost=0.00..1.17 rows=17 width=520) (actual time=0.001..0.003 rows=17 loops=786,272)

  • Output: q.id, q.name, q.contenttypeid, q.code, q.quality
  • Buffers: shared hit=786272
62. 7,105.324 17,763.310 ↓ 0.0 0 3,552,662

Hash (cost=2.36..2.36 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=3,552,662)

  • Output: ftq.qualityid
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=4338933
63. 10,657.986 10,657.986 ↓ 0.0 0 3,552,662

Index Scan using tr_file_type_quality_filetypeid_index on video.tr_file_type_quality ftq (cost=0.14..2.36 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=3,552,662)

  • Output: ftq.qualityid
  • Index Cond: (ft.id = ftq.filetypeid)
  • Buffers: shared hit=4338933
64. 3,893.320 53,289.930 ↓ 0.0 0 3,552,662

Nested Loop (cost=1.13..78.69 rows=2 width=32) (actual time=0.012..0.015 rows=0 loops=3,552,662)

  • Output: ROW(t_entity_publication_price.pricecategoryid, t_entity_publication_price.price, t_entity_publication_price.currency, t_entity_publication_price.consumptionmode, date_part('epoch'::text, (t_entity_publication_price.fromdate)::timestamp without time zone), date_part('epoch'::text, (date_trunc('day'::text, (t_entity_publication_price.todate)::timestamp with time zone) + '1 day -00:00:00.001'::interval)), t_entity_publication_price.rentwindow, t_entity_publication_price.watchwindow, t_entity_publication_price.earlywindow, t_entity_publication_price.cardrequired, pf.iscivolutionprotected, t_entity_publication_price.phonerequired, (SubPlan 7), t_entity_publication_price.schemaid, t_entity_publication_price.invisible)
  • Buffers: shared hit=16846631 read=26
65. 3,738.696 46,184.606 ↓ 0.0 0 3,552,662

Nested Loop (cost=0.85..73.28 rows=1 width=41) (actual time=0.011..0.013 rows=0 loops=3,552,662)

  • Output: pf.iscivolutionprotected, t_entity_publication_price.pricecategoryid, t_entity_publication_price.price, t_entity_publication_price.currency, t_entity_publication_price.consumptionmode, t_entity_publication_price.fromdate, t_entity_publication_price.todate, t_entity_publication_price.rentwindow, t_entity_publication_price.watchwindow, t_entity_publication_price.earlywindow, t_entity_publication_price.cardrequired, t_entity_publication_price.phonerequired, t_entity_publication_price.schemaid, t_entity_publication_price.invisible
  • Buffers: shared hit=15398214 read=26
66. 32,989.547 35,526.620 ↓ 0.0 0 3,552,662

Index Scan using ix_entity_publication_price on video.t_entity_publication_price (cost=0.42..12.93 rows=1 width=77) (actual time=0.009..0.010 rows=0 loops=3,552,662)

  • Output: t_entity_publication_price.pricecategoryid, t_entity_publication_price.price, t_entity_publication_price.currency, t_entity_publication_price.deleted, t_entity_publication_price.consumptionmode, t_entity_publication_price.id, t_entity_publication_price.published, t_entity_publication_price.creationtimestamp, t_entity_publication_price.publicationtimestamp, t_entity_publication_price.fileuid, t_entity_publication_price.serviceid, t_entity_publication_price.showcaseid, t_entity_publication_price.fromdate, t_entity_publication_price.todate, t_entity_publication_price.finished, t_entity_publication_price.rentwindow, t_entity_publication_price.watchwindow, t_entity_publication_price.earlywindow, t_entity_publication_price.phonerequired, t_entity_publication_price.cardrequired, t_entity_publication_price.schemaid, t_entity_publication_price.invisible
  • Index Cond: (((t_entity_publication_price.fileuid)::text = (f.uid)::text) AND ((t_entity_publication_price.showcaseid)::text = 'gamma'::text))
  • Filter: ((NOT t_entity_publication_price.deleted) AND (t_entity_publication_price.fromdate < now()) AND (date_part('epoch'::text, (date_trunc('day'::text, (t_entity_publication_price.todate)::timestamp with time zone) + '1 day -00:00:00.001'::interval)) > date_part('epoch'::text, now())) AND (t_entity_publication_price.id = (SubPlan 8)))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=11862411 read=26
67.          

SubPlan (forIndex Scan)

68. 691.929 2,537.073 ↑ 1.0 1 230,643

Aggregate (cost=2.65..2.66 rows=1 width=8) (actual time=0.011..0.011 rows=1 loops=230,643)

  • Output: max(t_entity_publication_price_1.id)
  • Buffers: shared hit=926393
69. 1,845.144 1,845.144 ↑ 1.0 1 230,643

Index Scan using ix_entity_publication_price on video.t_entity_publication_price t_entity_publication_price_1 (cost=0.42..2.65 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=230,643)

  • Output: t_entity_publication_price_1.pricecategoryid, t_entity_publication_price_1.price, t_entity_publication_price_1.currency, t_entity_publication_price_1.deleted, t_entity_publication_price_1.consumptionmode, t_entity_publication_price_1.id, t_entity_publication_price_1.published, t_entity_publication_price_1.creationtimestamp, t_entity_publication_price_1.publicationtimestamp, t_entity_publication_price_1.fileuid, t_entity_publication_price_1.serviceid, t_entity_publication_price_1.showcaseid, t_entity_publication_price_1.fromdate, t_entity_publication_price_1.todate, t_entity_publication_price_1.finished, t_entity_publication_price_1.rentwindow, t_entity_publication_price_1.watchwindow, t_entity_publication_price_1.earlywindow, t_entity_publication_price_1.phonerequired, t_entity_publication_price_1.cardrequired, t_entity_publication_price_1.schemaid, t_entity_publication_price_1.invisible
  • Index Cond: (((t_entity_publication_price_1.fileuid)::text = (t_entity_publication_price.fileuid)::text) AND ((t_entity_publication_price_1.showcaseid)::text = (t_entity_publication_price.showcaseid)::text) AND (t_entity_publication_price_1.pricecategoryid = t_entity_publication_price.pricecategoryid))
  • Filter: (t_entity_publication_price_1.published OR (NOT t_entity_publication_price_1.finished))
  • Buffers: shared hit=926393
70. 6,919.290 6,919.290 ↑ 1.0 1 230,643

Index Scan using ix_entity_publication_file on video.t_entity_publication_file pf (cost=0.43..60.34 rows=1 width=38) (actual time=0.016..0.030 rows=1 loops=230,643)

  • Output: pf.id, pf.publicationid, pf.mediatype, pf.fileuid, pf.iscivolutionprotected, pf.qualityid
  • Index Cond: (pf.publicationid = e.publicationid)
  • Filter: ((pf.fileuid)::text = (f.uid)::text)
  • Rows Removed by Filter: 70
  • Buffers: shared hit=3535803
71. 1,290.832 1,290.832 ↑ 2.0 1 322,708

Index Scan using ix_price_category_quality_pc on pricing.tr_price_category_quality pcq (cost=0.28..2.94 rows=2 width=8) (actual time=0.003..0.004 rows=1 loops=322,708)

  • Output: pcq.qualityid, pcq.pricecategoryid
  • Index Cond: (pcq.pricecategoryid = t_entity_publication_price.pricecategoryid)
  • Buffers: shared hit=968124
72.          

SubPlan (forNested Loop)

73. 1,921.172 1,921.172 ↑ 1.0 1 480,293

Seq Scan on pricing.td_content_quality cq (cost=0.00..1.21 rows=1 width=516) (actual time=0.004..0.004 rows=1 loops=480,293)

  • Output: cq.code
  • Filter: (cq.id = pcq.qualityid)
  • Rows Removed by Filter: 16
  • Buffers: shared hit=480293
74. 279.216 1,127.040 ↓ 0.0 0 112,704

HashAggregate (cost=75.59..116.30 rows=3 width=78) (actual time=0.009..0.010 rows=0 loops=112,704)

  • Output: ROW(setitem_list.mediatype, setitem_list.qualityid, string_agg((setitem_list.description)::text, ';'::text), array_agg(setitempub.itemuid), (SubPlan 12)), setitem_list.entityuid, setitem_list.mediatype, setitem_list.qualityid
  • Group Key: setitem_list.entityuid, setitem_list.mediatype, setitem_list.qualityid
  • Buffers: shared hit=417938 read=1827 dirtied=20
75. 143.112 676.224 ↑ 36.5 2 112,704

Nested Loop (cost=0.70..74.68 rows=73 width=599) (actual time=0.004..0.006 rows=2 loops=112,704)

  • Output: setitem_list.entityuid, setitem_list.mediatype, setitem_list.qualityid, setitem_list.description, setitempub.itemuid
  • Buffers: shared hit=372980 read=1827
76. 338.112 338.112 ↓ 0.0 0 112,704

Index Scan using ix_setitem_list_publication on video.t_setitem_list_publication setitem_list (cost=0.28..4.58 rows=3 width=570) (actual time=0.003..0.003 rows=0 loops=112,704)

  • Output: setitem_list.id, setitem_list.publicationid, setitem_list.mediatype, setitem_list.description, setitem_list.entityuid, setitem_list.qualityid
  • Index Cond: (setitem_list.publicationid = e.publicationid)
  • Buffers: shared hit=229224
77. 195.000 195.000 ↑ 1.2 25 7,800

Index Only Scan using iu_setitem_publication on video.t_setitem_publication setitempub (cost=0.42..23.07 rows=29 width=45) (actual time=0.008..0.025 rows=25 loops=7,800)

  • Output: setitempub.itempublicationid, setitempub.itemuid, setitempub.fileuid
  • Index Cond: (setitempub.itempublicationid = setitem_list.id)
  • Heap Fetches: 193294
  • Buffers: shared hit=143756 read=1827
78.          

SubPlan (forHashAggregate)

79. 50.990 171.600 ↓ 0.0 0 7,800

Nested Loop (cost=0.28..13.55 rows=1 width=32) (actual time=0.020..0.022 rows=0 loops=7,800)

  • Output: ROW(t_setitem_publication_price.pricecategoryid, t_setitem_publication_price.price, t_setitem_publication_price.currency, t_setitem_publication_price.consumptionmode, date_part('epoch'::text, (t_setitem_publication_price.fromdate)::timestamp without time zone), date_part('epoch'::text, (date_trunc('day'::text, (t_setitem_publication_price.todate)::timestamp with time zone) + '1 day -00:00:00.001'::interval)), t_setitem_publication_price.rentwindow, t_setitem_publication_price.watchwindow, t_setitem_publication_price.earlywindow, t_setitem_publication_price.cardrequired, false, t_setitem_publication_price.phonerequired, cq_1.code, t_setitem_publication_price.schemaid, t_setitem_publication_price.invisible)
  • Buffers: shared hit=44958 dirtied=20
80. 70.376 101.400 ↓ 0.0 0 7,800

Index Scan using ix_setitem_publication_price on video.t_setitem_publication_price (cost=0.28..12.32 rows=1 width=44) (actual time=0.012..0.013 rows=0 loops=7,800)

  • Output: t_setitem_publication_price.pricecategoryid, t_setitem_publication_price.price, t_setitem_publication_price.currency, t_setitem_publication_price.deleted, t_setitem_publication_price.consumptionmode, t_setitem_publication_price.id, t_setitem_publication_price.published, t_setitem_publication_price.creationtimestamp, t_setitem_publication_price.publicationtimestamp, t_setitem_publication_price.entityuid, t_setitem_publication_price.serviceid, t_setitem_publication_price.qualityid, t_setitem_publication_price.mediatype, t_setitem_publication_price.showcaseid, t_setitem_publication_price.fromdate, t_setitem_publication_price.todate, t_setitem_publication_price.finished, t_setitem_publication_price.rentwindow, t_setitem_publication_price.watchwindow, t_setitem_publication_price.earlywindow, t_setitem_publication_price.phonerequired, t_setitem_publication_price.cardrequired, t_setitem_publication_price.schemaid, t_setitem_publication_price.invisible
  • Index Cond: (((t_setitem_publication_price.entityuid)::text = (setitem_list.entityuid)::text) AND ((t_setitem_publication_price.showcaseid)::text = 'gamma'::text))
  • Filter: ((NOT t_setitem_publication_price.deleted) AND (t_setitem_publication_price.qualityid = setitem_list.qualityid) AND (t_setitem_publication_price.id = (SubPlan 11)))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=41116 dirtied=20
81.          

SubPlan (forIndex Scan)

82. 7.756 31.024 ↑ 1.0 1 3,878

Aggregate (cost=2.51..2.52 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=3,878)

  • Output: max(t_setitem_publication_price_1.id)
  • Buffers: shared hit=13646 dirtied=19
83. 23.268 23.268 ↑ 1.0 1 3,878

Index Scan using ix_setitem_publication_price on video.t_setitem_publication_price t_setitem_publication_price_1 (cost=0.28..2.51 rows=1 width=8) (actual time=0.005..0.006 rows=1 loops=3,878)

  • Output: t_setitem_publication_price_1.pricecategoryid, t_setitem_publication_price_1.price, t_setitem_publication_price_1.currency, t_setitem_publication_price_1.deleted, t_setitem_publication_price_1.consumptionmode, t_setitem_publication_price_1.id, t_setitem_publication_price_1.published, t_setitem_publication_price_1.creationtimestamp, t_setitem_publication_price_1.publicationtimestamp, t_setitem_publication_price_1.entityuid, t_setitem_publication_price_1.serviceid, t_setitem_publication_price_1.qualityid, t_setitem_publication_price_1.mediatype, t_setitem_publication_price_1.showcaseid, t_setitem_publication_price_1.fromdate, t_setitem_publication_price_1.todate, t_setitem_publication_price_1.finished, t_setitem_publication_price_1.rentwindow, t_setitem_publication_price_1.watchwindow, t_setitem_publication_price_1.earlywindow, t_setitem_publication_price_1.phonerequired, t_setitem_publication_price_1.cardrequired, t_setitem_publication_price_1.schemaid, t_setitem_publication_price_1.invisible
  • Index Cond: (((t_setitem_publication_price_1.entityuid)::text = (t_setitem_publication_price.entityuid)::text) AND ((t_setitem_publication_price_1.showcaseid)::text = (t_setitem_publication_price.showcaseid)::text) AND (t_setitem_publication_price_1.pricecategoryid = t_setitem_publication_price.pricecategoryid))
  • Filter: ((t_setitem_publication_price_1.published OR (NOT t_setitem_publication_price_1.finished)) AND (t_setitem_publication_price_1.qualityid = t_setitem_publication_price.qualityid))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=13646 dirtied=19
84. 19.210 19.210 ↑ 1.0 1 3,842

Seq Scan on pricing.td_content_quality cq_1 (cost=0.00..1.21 rows=1 width=520) (actual time=0.004..0.005 rows=1 loops=3,842)

  • Output: cq_1.id, cq_1.name, cq_1.contenttypeid, cq_1.code, cq_1.quality
  • Filter: (cq_1.id = setitem_list.qualityid)
  • Rows Removed by Filter: 16
  • Buffers: shared hit=3842
85. 225.408 1,465.152 ↓ 0.0 0 112,704

Append (cost=0.28..22.38 rows=2 width=32) (actual time=0.012..0.013 rows=0 loops=112,704)

  • Buffers: shared hit=477036
86. 213.882 901.632 ↓ 0.0 0 112,704

Nested Loop (cost=0.28..13.71 rows=1 width=32) (actual time=0.007..0.008 rows=0 loops=112,704)

  • Output: ROW(t_setitem_publication_price_2.pricecategoryid, t_setitem_publication_price_2.price, t_setitem_publication_price_2.currency, t_setitem_publication_price_2.consumptionmode, date_part('epoch'::text, (t_setitem_publication_price_2.fromdate)::timestamp without time zone), date_part('epoch'::text, (date_trunc('day'::text, (t_setitem_publication_price_2.todate)::timestamp with time zone) + '1 day -00:00:00.001'::interval)), t_setitem_publication_price_2.rentwindow, t_setitem_publication_price_2.watchwindow, t_setitem_publication_price_2.earlywindow, t_setitem_publication_price_2.cardrequired, false, t_setitem_publication_price_2.phonerequired, cq_2.code, t_setitem_publication_price_2.schemaid, t_setitem_publication_price_2.invisible)
  • Inner Unique: true
  • Join Filter: (t_setitem_publication_price_2.qualityid = cq_2.id)
  • Rows Removed by Join Filter: 0
  • Buffers: shared hit=249126
87. 641.322 676.224 ↓ 0.0 0 112,704

Index Scan using ix_setitem_publication_price on video.t_setitem_publication_price t_setitem_publication_price_2 (cost=0.28..12.31 rows=1 width=44) (actual time=0.006..0.006 rows=0 loops=112,704)

  • Output: t_setitem_publication_price_2.pricecategoryid, t_setitem_publication_price_2.price, t_setitem_publication_price_2.currency, t_setitem_publication_price_2.deleted, t_setitem_publication_price_2.consumptionmode, t_setitem_publication_price_2.id, t_setitem_publication_price_2.published, t_setitem_publication_price_2.creationtimestamp, t_setitem_publication_price_2.publicationtimestamp, t_setitem_publication_price_2.entityuid, t_setitem_publication_price_2.serviceid, t_setitem_publication_price_2.qualityid, t_setitem_publication_price_2.mediatype, t_setitem_publication_price_2.showcaseid, t_setitem_publication_price_2.fromdate, t_setitem_publication_price_2.todate, t_setitem_publication_price_2.finished, t_setitem_publication_price_2.rentwindow, t_setitem_publication_price_2.watchwindow, t_setitem_publication_price_2.earlywindow, t_setitem_publication_price_2.phonerequired, t_setitem_publication_price_2.cardrequired, t_setitem_publication_price_2.schemaid, t_setitem_publication_price_2.invisible
  • Index Cond: (((t_setitem_publication_price_2.entityuid)::text = (e.uid)::text) AND ((t_setitem_publication_price_2.showcaseid)::text = 'gamma'::text))
  • Filter: ((NOT t_setitem_publication_price_2.deleted) AND (t_setitem_publication_price_2.id = (SubPlan 14)))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=245284
88.          

SubPlan (forIndex Scan)

89. 11.634 34.902 ↑ 1.0 1 3,878

Aggregate (cost=2.51..2.52 rows=1 width=8) (actual time=0.009..0.009 rows=1 loops=3,878)

  • Output: max(t_setitem_publication_price_1_1.id)
  • Buffers: shared hit=13599
90. 23.268 23.268 ↑ 1.0 1 3,878

Index Scan using ix_setitem_publication_price on video.t_setitem_publication_price t_setitem_publication_price_1_1 (cost=0.28..2.51 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=3,878)

  • Output: t_setitem_publication_price_1_1.pricecategoryid, t_setitem_publication_price_1_1.price, t_setitem_publication_price_1_1.currency, t_setitem_publication_price_1_1.deleted, t_setitem_publication_price_1_1.consumptionmode, t_setitem_publication_price_1_1.id, t_setitem_publication_price_1_1.published, t_setitem_publication_price_1_1.creationtimestamp, t_setitem_publication_price_1_1.publicationtimestamp, t_setitem_publication_price_1_1.entityuid, t_setitem_publication_price_1_1.serviceid, t_setitem_publication_price_1_1.qualityid, t_setitem_publication_price_1_1.mediatype, t_setitem_publication_price_1_1.showcaseid, t_setitem_publication_price_1_1.fromdate, t_setitem_publication_price_1_1.todate, t_setitem_publication_price_1_1.finished, t_setitem_publication_price_1_1.rentwindow, t_setitem_publication_price_1_1.watchwindow, t_setitem_publication_price_1_1.earlywindow, t_setitem_publication_price_1_1.phonerequired, t_setitem_publication_price_1_1.cardrequired, t_setitem_publication_price_1_1.schemaid, t_setitem_publication_price_1_1.invisible
  • Index Cond: (((t_setitem_publication_price_1_1.entityuid)::text = (t_setitem_publication_price_2.entityuid)::text) AND ((t_setitem_publication_price_1_1.showcaseid)::text = (t_setitem_publication_price_2.showcaseid)::text) AND (t_setitem_publication_price_1_1.pricecategoryid = t_setitem_publication_price_2.pricecategoryid))
  • Filter: ((t_setitem_publication_price_1_1.published OR (NOT t_setitem_publication_price_1_1.finished)) AND (t_setitem_publication_price_1_1.qualityid = t_setitem_publication_price_2.qualityid))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=13599
91. 11.526 11.526 ↑ 1.9 9 3,842

Seq Scan on pricing.td_content_quality cq_2 (cost=0.00..1.17 rows=17 width=520) (actual time=0.002..0.003 rows=9 loops=3,842)

  • Output: cq_2.id, cq_2.name, cq_2.contenttypeid, cq_2.code, cq_2.quality
  • Buffers: shared hit=3842
92. 337.440 338.112 ↓ 0.0 0 112,704

Index Scan using ix_entity_publication_simple_price on video.t_entity_publication_simple_price (cost=0.27..8.65 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=112,704)

  • Output: ROW(t_entity_publication_simple_price.pricecategoryid, t_entity_publication_simple_price.price, t_entity_publication_simple_price.currency, t_entity_publication_simple_price.consumptionmode, date_part('epoch'::text, (t_entity_publication_simple_price.fromdate)::timestamp without time zone), date_part('epoch'::text, (date_trunc('day'::text, (t_entity_publication_simple_price.todate)::timestamp with time zone) + '1 day -00:00:00.001'::interval)), NULL::unknown, NULL::unknown, t_entity_publication_simple_price.earlywindow, t_entity_publication_simple_price.cardrequired, t_entity_publication_simple_price.iscivolutionprotected, t_entity_publication_simple_price.phonerequired, t_entity_publication_simple_price.vquality, t_entity_publication_simple_price.schemaid, false)
  • Index Cond: (((t_entity_publication_simple_price.entityuid)::text = (e.uid)::text) AND ((t_entity_publication_simple_price.showcaseid)::text = 'gamma'::text))
  • Filter: ((NOT t_entity_publication_simple_price.deleted) AND (t_entity_publication_simple_price.releasetypeid = e.releasetypeid) AND (t_entity_publication_simple_price.id = (SubPlan 15)))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=227910
93.          

SubPlan (forIndex Scan)

94. 0.192 0.672 ↑ 1.0 1 96

Aggregate (cost=2.50..2.51 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=96)

  • Output: max(t_entity_publication_simple_price_1.id)
  • Buffers: shared hit=297
95. 0.480 0.480 ↑ 1.0 1 96

Index Scan using ix_entity_publication_simple_price on video.t_entity_publication_simple_price t_entity_publication_simple_price_1 (cost=0.27..2.50 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=96)

  • Output: t_entity_publication_simple_price_1.id, t_entity_publication_simple_price_1.pricecategoryid, t_entity_publication_simple_price_1.price, t_entity_publication_simple_price_1.currency, t_entity_publication_simple_price_1.deleted, t_entity_publication_simple_price_1.consumptionmode, t_entity_publication_simple_price_1.creationtimestamp, t_entity_publication_simple_price_1.publicationtimestamp, t_entity_publication_simple_price_1.published, t_entity_publication_simple_price_1.entityuid, t_entity_publication_simple_price_1.showcaseid, t_entity_publication_simple_price_1.serviceid, t_entity_publication_simple_price_1.fromdate, t_entity_publication_simple_price_1.todate, t_entity_publication_simple_price_1.finished, t_entity_publication_simple_price_1.releasetypeid, t_entity_publication_simple_price_1.vquality, t_entity_publication_simple_price_1.earlywindow, t_entity_publication_simple_price_1.iscivolutionprotected, t_entity_publication_simple_price_1.phonerequired, t_entity_publication_simple_price_1.cardrequired, t_entity_publication_simple_price_1.schemaid
  • Index Cond: (((t_entity_publication_simple_price_1.entityuid)::text = (t_entity_publication_simple_price.entityuid)::text) AND ((t_entity_publication_simple_price_1.showcaseid)::text = (t_entity_publication_simple_price.showcaseid)::text) AND (t_entity_publication_simple_price_1.pricecategoryid = t_entity_publication_simple_price.pricecategoryid))
  • Filter: ((t_entity_publication_simple_price_1.published OR (NOT t_entity_publication_simple_price_1.finished)) AND ((t_entity_publication_simple_price_1.vquality)::text = (t_entity_publication_simple_price.vquality)::text))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=297