explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nLMN

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 170.485 ↑ 1.0 100 1

Limit (cost=15,615.60..22,476.67 rows=100 width=97) (actual time=168.938..170.485 rows=100 loops=1)

2. 1.594 170.466 ↑ 2.2 100 1

Hash Join (cost=15,615.60..31,053.01 rows=225 width=97) (actual time=168.936..170.466 rows=100 loops=1)

  • Hash Cond: ((pmv.volume_id = performance_metrics_by_volume.volume_id) AND (pmv."timestamp" = (max(performance_metrics
  • -> Seq Scan on performance_metrics_by_volume pmv (cost=0.00..15201.45 rows=44945 width=97) (actual time=0.009..1.17
3. 168.872 168.872 ↓ 1.2 6,755 1

Hash (cost=15,534.42..15,534.42 rows=5,412 width=46) (actual time=168.872..168.872 rows=6,755 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 629kB
  • -> HashAggregate (cost=15426.17..15480.30 rows=5412 width=46) (actual time=164.660..166.377 rows=6755 loops=1
  • Group Key: performance_metrics_by_volume.volume_id
  • -> Seq Scan on performance_metrics_by_volume (cost=0.00..15201.45 rows=44945 width=46) (actual time=0.0
Planning time : 1.366 ms
Execution time : 170.874 ms