explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 84CW

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 72.950 ↓ 0.0 0 1

Nested Loop (cost=15,426.72..15,507.60 rows=1 width=97) (actual time=72.950..72.950 rows=0 loops=1)

2. 0.004 72.829 ↑ 1.0 1 1

Limit (cost=15,426.18..15,426.18 rows=1 width=46) (actual time=72.827..72.829 rows=1 loops=1)

3. 12.342 72.825 ↑ 44,945.0 1 1

Sort (cost=15,426.18..15,538.54 rows=44,945 width=46) (actual time=72.825..72.825 rows=1 loops=1)

  • Sort Key: performance_metrics_by_volume.volume_id, performance_metrics_by_volume."timestamp
  • Sort Method: top-N heapsort Memory: 25kB
4. 60.483 60.483 ↑ 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.043..60.483 rows=44,945 loops=1)

5. 0.109 0.109 ↓ 0.0 0 1

Index Scan using performance_metrics_by_volume_pkey on performance_metrics_by_volume pmv (cost=0.54..81.40 rows=1 width=97) (actual time=0.109..0.109 rows=0 loops=1)

  • Index Cond: ((volume_id = performance_metrics_by_volume.volume_id) AND (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[])) AND ("timestamp" = performance_metrics_by_volume."timestamp"))
  • 14,0-1 Bot
Planning time : 1.378 ms
Execution time : 73.020 ms