explain.depesz.com

PostgreSQL's explain analyze made readable

Result: weFr : PROD team_latest

Settings
# exclusive inclusive rows x rows loops node
1. 10.925 740.158 ↓ 491.0 491 1

Nested Loop (cost=1,399.70..2,028.35 rows=1 width=1,582) (actual time=59.500..740.158 rows=491 loops=1)

  • Join Filter: (toh.organization_id = oh.organization_id)
2. 110.663 270.148 ↓ 491.0 491 1

Nested Loop (cost=1,399.42..1,550.77 rows=1 width=32) (actual time=58.341..270.148 rows=491 loops=1)

  • Join Filter: (toh.team_id = t.team_id)
3. 2.040 118.913 ↓ 2,254.0 2,254 1

Nested Loop (cost=1,399.14..1,406.88 rows=1 width=33) (actual time=58.083..118.913 rows=2,254 loops=1)

4. 6.249 112.365 ↓ 2,254.0 2,254 1

Nested Loop (cost=1,398.86..1,406.44 rows=1 width=29) (actual time=58.050..112.365 rows=2,254 loops=1)

  • Join Filter: ((((max(((os_1.season)::character varying)::text))::character varying)::ltree) = os.season)
  • Rows Removed by Join Filter: 29,173
5. 4.077 88.236 ↓ 1,788.0 3,576 1

Nested Loop (cost=1,398.57..1,405.55 rows=2 width=70) (actual time=57.988..88.236 rows=3,576 loops=1)

6. 14.345 77.397 ↓ 2,254.0 2,254 1

GroupAggregate (cost=1,394.28..1,394.31 rows=1 width=36) (actual time=57.954..77.397 rows=2,254 loops=1)

  • Group Key: o.team_id
7. 17.118 63.052 ↓ 32,246.0 32,246 1

Sort (cost=1,394.28..1,394.28 rows=1 width=17) (actual time=57.927..63.052 rows=32,246 loops=1)

  • Sort Key: o.team_id
  • Sort Method: quicksort Memory: 3,288kB
8. 29.911 45.934 ↓ 32,246.0 32,246 1

Merge Join (cost=684.18..1,394.27 rows=1 width=17) (actual time=9.445..45.934 rows=32,246 loops=1)

  • Merge Cond: (os_1.organization_id = o.organization_id)
  • Join Filter: ((os_1.season >= o.start_season) AND (os_1.season <= o.end_season))
  • Rows Removed by Join Filter: 72,242
9. 2.035 8.446 ↓ 2.9 5,767 1

Sort (cost=371.04..375.96 rows=1,965 width=17) (actual time=7.662..8.446 rows=5,767 loops=1)

  • Sort Key: os_1.organization_id
  • Sort Method: quicksort Memory: 643kB
10. 6.411 6.411 ↓ 2.9 5,767 1

Seq Scan on organization_season os_1 (cost=0.00..263.56 rows=1,965 width=17) (actual time=0.028..6.411 rows=5,767 loops=1)

  • Filter: (((season)::character varying)::numeric <= (date_part('year'::text, (CURRENT_DATE)::timestamp without time zone))::numeric)
  • Rows Removed by Filter: 127
11. 6.628 7.577 ↓ 28.4 104,548 1

Sort (cost=313.14..322.35 rows=3,685 width=34) (actual time=1.771..7.577 rows=104,548 loops=1)

  • Sort Key: o.organization_id
  • Sort Method: quicksort Memory: 390kB
12. 0.949 0.949 ↑ 1.0 3,685 1

Seq Scan on team_organization_history o (cost=0.00..94.85 rows=3,685 width=34) (actual time=0.007..0.949 rows=3,685 loops=1)

13. 2.254 6.762 ↑ 1.0 2 2,254

Bitmap Heap Scan on team_organization_history toh (cost=4.30..11.21 rows=2 width=34) (actual time=0.003..0.003 rows=2 loops=2,254)

  • Recheck Cond: (team_id = o.team_id)
  • Filter: ((organization_id <> ALL ('{114,115}'::integer[])) OR (organization_id IS NULL))
  • Rows Removed by Filter: 0
  • Heap Blocks: exact=2,623
14. 4.508 4.508 ↑ 1.0 2 2,254

Bitmap Index Scan on team_organization_history_pkey (cost=0.00..4.29 rows=2 width=0) (actual time=0.002..0.002 rows=2 loops=2,254)

  • Index Cond: (team_id = o.team_id)
15. 17.880 17.880 ↓ 9.0 9 3,576

Index Only Scan using organization_season_pkey on organization_season os (cost=0.28..0.43 rows=1 width=17) (actual time=0.003..0.005 rows=9 loops=3,576)

  • Index Cond: ((organization_id = toh.organization_id) AND (season >= toh.start_season) AND (season <= toh.end_season))
  • Heap Fetches: 31,427
16. 4.508 4.508 ↑ 1.0 1 2,254

Index Scan using team_history_pkey on team_history th (cost=0.28..0.43 rows=1 width=30) (actual time=0.002..0.002 rows=1 loops=2,254)

  • Index Cond: ((team_id = toh.team_id) AND (os.season >= start_season))
  • Filter: (os.season <= end_season)
  • Rows Removed by Filter: 1
17. 40.572 40.572 ↓ 0.0 0 2,254

Index Scan using team_pkey on team t (cost=0.28..143.88 rows=1 width=11) (actual time=0.018..0.018 rows=0 loops=2,254)

  • Index Cond: ((team_id = th.team_id) AND (team_id = ANY ('{1052,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1071,1072,1073,1074,1075,1076,1077,1078,1079,1080,1081,1082,1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,22,23,24,25,26,27,28,29,30,34,2950,2951,2952,2953,2954,2955,2956,2957,2958,2959,2960,2961,2962,2963,2964,2965,2966,2967,2968,2969,2970,2971,2972,2973,2974,2975,2976,2977,2978,2979,2980,2981,2982,2983,2984,2985,2986,12,1174,1210,1270,1271,1410,1411,1489,1490,1491,1492,1493,1494,1495,1496,1497,1498,1499,1500,1501,1502,1503,1504,1505,1506,1507,1508,1509,1510,1511,1512,1513,1514,1515,1516,1517,1518,1519,1520,1521,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138,1139,1140,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1151,1310,1311,1330,1331,1370,1990,1991,1992,1993,1994,1995,1550,1551,1552,1553,2987,3272,3273,3274,3275,3276,3277,3278,3279,3280,3281,3282,3283,3284,3285,3286,3287,3288,3289,3290,3291,3292,3293,3294,3295,3296,3297,716,717,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532,1533,1534,1535,1536,1537,1538,1539,1540,1541,1542,1543,1544,1545,1546,1547,1590,1591,1592,2190,2191,2192,2193,2250,2330,2370,2412,2413,2670,2671,2672,1294,1295,1296,1297,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2290,2291,2292,2293,2350,2351,2352,2390,2510,2511,2512,2513,2585,2586,2587,2588,2590,2591,2592,2593,2594,2595,2630,2631,35,36,37,38,3298,3350,3351,3755,3756,3757,3758,3759,3760,3761,3762,3763,3764,3765,3766,3767,3768,3769,3770,3771,3772,3773,3774,3775,3776,3777,3778,3779,3780,3781,3782,3783,3784,3785,3786,3787,3788,3789,3790,3791,3792,3793,3794,3795,3796,3797,3798,1390,2616,2617,2618,2619,2620,2621,2673,2674,2770,2988,2989,2990,2991,2992,2993,2994,2995,2996,2997,2998,2999,3000,3001,3002,3003,3004,3005,3006,3007,3008,3009,3010,3011,3051,3070,3151,3190,3191,3192,3193,3194,3195,3196,3197,3198,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,2690,2755,2756,2757,2758,2759,2796,2797,2798,2799,2800,2801,2802,2803,2804,2805,2873,2874,2875,2876,2877,2878,2879,2880,2881,2882,2883,2884,2885,2886,2887,2888,599,600,601,602,603,604,605,606,607,608,609,610,611,612,615,616,617,618,619,620,621,622,623,624,625,626,627,628}'::integer[])))
18. 1.964 1.964 ↑ 1.0 1 491

Index Scan using organization_history_pkey on organization_history oh (cost=0.28..0.33 rows=1 width=54) (actual time=0.004..0.004 rows=1 loops=491)

  • Index Cond: ((organization_id = os.organization_id) AND (os.season >= start_season))
  • Filter: (os.season <= end_season)
  • Rows Removed by Filter: 3
19.          

SubPlan (for Nested Loop)

20. 0.982 0.982 ↑ 1.0 1 491

Index Scan using team_history_pkey on team_history th_1 (cost=0.28..8.30 rows=1 width=5) (actual time=0.002..0.002 rows=1 loops=491)

  • Index Cond: ((team_id = t.team_id) AND (os.season >= start_season))
  • Filter: (os.season <= end_season)
  • Rows Removed by Filter: 1
21. 0.491 4.910 ↑ 1.0 1 491

Nested Loop (cost=0.69..16.89 rows=1 width=12) (actual time=0.010..0.010 rows=1 loops=491)

22. 2.946 2.946 ↑ 1.0 1 491

Index Scan using team_name_language_history_pkey on team_name_language_history h (cost=0.41..8.59 rows=1 width=4) (actual time=0.005..0.006 rows=1 loops=491)

  • Index Cond: ((team_id = t.team_id) AND ((name_role_code)::text = 'NS'::text) AND (os.season >= start_season))
  • Filter: (os.season <= end_season)
  • Rows Removed by Filter: 0
23. 1.473 1.473 ↑ 1.0 1 491

Index Scan using team_name_pkey on team_name n (cost=0.28..8.30 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=491)

  • Index Cond: (team_name_id = h.team_name_id)
24. 0.491 2.946 ↑ 1.0 1 491

Nested Loop (cost=0.69..16.89 rows=1 width=12) (actual time=0.006..0.006 rows=1 loops=491)

25. 1.473 1.473 ↑ 1.0 1 491

Index Scan using team_name_language_history_pkey on team_name_language_history h_1 (cost=0.41..8.59 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=491)

  • Index Cond: ((team_id = t.team_id) AND ((name_role_code)::text = 'N'::text) AND (os.season >= start_season))
  • Filter: (os.season <= end_season)
  • Rows Removed by Filter: 0
26. 0.982 0.982 ↑ 1.0 1 491

Index Scan using team_name_pkey on team_name n_1 (cost=0.28..8.30 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=491)

  • Index Cond: (team_name_id = h_1.team_name_id)
27. 0.491 3.437 ↑ 1.0 1 491

Nested Loop (cost=0.69..16.89 rows=1 width=12) (actual time=0.007..0.007 rows=1 loops=491)

28. 1.473 1.473 ↑ 1.0 1 491

Index Scan using team_name_language_history_pkey on team_name_language_history h_2 (cost=0.41..8.59 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=491)

  • Index Cond: ((team_id = t.team_id) AND ((name_role_code)::text = 'NA'::text) AND (os.season >= start_season))
  • Filter: (os.season <= end_season)
  • Rows Removed by Filter: 0
29. 1.473 1.473 ↑ 1.0 1 491

Index Scan using team_name_pkey on team_name n_2 (cost=0.28..8.30 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=491)

  • Index Cond: (team_name_id = h_2.team_name_id)
30. 0.618 2.455 ↑ 1.0 1 491

Nested Loop (cost=0.69..16.89 rows=1 width=12) (actual time=0.005..0.005 rows=1 loops=491)

31. 1.473 1.473 ↑ 1.0 1 491

Index Scan using team_name_language_history_pkey on team_name_language_history h_3 (cost=0.41..8.59 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=491)

  • Index Cond: ((team_id = t.team_id) AND ((name_role_code)::text = 'NDB'::text) AND (os.season >= start_season))
  • Filter: (os.season <= end_season)
  • Rows Removed by Filter: 0
32. 0.364 0.364 ↑ 1.0 1 364

Index Scan using team_name_pkey on team_name n_3 (cost=0.28..8.30 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=364)

  • Index Cond: (team_name_id = h_3.team_name_id)
33. 0.982 2.946 ↑ 1.0 1 491

Nested Loop (cost=0.69..16.89 rows=1 width=12) (actual time=0.005..0.006 rows=1 loops=491)

34. 1.473 1.473 ↑ 1.0 1 491

Index Scan using team_name_language_history_pkey on team_name_language_history h_4 (cost=0.41..8.59 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=491)

  • Index Cond: ((team_id = t.team_id) AND ((name_role_code)::text = 'NDS'::text) AND (os.season >= start_season))
  • Filter: (os.season <= end_season)
  • Rows Removed by Filter: 0
35. 0.491 0.491 ↑ 1.0 1 491

Index Scan using team_name_pkey on team_name n_4 (cost=0.28..8.30 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=491)

  • Index Cond: (team_name_id = h_4.team_name_id)
36. 0.982 3.437 ↑ 1.0 1 491

Nested Loop (cost=0.69..16.89 rows=1 width=12) (actual time=0.006..0.007 rows=1 loops=491)

37. 1.473 1.473 ↑ 1.0 1 491

Index Scan using team_name_language_history_pkey on team_name_language_history h_5 (cost=0.41..8.59 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=491)

  • Index Cond: ((team_id = t.team_id) AND ((name_role_code)::text = 'NDF'::text) AND (os.season >= start_season))
  • Filter: (os.season <= end_season)
  • Rows Removed by Filter: 1
38. 0.982 0.982 ↑ 1.0 1 491

Index Scan using team_name_pkey on team_name n_5 (cost=0.28..8.30 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=491)

  • Index Cond: (team_name_id = h_5.team_name_id)
39. 0.982 2.946 ↑ 1.0 1 491

Nested Loop (cost=0.69..16.89 rows=1 width=12) (actual time=0.005..0.006 rows=1 loops=491)

40. 1.473 1.473 ↑ 1.0 1 491

Index Scan using team_name_language_history_pkey on team_name_language_history h_6 (cost=0.41..8.59 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=491)

  • Index Cond: ((team_id = t.team_id) AND ((name_role_code)::text = 'NDL'::text) AND (os.season >= start_season))
  • Filter: (os.season <= end_season)
  • Rows Removed by Filter: 0
41. 0.491 0.491 ↑ 1.0 1 491

Index Scan using team_name_pkey on team_name n_6 (cost=0.28..8.30 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=491)

  • Index Cond: (team_name_id = h_6.team_name_id)
42. 0.982 0.982 ↑ 1.0 1 491

Index Scan using team_history_pkey on team_history th_1_1 (cost=0.28..8.30 rows=1 width=2) (actual time=0.002..0.002 rows=1 loops=491)

  • Index Cond: ((team_id = t.team_id) AND (os.season >= start_season))
  • Filter: (os.season <= end_season)
  • Rows Removed by Filter: 1
43. 0.982 0.982 ↑ 1.0 1 491

Index Scan using team_history_pkey on team_history th_1_2 (cost=0.28..8.30 rows=1 width=2) (actual time=0.002..0.002 rows=1 loops=491)

  • Index Cond: ((team_id = t.team_id) AND (os.season >= start_season))
  • Filter: (os.season <= end_season)
  • Rows Removed by Filter: 1
44. 0.982 0.982 ↑ 1.0 1 491

Index Scan using team_history_pkey on team_history th_1_3 (cost=0.28..8.30 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=491)

  • Index Cond: ((team_id = t.team_id) AND (os.season >= start_season))
  • Filter: (os.season <= end_season)
  • Rows Removed by Filter: 1
45. 1.305 119.804 ↓ 0.0 0 491

Nested Loop (cost=0.27..61.36 rows=1 width=4) (actual time=0.230..0.244 rows=0 loops=491)

46. 116.367 116.367 ↓ 2.0 2 491

Seq Scan on organization_history dh (cost=0.00..52.90 rows=1 width=4) (actual time=0.067..0.237 rows=2 loops=491)

  • Filter: ((organization_path @> oh.organization_path) AND (os.season >= start_season) AND (os.season <= end_season))
  • Rows Removed by Filter: 1,478
47. 2.132 2.132 ↓ 0.0 0 1,066

Index Scan using organization_pkey on organization d (cost=0.27..8.29 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=1,066)

  • Index Cond: (organization_id = dh.organization_id)
  • Filter: ((organization_type_code)::bpchar = 'D'::bpchar)
  • Rows Removed by Filter: 1
48. 1.389 115.876 ↑ 1.0 1 491

Nested Loop (cost=0.27..61.32 rows=1 width=4) (actual time=0.173..0.236 rows=1 loops=491)

49. 113.421 113.421 ↓ 2.0 2 491

Seq Scan on organization_history dh_1 (cost=0.00..52.90 rows=1 width=4) (actual time=0.065..0.231 rows=2 loops=491)

  • Filter: ((organization_path @> oh.organization_path) AND (os.season >= start_season) AND (os.season <= end_season))
  • Rows Removed by Filter: 1,478
50. 1.066 1.066 ↓ 0.0 0 1,066

Index Scan using organization_pkey on organization d_1 (cost=0.27..8.29 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=1,066)

  • Index Cond: (organization_id = dh_1.organization_id)
  • Filter: ((organization_type_code)::bpchar = 'L'::bpchar)
  • Rows Removed by Filter: 1
51. 2.978 141.408 ↓ 0.0 0 491

Nested Loop (cost=0.00..62.39 rows=1 width=4) (actual time=0.288..0.288 rows=0 loops=491)

  • Join Filter: (dh_2.organization_id = d_2.organization_id)
  • Rows Removed by Join Filter: 17
52. 113.912 113.912 ↓ 2.0 2 491

Seq Scan on organization_history dh_2 (cost=0.00..52.90 rows=1 width=4) (actual time=0.065..0.232 rows=2 loops=491)

  • Filter: ((organization_path @> oh.organization_path) AND (os.season >= start_season) AND (os.season <= end_season))
  • Rows Removed by Filter: 1,478
53. 24.518 24.518 ↑ 1.0 8 1,066

Seq Scan on organization d_2 (cost=0.00..9.39 rows=8 width=4) (actual time=0.015..0.023 rows=8 loops=1,066)

  • Filter: ((organization_type_code)::bpchar = 'C'::bpchar)
  • Rows Removed by Filter: 263
54. 0.491 43.699 ↑ 1.0 1 491

Limit (cost=0.27..61.61 rows=1 width=4) (actual time=0.088..0.089 rows=1 loops=491)

55. 0.702 43.208 ↑ 1.0 1 491

Nested Loop (cost=0.27..61.61 rows=1 width=4) (actual time=0.088..0.088 rows=1 loops=491)

56. 41.244 41.244 ↑ 1.0 1 491

Seq Scan on organization_history dh_3 (cost=0.00..52.90 rows=1 width=4) (actual time=0.065..0.084 rows=1 loops=491)

  • Filter: ((organization_path @> oh.organization_path) AND (os.season >= start_season) AND (os.season <= end_season))
  • Rows Removed by Filter: 532
57. 1.262 1.262 ↑ 1.0 1 631

Index Scan using organization_pkey on organization d_3 (cost=0.27..8.30 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=631)

  • Index Cond: (organization_id = dh_3.organization_id)
  • Filter: ((organization_id <> 5150) AND ((organization_type_code)::bpchar = 'S'::bpchar))
  • Rows Removed by Filter: 0
58. 1.473 1.473 ↑ 1.0 1 491

Index Scan using team_history_pkey on team_history th_1_4 (cost=0.28..8.30 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=491)

  • Index Cond: ((team_id = t.team_id) AND (os.season >= start_season))
  • Filter: (os.season <= end_season)
  • Rows Removed by Filter: 1
59. 1.473 1.964 ↑ 1.0 1 491

Aggregate (cost=4.34..4.35 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=491)

60. 0.491 0.491 ↑ 1.0 2 491

Index Only Scan using team_history_pkey on team_history x (cost=0.28..4.32 rows=2 width=13) (actual time=0.001..0.001 rows=2 loops=491)

  • Index Cond: (team_id = t.team_id)
  • Heap Fetches: 73
61. 0.982 1.964 ↑ 1.0 1 491

Index Scan using venue_history_dwo_pkey on venue_history_dwo g (cost=8.59..16.61 rows=1 width=9) (actual time=0.004..0.004 rows=1 loops=491)

  • Index Cond: (($45 = venue_id) AND (os.season = season))
62.          

Initplan (for Index Scan)

63. 0.982 0.982 ↑ 1.0 1 491

Index Scan using team_history_pkey on team_history th_1_5 (cost=0.28..8.30 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=491)

  • Index Cond: ((team_id = t.team_id) AND (os.season >= start_season))
  • Filter: (os.season <= end_season)
  • Rows Removed by Filter: 1
64. 0.000 0.982 ↑ 1.0 1 491

Index Scan using venue_history_dwo_pkey on venue_history_dwo g_1 (cost=8.59..16.61 rows=1 width=3) (actual time=0.002..0.002 rows=1 loops=491)

  • Index Cond: (($48 = venue_id) AND (os.season = season))
65.          

Initplan (for Index Scan)

66. 0.982 0.982 ↑ 1.0 1 491

Index Scan using team_history_pkey on team_history th_1_6 (cost=0.28..8.30 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=491)

  • Index Cond: ((team_id = t.team_id) AND (os.season >= start_season))
  • Filter: (os.season <= end_season)
  • Rows Removed by Filter: 1
67. 0.000 0.982 ↑ 1.0 1 491

Index Scan using venue_history_dwo_pkey on venue_history_dwo g_2 (cost=8.59..16.61 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=491)

  • Index Cond: (($51 = venue_id) AND (os.season = season))
68.          

Initplan (for Index Scan)

69. 0.982 0.982 ↑ 1.0 1 491

Index Scan using team_history_pkey on team_history th_1_7 (cost=0.28..8.30 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=491)

  • Index Cond: ((team_id = t.team_id) AND (os.season >= start_season))
  • Filter: (os.season <= end_season)
  • Rows Removed by Filter: 1
70. 0.491 1.964 ↓ 0.0 0 491

Nested Loop (cost=0.56..16.62 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=491)

71. 1.473 1.473 ↓ 0.0 0 491

Index Scan using team_organization_history_pkey on team_organization_history toh_1 (cost=0.28..8.31 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=491)

  • Index Cond: ((team_id = t.team_id) AND (os.season >= start_season))
  • Filter: ((organization_id = ANY ('{114,115}'::integer[])) AND (os.season <= end_season))
  • Rows Removed by Filter: 2
72. 0.000 0.000 ↓ 0.0 0

Index Scan using organization_history_pkey on organization_history oh_1 (cost=0.28..8.30 rows=1 width=4) (never executed)

  • Index Cond: ((organization_id = toh_1.organization_id) AND (os.season >= start_season))
  • Filter: (os.season <= end_season)
Planning time : 8.916 ms
Execution time : 741.576 ms