explain.depesz.com

PostgreSQL's explain analyze made readable

Result: APKC : Optimization for: plan #JVci

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.051 0.126 ↑ 33.3 6 1

HashAggregate (cost=50.47..53.47 rows=200 width=104) (actual time=0.116..0.126 rows=6 loops=1)

  • Group Key: post.content
2.          

Initplan (forHashAggregate)

3. 0.047 0.047 ↑ 78.6 7 1

Seq Scan on post2 (cost=0.00..18.25 rows=550 width=32) (actual time=0.024..0.047 rows=7 loops=1)

4. 0.028 0.028 ↑ 74.6 17 1

Seq Scan on post (cost=0.00..25.88 rows=1,269 width=36) (actual time=0.018..0.028 rows=17 loops=1)

  • Filter: (post_id <> 6)
  • Rows Removed by Filter: 1