explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HuiM

Settings
# exclusive inclusive rows x rows loops node
1. 209,270.197 209,272.419 ↑ 1.0 1 1

Result (cost=325.00..325.26 rows=1 width=4) (actual time=209,272.418..209,272.419 rows=1 loops=1)

2.          

Initplan (for Result)

3. 0.277 2.222 ↑ 1.0 2,000 1

Limit (cost=0.00..325.00 rows=2,000 width=37) (actual time=0.572..2.222 rows=2,000 loops=1)

4. 1.945 1.945 ↑ 1.0 2,000 1

Seq Scan on internal_volume (cost=0.00..325.00 rows=2,000 width=37) (actual time=0.571..1.945 rows=2,000 loops=1)

  • Filter: (appliance_id = 'A2'::text)
  • Rows Removed by Filter: 2,436
Planning time : 0.137 ms
Execution time : 209,272.454 ms