explain.depesz.com

PostgreSQL's explain analyze made readable

Result: L9NT

Settings
# exclusive inclusive rows x rows loops node
1. 4,218.222 4,219.147 ↑ 1.0 1 1

Result (cost=4.06..4.32 rows=1 width=4) (actual time=4,219.147..4,219.147 rows=1 loops=1)

2.          

Initplan (for Result)

3. 0.006 0.925 ↑ 1.0 25 1

Limit (cost=0.00..4.06 rows=25 width=37) (actual time=0.874..0.925 rows=25 loops=1)

4. 0.919 0.919 ↑ 80.0 25 1

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

  • Filter: (appliance_id = 'A2'::text)
  • Rows Removed by Filter: 1,943
Planning time : 0.143 ms
Execution time : 4,220.293 ms