explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rwd7 : kk

Settings
# exclusive inclusive rows x rows loops node
1. 43.703 43.809 ↑ 4.2 31 1

Seq Scan on dim_date (cost=0.04..1,371.85 rows=130 width=42) (actual time=0.532..43.809 rows=31 loops=1)

  • Filter: ((yyyymm)::text = ($0)::text)
  • Rows Removed by Filter: 25902
2.          

Initplan (forSeq Scan)

3. 0.106 0.106 ↑ 1.0 1 1

Result (cost=0.00..0.04 rows=1 width=32) (actual time=0.105..0.106 rows=1 loops=1)