explain.depesz.com

PostgreSQL's explain analyze made readable

Result: u3Om

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.272 ↑ 1.0 20 1

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

2. 0.051 0.268 ↑ 114.9 20 1

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

3. 0.157 0.157 ↑ 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.023..0.157 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.060 0.060 ↑ 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.003..0.003 rows=1 loops=20)

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