explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8KRJ

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

Limit (cost=61.75..61.78 rows=10 width=158) (actual time=0.188..0.189 rows=10 loops=1)

2. 0.051 0.187 ↑ 2.2 10 1

Sort (cost=61.75..61.81 rows=22 width=158) (actual time=0.187..0.187 rows=10 loops=1)

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

Hash Left Join (cost=1.67..61.28 rows=22 width=158) (actual time=0.078..0.136 rows=66 loops=1)

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

Index Scan using view_end_time on cms_content c (cost=0.29..59.59 rows=22 width=12) (actual time=0.050..0.086 rows=22 loops=1)

  • Index Cond: ((now() - '1 day'::interval) <= view_end_time)
5. 0.012 0.018 ↑ 1.0 17 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
6. 0.006 0.006 ↑ 1.0 17 1

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

Planning time : 0.756 ms
Execution time : 0.253 ms