explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3e1e

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 3.063 ↑ 1.0 10 1

Limit (cost=642.64..642.66 rows=10 width=158) (actual time=3.061..3.063 rows=10 loops=1)

2. 0.058 3.060 ↑ 2.2 10 1

Sort (cost=642.64..642.69 rows=22 width=158) (actual time=3.060..3.060 rows=10 loops=1)

  • Sort Key: c.ordering DESC
  • Sort Method: top-N heapsort Memory: 26kB
3. 0.084 3.002 ↓ 3.0 66 1

Nested Loop Left Join (cost=0.00..642.16 rows=22 width=158) (actual time=0.325..3.002 rows=66 loops=1)

  • Join Filter: (c.section_id = s.id)
  • Rows Removed by Join Filter: 308
4. 2.874 2.874 ↑ 1.0 22 1

Seq Scan on cms_content c (cost=0.00..635.34 rows=22 width=12) (actual time=0.314..2.874 rows=22 loops=1)

  • Filter: ((now() - '1 day'::interval) <= view_end_time)
  • Rows Removed by Filter: 4626
5. 0.039 0.044 ↑ 1.0 17 22

Materialize (cost=0.00..1.25 rows=17 width=150) (actual time=0.001..0.002 rows=17 loops=22)

6. 0.005 0.005 ↑ 1.0 17 1

Seq Scan on cms_section s (cost=0.00..1.17 rows=17 width=150) (actual time=0.002..0.005 rows=17 loops=1)