explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OTHU

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 0.306 ↑ 1.0 20 1

Limit (cost=0.42..21.83 rows=20 width=1,066) (actual time=0.037..0.306 rows=20 loops=1)

2. 0.050 0.299 ↑ 114.9 20 1

Nested Loop Left Join (cost=0.42..2,460.53 rows=2,298 width=1,066) (actual time=0.036..0.299 rows=20 loops=1)

3. 0.209 0.209 ↑ 114.9 20 1

Index Scan Backward using ordering on cms_content c (cost=0.28..2,063.61 rows=2,298 width=920) (actual time=0.024..0.209 rows=20 loops=1)

  • Filter: (published AND (category_id = 0) AND ((view_begin_time < now()) OR (view_begin_time IS NULL)) AND (((now() - '1 day'::interval) <= view_end_time) OR (view_end_time IS NULL)))
  • Rows Removed by Filter: 9
4. 0.040 0.040 ↑ 1.0 1 20

Index Scan using cms_section_pkey on cms_section s (cost=0.14..0.16 rows=1 width=162) (actual time=0.002..0.002 rows=1 loops=20)

  • Index Cond: ((c.section_id = id) AND ((c.lang)::text = (lang)::text))
Planning time : 1.467 ms
Execution time : 0.372 ms