explain.depesz.com

PostgreSQL's explain analyze made readable

Result: snbB

Settings
# exclusive inclusive rows x rows loops node
1. 1,501.080 2,150.397 ↓ 1.0 1,462,000 1

Hash Semi Join (cost=370.00..140,541.90 rows=1,461,708 width=144) (actual time=1,203.433..2,150.397 rows=1,462,000 loops=1)

  • Hash Cond: (performance_metrics_by_volume_rollup_one_day.volume_id = local_internal_volume.id)
2. 646.753 646.753 ↑ 1.0 3,655,000 1

Seq Scan on performance_metrics_by_volume_rollup_one_day (cost=0.00..114,316.02 rows=3,655,002 width=144) (actual time=0.010..646.753 rows=3,655,000 loops=1)

3. 0.707 2.564 ↑ 1.0 2,000 1

Hash (cost=345.00..345.00 rows=2,000 width=37) (actual time=2.564..2.564 rows=2,000 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 151kB
4. 0.255 1.857 ↑ 1.0 2,000 1

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

5. 1.602 1.602 ↑ 1.0 2,000 1

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

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