explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2HQF

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 43.639 ↑ 1.0 1 1

Limit (cost=100.04..103.04 rows=1 width=4,016) (actual time=43.637..43.639 rows=1 loops=1)

2.          

Initplan (for Limit)

3. 0.002 0.002 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=8) (actual time=0.001..0.002 rows=1 loops=1)

4. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=8) (actual time=0.000..0.001 rows=1 loops=1)

5. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=1)

6. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=1)

7. 0.031 43.636 ↑ 128.0 1 1

GroupAggregate (cost=100.00..484.50 rows=128 width=4,016) (actual time=43.635..43.636 rows=1 loops=1)

  • Group Key: ci.contentitemid, ci.contentid, ci.created, ci.modified, cif.name, ci.duration, ci.title, ci.contenttext, m.mediatype, m.mediaformat, m.name, m.internalurl, m.externalurl, li.text, ci.stateid, ci.sortorder, m.thumbnailpath, ci.description, m.waveformdata, m.cdnurl, m.mediaid, m.cdnthumbnailurl, ci.link, ci.copyrighturl
8. 43.605 43.605 ↑ 64.0 2 1

Foreign Scan (cost=100.00..473.94 rows=128 width=3,992) (actual time=43.604..43.605 rows=2 loops=1)

  • Relations: (((((((public.contentitem ci) INNER JOIN (public.contentcomponent_to_content cp2c)) INNER JOIN (public.contentcomponent cp)) INNER JOIN (public.contentitemformat cif)) LEFT JOIN (public.layoutinfo li)) LEFT JOIN (public.media m)) LEFT JOIN (public.term_to_contentitem t2ci)) LEFT JOIN (public.term cit)
Planning time : 2.098 ms