explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uhwd

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 2.011 ↑ 1.0 10 1

Limit (cost=691.49..691.52 rows=10 width=158) (actual time=2.008..2.011 rows=10 loops=1)

2. 0.053 2.009 ↑ 154.9 10 1

Sort (cost=691.49..695.37 rows=1,549 width=158) (actual time=2.007..2.009 rows=10 loops=1)

  • Sort Key: c.ordering DESC
  • Sort Method: top-N heapsort Memory: 26kB
3. 0.037 1.956 ↑ 23.5 66 1

Hash Left Join (cost=1.38..658.02 rows=1,549 width=158) (actual time=0.223..1.956 rows=66 loops=1)

  • Hash Cond: (c.section_id = s.id)
4. 1.904 1.904 ↑ 70.4 22 1

Seq Scan on cms_content c (cost=0.00..635.34 rows=1,549 width=12) (actual time=0.197..1.904 rows=22 loops=1)

  • Filter: (now() <= (view_end_time + '1 day'::interval))
  • Rows Removed by Filter: 4626
5. 0.011 0.015 ↑ 1.0 17 1

Hash (cost=1.17..1.17 rows=17 width=150) (actual time=0.015..0.015 rows=17 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 0.004 0.004 ↑ 1.0 17 1

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

Planning time : 0.662 ms
Execution time : 2.063 ms