explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4DI5 : Optimization for: plan #GiJP

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 1.433 1.433 ↑ 1.0 843 1

CTE Scan on t (cost=24.18..41.04 rows=843 width=81) (actual time=0.033..1.433 rows=843 loops=1)

2.          

CTE t

3. 0.760 0.760 ↑ 1.0 843 1

Seq Scan on tz (cost=0.00..24.18 rows=843 width=39) (actual time=0.027..0.760 rows=843 loops=1)

  • Filter: (NOT is_dst)
  • Rows Removed by Filter: 375
Planning time : 0.177 ms
Execution time : 1.697 ms