explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Fl8C

Settings
# exclusive inclusive rows x rows loops node
1. 284.528 284.528 ↑ 5,000.0 1 1

CTE Scan on cte (cost=18,334.00..40,834.00 rows=5,000 width=36) (actual time=205.733..284.528 rows=1 loops=1)

  • Filter: (id = 500000)
  • Rows Removed by Filter: 999999
  • Buffers: shared hit=8334, temp written=5737
2.          

CTE cte

3. 114.974 114.974 ↑ 1.0 1,000,000 1

Seq Scan on foo (cost=0.00..18,334.00 rows=1,000,000 width=37) (actual time=0.014..114.974 rows=1,000,000 loops=1)

  • Buffers: shared hit=8334