explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vpiF

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 190.550 ↑ 1.0 100 1

Limit (cost=32,058.92..33,661.36 rows=100 width=97) (actual time=190.211..190.550 rows=100 loops=1)

2.          

CTE pmvt

3. 88.152 88.152 ↑ 30.2 179 1

HashAggregate (cost=15,426.17..15,480.30 rows=5,412 width=46) (actual time=88.075..88.152 rows=179 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.010..57.583
4. 0.361 190.536 ↑ 2.2 100 1

Hash Join (cost=16,578.62..20,184.11 rows=225 width=97) (actual time=190.210..190.536 rows=100 loops=1)

  • Hash Cond: ((pmvt.volume_id = pmv.volume_id) AND (pmvt."timestamp" = pmv."timestamp"))
5. 88.242 88.242 ↑ 30.2 179 1

CTE Scan on pmvt (cost=0.00..108.24 rows=5,412 width=40) (actual time=88.079..88.242 rows=179 loops=1)

6. 101.933 101.933 ↑ 1.0 44,945 1

Hash (cost=15,201.45..15,201.45 rows=44,945 width=97) (actual time=101.933..101.933 rows=44,945 loops=1)

  • Buckets: 32768 Batches: 2 Memory Usage: 3071kB
  • -> Seq Scan on performance_metrics_by_volume pmv (cost=0.00..15201.45 rows=44945 width=97) (actual time=0.006
Planning time : 0.328 ms
Execution time : 191.558 ms