explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3kfX

Settings
# exclusive inclusive rows x rows loops node
1. 0.971 839.382 ↑ 2.6 709 1

Unique (cost=43,720.28..43,743.33 rows=1,844 width=24) (actual time=838.023..839.382 rows=709 loops=1)

2. 3.921 838.411 ↓ 3.5 6,367 1

Sort (cost=43,720.28..43,724.89 rows=1,844 width=24) (actual time=838.022..838.411 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. 3.358 834.490 ↓ 3.5 6,367 1

WindowAgg (cost=43,583.37..43,620.25 rows=1,844 width=24) (actual time=830.642..834.490 rows=6,367 loops=1)

4. 5.004 831.132 ↓ 3.5 6,367 1

Sort (cost=43,583.37..43,587.98 rows=1,844 width=16) (actual time=830.632..831.132 rows=6,367 loops=1)

  • Sort Key: d.die_id, ms.measurement_session_start_time DESC
  • Sort Method: quicksort Memory: 491kB
5. 6.906 826.128 ↓ 3.5 6,367 1

Gather (cost=7,127.58..43,483.35 rows=1,844 width=16) (actual time=17.734..826.128 rows=6,367 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 0.915 819.222 ↓ 2.8 2,122 3 / 3

Hash Join (cost=6,127.58..42,298.95 rows=768 width=16) (actual time=36.723..819.222 rows=2,122 loops=3)

  • Hash Cond: (ms.measurement_method_id = mm.measurement_method_id)
7. 3.759 818.273 ↓ 2.2 2,122 3 / 3

Hash Join (cost=6,121.16..42,289.40 rows=973 width=20) (actual time=36.534..818.273 rows=2,122 loops=3)

  • Hash Cond: (cm.measurement_session_id = ms.measurement_session_id)
8. 3.981 814.083 ↓ 2.2 2,122 3 / 3

Hash Join (cost=6,083.74..42,249.42 rows=973 width=8) (actual time=36.091..814.083 rows=2,122 loops=3)

  • Hash Cond: (cm.measurement_type_id = mt.measurement_type_id)
9. 460.170 810.090 ↓ 1.1 2,122 3 / 3

Hash Join (cost=6,082.70..42,237.86 rows=1,947 width=12) (actual time=36.064..810.090 rows=2,122 loops=3)

  • Hash Cond: (cm.physical_component_id = pc.physical_component_id)
10. 323.761 323.761 ↑ 1.3 857,782 3 / 3

Parallel Seq Scan on component_measurements cm (cost=0.00..32,114.68 rows=1,072,268 width=12) (actual time=0.003..323.761 rows=857,782 loops=3)

11. 1.905 26.159 ↓ 2.8 3,407 3 / 3

Hash (cost=6,067.23..6,067.23 rows=1,238 width=8) (actual time=26.159..26.159 rows=3,407 loops=3)

  • Buckets: 4096 (originally 2048) Batches: 1 (originally 1) Memory Usage: 166kB
12. 3.003 24.254 ↓ 2.8 3,407 3 / 3

Hash Join (cost=3.00..6,067.23 rows=1,238 width=8) (actual time=0.283..24.254 rows=3,407 loops=3)

  • Hash Cond: (pc.physical_component_type_id = pct.physical_component_type_id)
13. 2.383 21.213 ↑ 1.1 4,379 3 / 3

Nested Loop (cost=0.71..6,036.46 rows=4,953 width=12) (actual time=0.127..21.213 rows=4,379 loops=3)

14. 8.205 8.205 ↑ 1.0 425 3 / 3

Index Only Scan using die_pkey on die d (cost=0.29..1,086.91 rows=425 width=4) (actual time=0.113..8.205 rows=425 loops=3)

  • Index Cond: (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: 0
15. 10.625 10.625 ↑ 2.5 10 1,275 / 3

Index Scan using ix_physical_component_die_id on physical_component pc (cost=0.42..11.40 rows=25 width=12) (actual time=0.006..0.025 rows=10 loops=1,275)

  • Index Cond: (die_id = d.die_id)
16. 0.004 0.038 ↓ 2.0 4 3 / 3

Hash (cost=2.26..2.26 rows=2 width=4) (actual time=0.038..0.038 rows=4 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
17. 0.015 0.034 ↓ 2.0 4 3 / 3

Hash Join (cost=1.12..2.26 rows=2 width=4) (actual time=0.030..0.034 rows=4 loops=3)

  • Hash Cond: (pct.designed_component_type_id = dct.designed_component_type_id)
18. 0.006 0.006 ↑ 1.0 10 3 / 3

Seq Scan on physical_component_type pct (cost=0.00..1.10 rows=10 width=8) (actual time=0.005..0.006 rows=10 loops=3)

19. 0.005 0.013 ↑ 1.0 2 3 / 3

Hash (cost=1.10..1.10 rows=2 width=4) (actual time=0.013..0.013 rows=2 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
20. 0.008 0.008 ↑ 1.0 2 3 / 3

Seq Scan on designed_component_type dct (cost=0.00..1.10 rows=2 width=4) (actual time=0.006..0.008 rows=2 loops=3)

  • Filter: ((designed_component_type)::text = ANY ('{junction_fixed,squid_loop}'::text[]))
  • Rows Removed by Filter: 6
21. 0.004 0.012 ↑ 1.0 1 3 / 3

Hash (cost=1.02..1.02 rows=1 width=4) (actual time=0.012..0.012 rows=1 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
22. 0.008 0.008 ↑ 1.0 1 3 / 3

Seq Scan on measurement_type mt (cost=0.00..1.02 rows=1 width=4) (actual time=0.007..0.008 rows=1 loops=3)

  • Filter: ((measurement_type)::text = 'resistance'::text)
  • Rows Removed by Filter: 6
23. 0.201 0.431 ↓ 1.0 795 3 / 3

Hash (cost=27.74..27.74 rows=774 width=16) (actual time=0.431..0.431 rows=795 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 49kB
24. 0.230 0.230 ↓ 1.0 795 3 / 3

Seq Scan on measurement_session ms (cost=0.00..27.74 rows=774 width=16) (actual time=0.007..0.230 rows=795 loops=3)

25. 0.008 0.034 ↑ 1.0 15 3 / 3

Hash (cost=6.24..6.24 rows=15 width=4) (actual time=0.034..0.034 rows=15 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
26. 0.026 0.026 ↑ 1.0 15 3 / 3

Seq Scan on measurement_method mm (cost=0.00..6.24 rows=15 width=4) (actual time=0.013..0.026 rows=15 loops=3)

  • Filter: (measurement_context = 'room_temperature'::text)
  • Rows Removed by Filter: 4
Planning time : 3.936 ms
Execution time : 840.537 ms