explain.depesz.com

A tool for finding a real cause for slow queries.

Result: mpd

options
# exclusive inclusive rows x rows loops node
1. 0.003 3306.380 ↑ 34.0 1 1
→

Unique (cost=1767.59..1767.93 rows=34 width=12) (actual time=3306.376..3306.380 rows=1 loops=1)

  • Output: contentind0_.cix_lcontentkey, sectioncon1_.sco_mei_lkey, sectioncon1_.sco_lorder
  • Buffers: shared hit=1108824
2. 0.020 3306.377 ↑ 2.6 13 1
→

Sort (cost=1767.59..1767.67 rows=34 width=12) (actual time=3306.375..3306.377 rows=13 loops=1)

  • Output: contentind0_.cix_lcontentkey, sectioncon1_.sco_mei_lkey, sectioncon1_.sco_lorder
  • Sort Key: sectioncon1_.sco_lorder, contentind0_.cix_lcontentkey
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1108824
3. 0.012 3306.357 ↑ 2.6 13 1
→

Nested Loop Semi Join (cost=0.00..1766.72 rows=34 width=12) (actual time=209.022..3306.357 rows=13 loops=1)

  • Output: contentind0_.cix_lcontentkey, sectioncon1_.sco_mei_lkey, sectioncon1_.sco_lorder
  • Buffers: shared hit=1108824
4. 4.485 3305.734 ↑ 2.6 13 1
→

Nested Loop Semi Join (cost=0.00..1492.42 rows=34 width=20) (actual time=208.962..3305.734 rows=13 loops=1)

  • Output: contentind0_.cix_lcontentkey, sectioncon1_.sco_mei_lkey, sectioncon1_.sco_lorder, sectioncon1_.sco_con_lkey, contentind2_.cix_lcontentkey
  • Buffers: shared hit=1108772
5. 1.932 6.377 ↓ 203.6 6922 1
→

Nested Loop (cost=0.00..142.31 rows=34 width=16) (actual time=0.018..6.377 rows=6922 loops=1)

  • Output: contentind0_.cix_lcontentkey, sectioncon1_.sco_mei_lkey, sectioncon1_.sco_lorder, sectioncon1_.sco_con_lkey
  • Buffers: shared hit=809
6. 0.021 0.021 ↓ 2.7 8 1
→

Index Scan using idx_sco2_7 on public.tsectioncontent2 sectioncon1_ (cost=0.00..12.35 rows=3 width=12) (actual time=0.008..0.021 rows=8 loops=1)

  • Output: sectioncon1_.sco_lkey, sectioncon1_.sco_con_lkey, sectioncon1_.sco_mei_lkey, sectioncon1_.sco_lorder, sectioncon1_.sco_bapproved, sectioncon1_.sco_dtetimestamp
  • Index Cond: ((sectioncon1_.sco_bapproved = 1) AND (sectioncon1_.sco_mei_lkey = 303))
  • Buffers: shared hit=11
7. 4.424 4.424 ↓ 78.6 865 8
→

Index Scan using idx_cix_2 on public.tcontentindex contentind0_ (cost=0.00..43.18 rows=11 width=4) (actual time=0.007..0.553 rows=865 loops=8)

  • Output: contentind0_.cix_skey, contentind0_.cix_lcontentkey, contentind0_.cix_lcontentstatus, contentind0_.cix_dtepublishfrom, contentind0_.cix_dtepublishto, contentind0_.cix_lcontenttypekey, contentind0_.cix_lcategorykey, contentind0_.cix_spath, contentind0_.cix_svalue, contentind0_.cix_sordervalue, contentind0_.cix_fnumvalue
  • Index Cond: (contentind0_.cix_lcontentkey = sectioncon1_.sco_con_lkey)
  • Filter: ((contentind0_.cix_dtepublishfrom <= '2012-05-10 14:56:00'::timestamp without time zone) AND ((contentind0_.cix_dtepublishto IS NULL) OR (contentind0_.cix_dtepublishto > '2012-05-10 14:56:00'::timestamp without time zone)) AND (contentind0_.cix_lcontentstatus = 2))
  • Buffers: shared hit=798
8. 3294.872 3294.872 ↓ 0.0 0 6922
→

Index Scan using idx_cix_2 on public.tcontentindex contentind2_ (cost=0.00..39.70 rows=1 width=4) (actual time=0.476..0.476 rows=0 loops=6922)

  • Output: contentind2_.cix_skey, contentind2_.cix_lcontentkey, contentind2_.cix_lcontentstatus, contentind2_.cix_dtepublishfrom, contentind2_.cix_dtepublishto, contentind2_.cix_lcontenttypekey, contentind2_.cix_lcategorykey, contentind2_.cix_spath, contentind2_.cix_svalue, contentind2_.cix_sordervalue, contentind2_.cix_fnumvalue
  • Index Cond: (contentind2_.cix_lcontentkey = contentind0_.cix_lcontentkey)
  • Filter: (((contentind2_.cix_spath)::text ~~ 'contenttype'::text) AND ((contentind2_.cix_svalue)::text = 'page-document'::text))
  • Buffers: shared hit=1107963
9. 0.611 0.611 ↑ 1.0 1 13
→

Index Scan using idx_coa_4 on public.tconaccessright2 contentacc3_ (cost=0.00..8.06 rows=1 width=4) (actual time=0.047..0.047 rows=1 loops=13)

  • Output: contentacc3_.coa_skey, contentacc3_.coa_con_lkey, contentacc3_.coa_grp_hkey, contentacc3_.coa_bread, contentacc3_.coa_bupdate, contentacc3_.coa_bdelete
  • Index Cond: ((contentacc3_.coa_bread = 1) AND (contentacc3_.coa_grp_hkey = '1879233DDDE40197C2277F3177E29FE829291F7E'::bpchar) AND (contentacc3_.coa_con_lkey = contentind0_.cix_lcontentkey))
  • Buffers: shared hit=52