explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dHQj : Optimization for: plan #dTGY

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 274,739.324 274,739.324 ↑ 1.0 135,450,000 1

Seq Scan on scale_data (cost=0.00..2,214,455.00 rows=135,459,600 width=16) (actual time=41.608..274,739.324 rows=135,450,000 loops=1)

Planning time : 136.821 ms
Execution time : 286,359.133 ms