explain.depesz.com

PostgreSQL's explain analyze made readable

Result: v98ee

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 61.356 61.356 ↓ 239.0 239 1

CTE Scan on x (cost=2,733.78..3,231.37 rows=1 width=2,680) (actual time=36.638..61.356 rows=239 loops=1)

  • Filter: ((pricing_mth = 12) AND (pricing_yr = 2018))
  • Rows Removed by Filter: 19664
2.          

CTE x

3. 27.364 27.364 ↑ 1.0 19,903 1

Seq Scan on z1150 (cost=0.00..2,733.78 rows=19,903 width=285) (actual time=0.042..27.364 rows=19,903 loops=1)