explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hRs5E

Settings
# exclusive inclusive rows x rows loops node
1. 3.224 70.508 ↓ 1.7 1,798 1

Hash Left Join (cost=2,268.84..3,708.94 rows=1,057 width=10,491) (actual time=60.414..70.508 rows=1,798 loops=1)

  • Hash Cond: (definition2_.id = parameters31_.event_definition_id)
2. 1.001 67.086 ↑ 1.0 500 1

Hash Left Join (cost=2,259.65..3,684.81 rows=500 width=10,411) (actual time=60.190..67.086 rows=500 loops=1)

  • Hash Cond: (this_.sub_module_id = submodule9_.id)
3. 0.985 66.062 ↑ 1.0 500 1

Hash Left Join (cost=2,246.50..3,664.78 rows=500 width=9,891) (actual time=60.125..66.062 rows=500 loops=1)

  • Hash Cond: (this_.resource_id = folder8_.id)
4. 0.921 65.013 ↑ 1.0 500 1

Hash Left Join (cost=2,243.27..3,658.82 rows=500 width=9,832) (actual time=60.041..65.013 rows=500 loops=1)

  • Hash Cond: (securabler6_.id = vsatsearch26_.vsat_id)
5. 0.851 61.480 ↑ 1.0 500 1

Hash Left Join (cost=2,119.46..3,528.80 rows=500 width=9,171) (actual time=57.405..61.480 rows=500 loops=1)

  • Hash Cond: (securabler6_.id = vsatmgmigr25_.vsat_id)
6. 0.866 60.592 ↑ 1.0 500 1

Hash Left Join (cost=2,117.79..3,525.13 rows=500 width=9,147) (actual time=57.344..60.592 rows=500 loops=1)

  • Hash Cond: (securabler6_.id = vsatlogonp24_.vsat_fk)
7. 0.969 58.320 ↑ 1.0 500 1

Hash Left Join (cost=2,060.98..3,462.11 rows=500 width=8,113) (actual time=55.915..58.320 rows=500 loops=1)

  • Hash Cond: (this_.event_definition_id = definition2_.id)
8. 2.062 57.090 ↑ 1.0 500 1

Hash Right Join (cost=2,049.81..3,444.07 rows=500 width=8,010) (actual time=55.643..57.090 rows=500 loops=1)

  • Hash Cond: (v.id = securabler6_.id)
9. 18.470 25.436 ↑ 1.5 1,058 1

Hash Left Join (cost=350.62..1,718.70 rows=1,540 width=308) (actual time=9.205..25.436 rows=1,058 loops=1)

  • Hash Cond: (v.id = vdp.vsat_id)
10. 0.470 5.747 ↑ 1.5 1,058 1

Hash Right Join (cost=277.81..319.57 rows=1,540 width=45) (actual time=5.294..5.747 rows=1,058 loops=1)

  • Hash Cond: (va.vsat_id = v.id)
11. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on vsat_acu va (cost=0.00..25.40 rows=1,540 width=20) (actual time=0.004..0.004 rows=0 loops=1)

12. 0.404 5.273 ↑ 1.0 1,058 1

Hash (cost=264.59..264.59 rows=1,058 width=29) (actual time=5.273..5.273 rows=1,058 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 67kB
13. 0.584 4.869 ↑ 1.0 1,058 1

Hash Left Join (cost=113.84..264.59 rows=1,058 width=29) (actual time=2.309..4.869 rows=1,058 loops=1)

  • Hash Cond: (v.rf_cluster_id = r.id)
14. 0.480 2.239 ↑ 1.0 1,058 1

Hash Left Join (cost=10.57..157.00 rows=1,058 width=21) (actual time=0.225..2.239 rows=1,058 loops=1)

  • Hash Cond: (v.rf_cluster_id = rf.id)
15. 0.566 1.708 ↑ 1.0 1,058 1

Hash Left Join (cost=7.33..149.46 rows=1,058 width=17) (actual time=0.161..1.708 rows=1,058 loops=1)

  • Hash Cond: (v.software_repository_id = sr.id)
16. 1.002 1.002 ↑ 1.0 1,058 1

Seq Scan on vsats v (cost=0.00..127.58 rows=1,058 width=13) (actual time=0.009..1.002 rows=1,058 loops=1)

17. 0.056 0.140 ↓ 1.0 150 1

Hash (cost=5.48..5.48 rows=148 width=12) (actual time=0.140..0.140 rows=150 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
18. 0.084 0.084 ↓ 1.0 150 1

Seq Scan on software_repositories sr (cost=0.00..5.48 rows=148 width=12) (actual time=0.015..0.084 rows=150 loops=1)

19. 0.024 0.051 ↑ 1.0 55 1

Hash (cost=2.55..2.55 rows=55 width=8) (actual time=0.051..0.051 rows=55 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
20. 0.027 0.027 ↑ 1.0 55 1

Seq Scan on folders rf (cost=0.00..2.55 rows=55 width=8) (actual time=0.007..0.027 rows=55 loops=1)

21. 1.151 2.046 ↑ 1.0 3,079 1

Hash (cost=64.79..64.79 rows=3,079 width=16) (actual time=2.046..2.046 rows=3,079 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 183kB
22. 0.895 0.895 ↑ 1.0 3,079 1

Seq Scan on resources r (cost=0.00..64.79 rows=3,079 width=16) (actual time=0.005..0.895 rows=3,079 loops=1)

23. 0.431 1.219 ↑ 1.0 1,058 1

Hash (cost=59.58..59.58 rows=1,058 width=20) (actual time=1.219..1.219 rows=1,058 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 70kB
24. 0.788 0.788 ↑ 1.0 1,058 1

Seq Scan on vsat_device_parameters vdp (cost=0.00..59.58 rows=1,058 width=20) (actual time=0.006..0.788 rows=1,058 loops=1)

25. 1.504 29.592 ↑ 1.0 500 1

Hash (cost=1,692.94..1,692.94 rows=500 width=7,702) (actual time=29.592..29.592 rows=500 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 275kB
26. 0.805 28.088 ↑ 1.0 500 1

Hash Left Join (cost=1,458.08..1,692.94 rows=500 width=7,702) (actual time=23.722..28.088 rows=500 loops=1)

  • Hash Cond: (securabler6_.id = vsatdevice23_.vsat_id)
27. 0.678 24.951 ↑ 1.0 500 1

Hash Left Join (cost=1,385.27..1,613.92 rows=500 width=7,409) (actual time=21.373..24.951 rows=500 loops=1)

  • Hash Cond: (securabler6_.id = vsatcoordi22_.vsat_id)
28. 0.704 24.221 ↑ 1.0 500 1

Hash Left Join (cost=1,372.80..1,599.12 rows=500 width=6,733) (actual time=21.304..24.221 rows=500 loops=1)

  • Hash Cond: (securabler6_.id = mediationn20_.mediation_id)
29. 0.630 23.384 ↑ 1.0 500 1

Hash Left Join (cost=1,356.46..1,580.85 rows=500 width=6,649) (actual time=21.152..23.384 rows=500 loops=1)

  • Hash Cond: (securabler6_.id = vlans19_.vsat_id)
30. 0.655 21.464 ↑ 1.0 500 1

Hash Left Join (cost=1,288.16..1,501.87 rows=500 width=6,565) (actual time=19.847..21.464 rows=500 loops=1)

  • Hash Cond: (securabler6_.folder_id = securabler7_.id)
31. 1.288 20.743 ↑ 1.0 500 1

Hash Right Join (cost=1,284.92..1,491.81 rows=500 width=6,506) (actual time=19.758..20.743 rows=500 loops=1)

  • Hash Cond: (vsataccoun21_.vsat_id = securabler6_.id)
32. 2.478 2.478 ↑ 1.0 1,058 1

Seq Scan on vsat_accounting vsataccoun21_ (cost=0.00..198.58 rows=1,058 width=639) (actual time=0.016..2.478 rows=1,058 loops=1)

33. 1.022 16.977 ↑ 1.0 500 1

Hash (cost=1,278.67..1,278.67 rows=500 width=5,867) (actual time=16.977..16.977 rows=500 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 253kB
34. 1.080 15.955 ↑ 1.0 500 1

Hash Right Join (cost=1,142.78..1,278.67 rows=500 width=5,867) (actual time=15.172..15.955 rows=500 loops=1)

  • Hash Cond: (securabler6_6_.id = securabler6_.id)
35. 1.962 1.962 ↑ 1.0 1,058 1

Seq Scan on vsats securabler6_6_ (cost=0.00..127.58 rows=1,058 width=322) (actual time=0.017..1.962 rows=1,058 loops=1)

36. 1.024 12.913 ↑ 1.0 500 1

Hash (cost=1,136.53..1,136.53 rows=500 width=5,549) (actual time=12.913..12.913 rows=500 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 249kB
37. 0.451 11.889 ↑ 1.0 500 1

Hash Left Join (cost=1,040.12..1,136.53 rows=500 width=5,549) (actual time=8.010..11.889 rows=500 loops=1)

  • Hash Cond: (securabler6_.id = securabler6_5_.id)
38. 0.379 11.420 ↑ 1.0 500 1

Hash Left Join (cost=1,039.08..1,133.60 rows=500 width=5,537) (actual time=7.981..11.420 rows=500 loops=1)

  • Hash Cond: (securabler6_.id = securabler6_4_.id)
39. 0.378 11.009 ↑ 1.0 500 1

Hash Left Join (cost=1,037.79..1,130.39 rows=500 width=5,414) (actual time=7.938..11.009 rows=500 loops=1)

  • Hash Cond: (securabler6_.id = securabler6_3_.id)
40. 0.382 10.628 ↑ 1.0 500 1

Hash Left Join (cost=1,027.34..1,117.98 rows=500 width=2,214) (actual time=7.922..10.628 rows=500 loops=1)

  • Hash Cond: (securabler6_.id = securabler6_2_.id)
41. 0.454 9.978 ↑ 1.0 500 1

Hash Left Join (cost=1,017.25..1,105.46 rows=500 width=2,050) (actual time=7.641..9.978 rows=500 loops=1)

  • Hash Cond: (resource3_.resource_type_id = resource_t4_.id)
42. 1.290 9.442 ↑ 1.0 500 1

Hash Right Join (cost=1,014.23..1,095.56 rows=500 width=2,017) (actual time=7.539..9.442 rows=500 loops=1)

  • Hash Cond: (securabler6_1_.id = securabler6_.id)
43. 0.689 0.689 ↑ 1.0 3,079 1

Seq Scan on resources securabler6_1_ (cost=0.00..64.79 rows=3,079 width=28) (actual time=0.005..0.689 rows=3,079 loops=1)

44. 0.770 7.463 ↑ 1.0 500 1

Hash (cost=1,007.98..1,007.98 rows=500 width=1,993) (actual time=7.463..7.463 rows=500 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 203kB
45. 0.397 6.693 ↑ 1.0 500 1

Hash Left Join (cost=236.57..1,007.98 rows=500 width=1,993) (actual time=3.987..6.693 rows=500 loops=1)

  • Hash Cond: (this_.resource_id = securabler6_.id)
46. 0.610 5.560 ↑ 1.0 500 1

Hash Left Join (cost=191.14..955.68 rows=500 width=1,985) (actual time=3.230..5.560 rows=500 loops=1)

  • Hash Cond: (this_.user_id = user1_.id)
47. 0.408 4.368 ↑ 1.0 500 1

Hash Left Join (cost=103.70..861.67 rows=500 width=166) (actual time=2.621..4.368 rows=500 loops=1)

  • Hash Cond: (this_.resource_id = resource3_.id)
48. 1.427 1.427 ↑ 1.0 500 1

Index Scan using events_pkey on events this_ (cost=0.43..751.52 rows=500 width=142) (actual time=0.040..1.427 rows=500 loops=1)

  • Index Cond: (id = ANY ('{2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2030,2031,2032,2033,2034,2035,2036,2037,2041,2042,2060,2061,2065,2066,2068,2069,2070,2071,2072,2073,2074,2075,2076,2077,2078,2081,2082,2083,2084,2085,2086,2087,2089,2092,2094,2079,2080,2088,2090,2091,2093,2096,2098,2099,2100,2101,2102,2103,2104,2107,2095,2097,2105,2106,2108,2109,2110,2111,2112,2113,2114,2115,2116,2117,2118,2119,2120,2121,2122,2123,2124,2125,2126,2127,2128,2129,2130,2131,2132,2133,2134,2135,2136,2137,2138,2139,2140,2141,2142,2143,2144,2145,2146,2147,2148,2149,2150,2151,2152,2153,2154,2155,2156,2157,2160,2158,2159,2162,2163,2164,2165,2166,2161,2167,2168,2169,2170,2171,2172,2173,2174,2175,2176,2177,2178,2179,2180,2181,2182,2183,2184,2185,2186,2187,2188,2189,2190,2191,2192,2193,2194,2195,2196,2197,2198,2199,2200,2201,2202,2203,2204,2205,2206,2207,2208,2209,2210,2211,2212,2213,2214,2215,2216,2421,2217,2218,2219,2220,2221,2222,2223,2224,2225,2226,2227,2228,2229,2230,2232,2231,2233,2234,2235,2236,2237,2238,2239,2240,2241,2255,2256,2257,2258,2259,2260,2261,2262,2263,2264,2265,2266,2267,2268,2269,2270,2271,2272,2273,2274,2275,2276,2277,2286,2278,2279,2280,2281,2282,2283,2284,2285,2287,2288,2289,2290,2291,2292,2293,2294,2295,2583,2296,2297,2298,2299,2300,2301,2302,2303,2304,2305,2306,2307,2309,2310,2311,2312,2313,2314,2315,2316,2308,2317,2318,2319,2320,2321,2322,2323,2324,2325,2326,2327,2328,2329,2330,2331,2332,2333,2334,2335,2336,2337,2338,2339,2340,2341,2342,2349,2343,2344,2345,2346,2347,2348,2350,2351,2352,2353,2354,2355,2356,2357,2358,2359,2360,2361,2369,2362,2363,2364,2365,2366,2367,2368,2370,2371,2372,2373,2374,2375,2376,2377,2378,2379,2380,2381,2382,2383,2384,2385,2386,2387,2388,2389,2390,2391,2392,2393,2394,2395,2396,2397,2398,2399,2400,2401,2402,2403,2404,2405,2406,2407,2408,2409,2410,2411,2412,2413,2419,2414,2415,2416,2417,2418,2420,2422,2423,2424,2425,2426,2427,2428,2429,2430,2431,2432,2433,2434,2435,2436,2437,2438,2439,2440,2441,2442,2443,2444,2445,2446,2447,2448,2449,2450,2451,2452,2453,2454,2455,2456,2457,2458,2459,2460,2461,2462,2463,2464,2465,2466,2467,2468,2469,2470,2471,2472,2473,2474,2475,2476,2477,2478,2479,2480,2481,2482,2483,2484,2485,2486,2487,2488,2489,2490,2491,2492,2493,2494,2658,2495,2496,2497,2498,2499,2500,2501,2502,2503,2504,2505,2506,2507,2508,2509,2531,2510,2511,2512,2513,2514,2515,2516,2517,2518,2519,2520,2521,2522,2523,2524,2525,2526,2527,2528,2529,2530,2532,2533,2534,2535,2536,2537,2538,2539,2540,2541,2542,2543,2544,2545,2546,2547,2548,2549,2550,2551,2552,2553}'::integer[]))
49. 1.193 2.533 ↑ 1.0 3,079 1

Hash (cost=64.79..64.79 rows=3,079 width=24) (actual time=2.533..2.533 rows=3,079 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 207kB
50. 1.340 1.340 ↑ 1.0 3,079 1

Seq Scan on resources resource3_ (cost=0.00..64.79 rows=3,079 width=24) (actual time=0.012..1.340 rows=3,079 loops=1)

51. 0.059 0.582 ↑ 1.0 24 1

Hash (cost=87.14..87.14 rows=24 width=1,819) (actual time=0.582..0.582 rows=24 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
52. 0.025 0.523 ↑ 1.0 24 1

Nested Loop Left Join (cost=5.81..87.14 rows=24 width=1,819) (actual time=0.209..0.523 rows=24 loops=1)

53. 0.029 0.450 ↑ 1.0 24 1

Nested Loop Left Join (cost=5.67..83.03 rows=24 width=1,786) (actual time=0.204..0.450 rows=24 loops=1)

54. 0.039 0.373 ↑ 1.0 24 1

Nested Loop Left Join (cost=5.39..51.94 rows=24 width=1,762) (actual time=0.199..0.373 rows=24 loops=1)

55. 0.046 0.214 ↑ 1.0 24 1

Hash Right Join (cost=5.11..7.16 rows=24 width=1,738) (actual time=0.169..0.214 rows=24 loops=1)

  • Hash Cond: (folderngre14_.id = folder13_.id)
56. 0.018 0.018 ↑ 1.1 55 1

Seq Scan on folder_resources folderngre14_ (cost=0.00..1.59 rows=59 width=4) (actual time=0.007..0.018 rows=55 loops=1)

57. 0.025 0.150 ↑ 1.0 24 1

Hash (cost=4.81..4.81 rows=24 width=1,734) (actual time=0.150..0.150 rows=24 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
58. 0.032 0.125 ↑ 1.0 24 1

Hash Left Join (cost=3.24..4.81 rows=24 width=1,734) (actual time=0.100..0.125 rows=24 loops=1)

  • Hash Cond: (user1_.cpe_domain = folder13_.id)
59. 0.020 0.020 ↑ 1.0 24 1

Seq Scan on users user1_ (cost=0.00..1.24 rows=24 width=1,675) (actual time=0.010..0.020 rows=24 loops=1)

60. 0.032 0.073 ↑ 1.0 55 1

Hash (cost=2.55..2.55 rows=55 width=59) (actual time=0.073..0.073 rows=55 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
61. 0.041 0.041 ↑ 1.0 55 1

Seq Scan on folders folder13_ (cost=0.00..2.55 rows=55 width=59) (actual time=0.010..0.041 rows=55 loops=1)

62. 0.120 0.120 ↑ 1.0 1 24

Index Scan using resources_pkey on resources user1_1_ (cost=0.28..1.86 rows=1 width=28) (actual time=0.005..0.005 rows=1 loops=24)

  • Index Cond: (user1_.id = id)
63. 0.048 0.048 ↑ 1.0 1 24

Index Scan using resources_pkey on resources folderngre14_1_ (cost=0.28..1.29 rows=1 width=28) (actual time=0.002..0.002 rows=1 loops=24)

  • Index Cond: (folderngre14_.id = id)
64. 0.048 0.048 ↑ 1.0 1 24

Index Scan using resource_types_pkey on resource_types resourcety12_ (cost=0.14..0.16 rows=1 width=33) (actual time=0.001..0.002 rows=1 loops=24)

  • Index Cond: (user1_1_.resource_type_id = id)
65. 0.394 0.736 ↓ 1.0 1,238 1

Hash (cost=30.19..30.19 rows=1,219 width=8) (actual time=0.736..0.736 rows=1,238 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 65kB
66. 0.342 0.342 ↓ 1.0 1,238 1

Seq Scan on securable_resources securabler6_ (cost=0.00..30.19 rows=1,219 width=8) (actual time=0.012..0.342 rows=1,238 loops=1)

67. 0.054 0.082 ↓ 1.0 91 1

Hash (cost=1.90..1.90 rows=90 width=33) (actual time=0.082..0.082 rows=91 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
68. 0.028 0.028 ↓ 1.0 91 1

Seq Scan on resource_types resource_t4_ (cost=0.00..1.90 rows=90 width=33) (actual time=0.008..0.028 rows=91 loops=1)

69. 0.111 0.268 ↓ 1.0 140 1

Hash (cost=8.37..8.37 rows=137 width=168) (actual time=0.268..0.268 rows=140 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 32kB
70. 0.157 0.157 ↓ 1.0 140 1

Seq Scan on hub_elements securabler6_2_ (cost=0.00..8.37 rows=137 width=168) (actual time=0.013..0.157 rows=140 loops=1)

71. 0.000 0.003 ↓ 0.0 0 1

Hash (cost=10.20..10.20 rows=20 width=3,204) (actual time=0.003..0.003 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
72. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on mecs securabler6_3_ (cost=0.00..10.20 rows=20 width=3,204) (actual time=0.003..0.003 rows=0 loops=1)

73. 0.013 0.032 ↓ 1.2 15 1

Hash (cost=1.13..1.13 rows=13 width=127) (actual time=0.032..0.032 rows=15 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
74. 0.019 0.019 ↓ 1.2 15 1

Seq Scan on mediations securabler6_4_ (cost=0.00..1.13 rows=13 width=127) (actual time=0.006..0.019 rows=15 loops=1)

75. 0.008 0.018 ↓ 4.0 8 1

Hash (cost=1.02..1.02 rows=2 width=16) (actual time=0.018..0.018 rows=8 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
76. 0.010 0.010 ↓ 4.0 8 1

Seq Scan on switch_elements securabler6_5_ (cost=0.00..1.02 rows=2 width=16) (actual time=0.006..0.010 rows=8 loops=1)

77. 0.037 0.066 ↑ 1.0 55 1

Hash (cost=2.55..2.55 rows=55 width=59) (actual time=0.066..0.066 rows=55 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
78. 0.029 0.029 ↑ 1.0 55 1

Seq Scan on folders securabler7_ (cost=0.00..2.55 rows=55 width=59) (actual time=0.007..0.029 rows=55 loops=1)

79. 0.586 1.290 ↑ 1.0 1,080 1

Hash (cost=54.80..54.80 rows=1,080 width=84) (actual time=1.290..1.290 rows=1,080 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 127kB
80. 0.704 0.704 ↑ 1.0 1,080 1

Seq Scan on vsat_vlans vlans19_ (cost=0.00..54.80 rows=1,080 width=84) (actual time=0.013..0.704 rows=1,080 loops=1)

81. 0.014 0.133 ↑ 1.0 15 1

Hash (cost=16.15..16.15 rows=15 width=84) (actual time=0.133..0.133 rows=15 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
82. 0.119 0.119 ↑ 1.0 15 1

Seq Scan on mediations_network_status mediationn20_ (cost=0.00..16.15 rows=15 width=84) (actual time=0.013..0.119 rows=15 loops=1)

83. 0.006 0.052 ↑ 110.0 1 1

Hash (cost=11.10..11.10 rows=110 width=676) (actual time=0.052..0.052 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
84. 0.046 0.046 ↑ 110.0 1 1

Seq Scan on vsat_coordinates vsatcoordi22_ (cost=0.00..11.10 rows=110 width=676) (actual time=0.045..0.046 rows=1 loops=1)

85. 1.082 2.332 ↑ 1.0 1,058 1

Hash (cost=59.58..59.58 rows=1,058 width=293) (actual time=2.332..2.332 rows=1,058 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 258kB
86. 1.250 1.250 ↑ 1.0 1,058 1

Seq Scan on vsat_device_parameters vsatdevice23_ (cost=0.00..59.58 rows=1,058 width=293) (actual time=0.016..1.250 rows=1,058 loops=1)

87. 0.060 0.261 ↑ 1.0 88 1

Hash (cost=10.07..10.07 rows=88 width=103) (actual time=0.261..0.261 rows=88 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
88. 0.079 0.201 ↑ 1.0 88 1

Hash Right Join (cost=3.98..10.07 rows=88 width=103) (actual time=0.097..0.201 rows=88 loops=1)

  • Hash Cond: (definition5_.event_definition_id = definition2_.id)
89. 0.044 0.044 ↑ 1.0 88 1

Seq Scan on event_locale_text definition5_ (cost=0.00..4.88 rows=88 width=86) (actual time=0.010..0.044 rows=88 loops=1)

90. 0.040 0.078 ↑ 1.0 88 1

Hash (cost=2.88..2.88 rows=88 width=17) (actual time=0.078..0.078 rows=88 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
91. 0.038 0.038 ↑ 1.0 88 1

Seq Scan on event_definitions definition2_ (cost=0.00..2.88 rows=88 width=17) (actual time=0.011..0.038 rows=88 loops=1)

92. 0.611 1.406 ↑ 1.0 1,058 1

Hash (cost=43.58..43.58 rows=1,058 width=1,034) (actual time=1.406..1.406 rows=1,058 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 155kB
93. 0.795 0.795 ↑ 1.0 1,058 1

Seq Scan on vsat_logon_parameters vsatlogonp24_ (cost=0.00..43.58 rows=1,058 width=1,034) (actual time=0.011..0.795 rows=1,058 loops=1)

94. 0.017 0.037 ↑ 1.0 30 1

Hash (cost=1.30..1.30 rows=30 width=24) (actual time=0.037..0.037 rows=30 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
95. 0.020 0.020 ↑ 1.0 30 1

Seq Scan on vsat_mg_migration_data vsatmgmigr25_ (cost=0.00..1.30 rows=30 width=24) (actual time=0.013..0.020 rows=30 loops=1)

96. 1.095 2.612 ↑ 1.0 1,058 1

Hash (cost=110.58..110.58 rows=1,058 width=661) (actual time=2.612..2.612 rows=1,058 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 276kB
97. 1.517 1.517 ↑ 1.0 1,058 1

Seq Scan on vsats_search vsatsearch26_ (cost=0.00..110.58 rows=1,058 width=661) (actual time=0.008..1.517 rows=1,058 loops=1)

98. 0.030 0.064 ↑ 1.0 55 1

Hash (cost=2.55..2.55 rows=55 width=59) (actual time=0.064..0.064 rows=55 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
99. 0.034 0.034 ↑ 1.0 55 1

Seq Scan on folders folder8_ (cost=0.00..2.55 rows=55 width=59) (actual time=0.007..0.034 rows=55 loops=1)

100. 0.012 0.023 ↑ 10.8 13 1

Hash (cost=11.40..11.40 rows=140 width=520) (actual time=0.023..0.023 rows=13 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
101. 0.011 0.011 ↑ 10.8 13 1

Seq Scan on events_sub_modules submodule9_ (cost=0.00..11.40 rows=140 width=520) (actual time=0.007..0.011 rows=13 loops=1)

102. 0.091 0.198 ↑ 1.0 186 1

Hash (cost=6.86..6.86 rows=186 width=68) (actual time=0.198..0.198 rows=186 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 28kB
103. 0.107 0.107 ↑ 1.0 186 1

Seq Scan on event_definition_parameters parameters31_ (cost=0.00..6.86 rows=186 width=68) (actual time=0.011..0.107 rows=186 loops=1)

Planning time : 41.439 ms
Execution time : 75.732 ms