explain.depesz.com

PostgreSQL's explain analyze made readable

Result: q2De

Settings
# exclusive inclusive rows x rows loops node
1. 144,294.388 144,296.194 ↓ 200.2 1,462,000 1

Seq Scan on performance_metrics_by_volume_rollup_one_day (cost=325.00..160,328.54 rows=7,302 width=144) (actual time=98,188.073..144,296.194 rows=1,462,000 loops=1)

  • Filter: (volume_id = ANY ($0))
  • Rows Removed by Filter: 2,193,000
2.          

Initplan (for Seq Scan)

3. 0.258 1.806 ↑ 1.0 2,000 1

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

4. 1.548 1.548 ↑ 1.0 2,000 1

Seq Scan on local_internal_volume (cost=0.00..325.00 rows=2,000 width=37) (actual time=0.570..1.548 rows=2,000 loops=1)

  • Filter: (appliance_id = 'A2'::text)
  • Rows Removed by Filter: 2,436
Planning time : 0.176 ms
Execution time : 144,357.312 ms