explain.depesz.com

PostgreSQL's explain analyze made readable

Result: j90q

Settings
# exclusive inclusive rows x rows loops node
1. 29.221 40,281.636 ↓ 709.0 709 1

Unique (cost=36,138.91..36,138.93 rows=1 width=24) (actual time=40,227.039..40,281.636 rows=709 loops=1)

2. 53.429 40,252.415 ↓ 6,367.0 6,367 1

Sort (cost=36,138.91..36,138.92 rows=1 width=24) (actual time=40,227.029..40,252.415 rows=6,367 loops=1)

  • Sort Key: ms.measurement_session_id, ms.measurement_session_start_time, d.die_id, (rank() OVER (?))
  • Sort Method: quicksort Memory: 690kB
3. 56.239 40,198.986 ↓ 6,367.0 6,367 1

WindowAgg (cost=36,138.88..36,138.90 rows=1 width=24) (actual time=40,117.018..40,198.986 rows=6,367 loops=1)

4. 55.912 40,142.747 ↓ 6,367.0 6,367 1

Sort (cost=36,138.88..36,138.88 rows=1 width=16) (actual time=40,117.003..40,142.747 rows=6,367 loops=1)

  • Sort Key: d.die_id, ms.measurement_session_start_time DESC
  • Sort Method: quicksort Memory: 491kB
5. 23,409.231 40,086.835 ↓ 6,367.0 6,367 1

Nested Loop (cost=1,051.45..36,138.87 rows=1 width=16) (actual time=1,053.844..40,086.835 rows=6,367 loops=1)

6. 0.000 10,458.109 ↓ 414,633.0 414,633 1

Gather (cost=1,051.16..36,010.76 rows=1 width=16) (actual time=15.632..10,458.109 rows=414,633 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
7. 3,151.864 27,378.535 ↓ 138,211.0 138,211 3 / 3

Nested Loop (cost=51.16..35,010.66 rows=1 width=16) (actual time=14.631..27,378.535 rows=138,211 loops=3)

8. 3,771.190 22,786.883 ↓ 35,994.8 287,958 3 / 3

Nested Loop (cost=51.01..35,008.77 rows=8 width=20) (actual time=14.595..22,786.883 rows=287,958 loops=3)

9. 3,839.983 17,575.905 ↓ 35,994.8 287,958 3 / 3

Nested Loop (cost=50.86..35,007.43 rows=8 width=20) (actual time=14.566..17,575.905 rows=287,958 loops=3)

10. 3,121.985 12,296.134 ↓ 35,994.8 287,958 3 / 3

Hash Join (cost=50.44..35,003.71 rows=8 width=16) (actual time=14.523..12,296.134 rows=287,958 loops=3)

  • Hash Cond: (cm.measurement_session_id = ms.measurement_session_id)
11. 5,491.980 9,159.777 ↓ 252.9 430,414 3 / 3

Hash Join (cost=8.18..34,954.98 rows=1,702 width=8) (actual time=0.134..9,159.777 rows=430,414 loops=3)

  • Hash Cond: (cm.measurement_type_id = mt.measurement_type_id)
12. 3,667.757 3,667.757 ↑ 1.2 857,782 3 / 3

Parallel Seq Scan on component_measurements cm (cost=0.00..32,113.27 rows=1,072,227 width=12) (actual time=0.030..3,667.757 rows=857,782 loops=3)

13. 0.015 0.040 ↑ 1.0 1 3 / 3

Hash (cost=8.17..8.17 rows=1 width=4) (actual time=0.036..0.040 rows=1 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
14. 0.025 0.025 ↑ 1.0 1 3 / 3

Index Scan using measurement_type_measurement_type_key on measurement_type mt (cost=0.15..8.17 rows=1 width=4) (actual time=0.017..0.025 rows=1 loops=3)

  • Index Cond: ((measurement_type)::text = 'resistance'::text)
15. 3.580 14.372 ↓ 194.0 776 3 / 3

Hash (cost=42.21..42.21 rows=4 width=12) (actual time=14.368..14.372 rows=776 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 45kB
16. 7.061 10.792 ↓ 194.0 776 3 / 3

Hash Join (cost=15.15..42.21 rows=4 width=12) (actual time=0.203..10.792 rows=776 loops=3)

  • Hash Cond: (ms.measurement_method_id = mm.measurement_method_id)
17. 3.557 3.557 ↑ 1.0 795 3 / 3

Seq Scan on measurement_session ms (cost=0.00..24.95 rows=795 width=16) (actual time=0.012..3.557 rows=795 loops=3)

18. 0.081 0.174 ↓ 7.5 15 3 / 3

Hash (cost=15.12..15.12 rows=2 width=4) (actual time=0.171..0.174 rows=15 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
19. 0.093 0.093 ↓ 7.5 15 3 / 3

Seq Scan on measurement_method mm (cost=0.00..15.12 rows=2 width=4) (actual time=0.011..0.093 rows=15 loops=3)

  • Filter: (measurement_context = 'room_temperature'::text)
  • Rows Removed by Filter: 4
20. 1,439.788 1,439.788 ↑ 1.0 1 863,873 / 3

Index Scan using physical_component_pkey on physical_component pc (cost=0.42..0.46 rows=1 width=12) (actual time=0.005..0.005 rows=1 loops=863,873)

  • Index Cond: (physical_component_id = cm.physical_component_id)
21. 1,439.788 1,439.788 ↑ 1.0 1 863,873 / 3

Index Scan using physical_component_type_pkey on physical_component_type pct (cost=0.15..0.17 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=863,873)

  • Index Cond: (physical_component_type_id = pc.physical_component_type_id)
22. 1,439.788 1,439.788 ↓ 0.0 0 863,873 / 3

Index Scan using designed_component_type_pkey on designed_component_type dct (cost=0.15..0.23 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=863,873)

  • Index Cond: (designed_component_type_id = pct.designed_component_type_id)
  • Filter: ((designed_component_type)::text = ANY ('{junction_fixed,squid_loop}'::text[]))
  • Rows Removed by Filter: 1
23. 6,219.495 6,219.495 ↓ 0.0 0 414,633

Index Only Scan using die_pkey on die d (cost=0.29..127.51 rows=1 width=4) (actual time=0.015..0.015 rows=0 loops=414,633)

  • Index Cond: ((die_id = pc.die_id) AND (die_id = ANY ('{6540,6576,6494,6531,6506,11908,6423,6452,6529,6569,6548,6488,6564,6496,6567,6518,6580,6583,12417,6521,6533,6497,6550,6444,6571,6527,6492,6468,6481,6554,11326,6485,6419,6501,6559,6424,6570,6446,6561,6448,6535,6541,6513,6429,6508,6472,6470,10344,6422,6504,6417,6465,6545,6454,6577,6512,6538,6434,6542,6566,6447,6442,6466,6534,6482,11663,6516,6463,6539,6507,6449,6489,6473,6451,6526,6519,6467,6511,6418,6528,6536,6441,6479,6505,6464,6437,6461,6421,6493,6582,6574,6420,6553,6428,6445,6462,6555,6459,6491,6558,6476,6514,6568,6523,6530,12213,12293,6436,6433,12313,6544,6525,6575,11746,6425,6520,6427,6443,6551,6483,6453,10447,10570,6502,6460,10347,6457,6547,6471,6474,6426,6431,6562,6478,6469,6500,6440,6515,6549,6552,6517,6455,6556,6563,6546,6573,6581,6499,6487,6475,6560,6509,6435,6432,6565,6510,6458,6430,6439,6572,6490,6579,6438,6503,11854,6480,6522,6495,6486,6532,6537,6557,10988,6484,6524,6456,12030,6477,6450,6543,6498,6578,12115,6175,6211,6129,6166,6141,12463,6058,6087,6164,6204,6183,6123,6199,6131,6202,6153,6215,6218,11953,6156,6168,6132,6185,6079,6206,6162,6127,6103,6116,6189,10694,6120,6054,6136,6194,6059,6205,6081,6196,6083,6170,6176,6148,6064,6143,6107,6105,11037,6057,6139,6052,6100,6180,6089,6212,6147,6173,6069,6177,6201,6082,6077,6101,6169,6117,12136,6151,6098,6174,6142,6084,6124,6108,6086,6161,6154,6102,6146,6053,6163,6171,6076,6114,6140,6099,6072,6096,6056,6128,6217,6209,6055,6188,6063,6080,6097,6190,6094,6126,6193,6111,6149,6203,6158,6165,11553,11495,6071,6068,11447,6179,6160,6210,12607,6060,6155,6062,6078,6186,6118,6088,10976,11407,6137,6095,11032,6092,6182,6106,6109,6061,6066,6197,6113,6104,6135,6075,6150,6184,6187,6152,6090,6191,6198,6181,6208,6216,6134,6122,6110,6195,6144,6070,6067,6200,6145,6093,6065,6074,6207,6125,6214,6073,6138,12560,6115,6157,6130,6121,6167,6172,6192,10443,6119,6159,6091,12385,6112,6085,6178,6133,6213,11647,6806,6842,6760,6797,6772,10654,6689,6718,6795,6835,6814,6754,6830,6762,6833,6784,6846,6849,11329,6787,6799,6763,6816,6710,6837,6793,6758,6734,6747,6820,12415,6751,6685,6767,6825,6690,6836,6712,6827,6714,6801,6807,6779,6695,6774,6738,6736,11621,6688,6770,6683,6731,6811,6720,6843,6778,6804,6700,6808}'::integer[])))
  • Heap Fetches: 6,367
Planning time : 1.469 ms
Execution time : 40,284.917 ms