explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uQix

Settings
# exclusive inclusive rows x rows loops node
1. 0.115 78.448 ↓ 17.0 17 1

Hash Join (cost=15,614.63..16,370.15 rows=1 width=97) (actual time=77.998..78.448 rows=17 loops=1)

  • Hash Cond: ((pmv.volume_id = performance_metrics_by_volume.volume_id) AND (pmv."timestamp" = (max(performance_metrics_by_volume."timestamp"))))
2. 0.498 0.498 ↓ 1.2 169 1

Index Scan using performance_metrics_by_volume_pkey on performance_metrics_by_volume pmv (cost=0.54..755.34 rows=136 width=97) (actual time=0.092..0.498 rows=169 loops=1)

  • Index Cond: (volume_id = ANY ('{VVol_Data_naa.68ccf098005b2607c01cf89c4a6a48d8,c92d44ba-faf1-4e3b-ba7b-d7bf9aae3a68,VVol_Data_naa.68ccf0980087f507142ed5a5ed102595,VVol_Data_naa.68ccf09800131c0a1b3d66b99aeb46c8,3c3bd6fa-5309-46c7-84c3-c445a8aaa057,VVol_Data_naa.68ccf098004ba6acd873cbc7e5c192fa,a51f9b91-2956-4d64-8eaa-de636e98cb32,VVol_Data_naa.68ccf098006a8aad827a44ad38c1481b,fa09345f-c5c8-4523-9a1a-96a4e785c244,VVol_Data_naa.68ccf0980063c05e6f7252e45f85e8b9,21179a14-ab65-4917-a0f3-f8433427d0df,VVol_Data_naa.68ccf098003512c3c938cc47418854ca,0b41baa0-2c12-4c8b-acc8-3856a3fc241d,VVol_Data_naa.68ccf0980063ac5860d3d981597ad5a1,f43f4d2f-9d57-4742-8195-08c93f979b2c,VVol_Data_naa.68ccf09800a29452e9d8cf8656e30b73,06db05e9-9847-49b6-aca4-f0f0a517e5b8}'::text[]))
3. 2.439 77.835 ↓ 1.3 6,755 1

Hash (cost=15,533.56..15,533.56 rows=5,369 width=46) (actual time=77.835..77.835 rows=6,755 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 629kB
4. 22.973 75.396 ↓ 1.3 6,755 1

HashAggregate (cost=15,426.17..15,479.86 rows=5,369 width=46) (actual time=73.761..75.396 rows=6,755 loops=1)

  • Group Key: performance_metrics_by_volume.volume_id
5. 52.423 52.423 ↑ 1.0 44,945 1

Seq Scan on performance_metrics_by_volume (cost=0.00..15,201.45 rows=44,945 width=46) (actual time=0.006..52.423 rows=44,945 loops=1)

  • 15,0-1 Bot
Planning time : 1.060 ms
Execution time : 78.802 ms