explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7LgI

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.175 ↑ 1.0 20 1

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

2. 0.033 0.173 ↑ 114.9 20 1

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

3. 0.100 0.100 ↑ 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.025..0.100 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.356 ms
Execution time : 0.247 ms