@flamber
Thanks for the clear explanation. Most of the time, we have Metabase running on 3 instances. So, MB_JDBC_DATA_WAREHOUSE_MAX_CONNECTION_POOL_SIZE = 100 means there are 300 total opened connections to the database.
NB: When I do the tests to get the logs, I use a huge dashboard which contains 106 questions. A lot are the same questions but with different values from different dashboard filters. I've just did some tests when I'm sure I'm the only one using Metabase: the dashboard could not load (only 5-10 questions / 106 displayed results).
I should mention that I've seen regularly this dashboard loads in 2-3 seconds (during my previous investigation): so that's definitely possible to load it quickly.
So, when I've launched the dashboard 2 times. Both tests failed and the dashboard didn't load. Below are some more logs:
In particular, we can see (example): (32 DB calls) App DB connections: 2/100 Jetty threads: 3/150 (25 idle, 0 queued) (343 total active threads) Queries in flight: 62 (0 queued); postgres DB 3 connections: 39/39 (59 threads blocked)
- Not a lot of Jetty threads but lots in idle.
- Lots of queries in flight: no queue.
- As much active connection as connection pool.
- Lots of threads blocked.
- Almost all the logs are: [ASYNC: canceled] with "1 mins" or "59.3 s" (for some reason). I don't stop the dashboard / close the window at 1min. I think (I may be wrong) it's the Metabase time out. Every time the dashboard doesn't load. The questions cancelled.
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:16+01:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 3.2 ms (3 DB calls) App DB connections: 0/100 Jetty threads: 4/150 (25 idle, 0 queued) (343 total active threads) Queries in flight: 97 (0 queued)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:16+01:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 3.9 ms (2 DB calls) App DB connections: 0/100 Jetty threads: 4/150 (25 idle, 0 queued) (343 total active threads) Queries in flight: 97 (0 queued)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:16+01:00 DEBUG metabase.server.middleware.log GET /api/database 200 4.8 ms (3 DB calls) App DB connections: 0/100 Jetty threads: 3/150 (26 idle, 0 queued) (343 total active threads) Queries in flight: 97 (0 queued)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (32 DB calls) App DB connections: 0/100 Jetty threads: 2/150 (26 idle, 0 queued) (343 total active threads) Queries in flight: 96 (0 queued); postgres DB 3 connections: 1/1 (0 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (32 DB calls) App DB connections: 0/100 Jetty threads: 2/150 (26 idle, 0 queued) (343 total active threads) Queries in flight: 95 (0 queued); postgres DB 3 connections: 3/3 (3 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (32 DB calls) App DB connections: 0/100 Jetty threads: 2/150 (26 idle, 0 queued) (343 total active threads) Queries in flight: 93 (0 queued); postgres DB 3 connections: 0/1 (0 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (32 DB calls) App DB connections: 0/100 Jetty threads: 2/150 (26 idle, 0 queued) (343 total active threads) Queries in flight: 93 (0 queued); postgres DB 3 connections: 1/1 (2 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (33 DB calls) App DB connections: 0/100 Jetty threads: 3/150 (26 idle, 0 queued) (343 total active threads) Queries in flight: 92 (0 queued); postgres DB 3 connections: 6/6 (2 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (32 DB calls) App DB connections: 0/100 Jetty threads: 2/150 (26 idle, 0 queued) (343 total active threads) Queries in flight: 91 (0 queued); postgres DB 3 connections: 3/3 (4 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (32 DB calls) App DB connections: 0/100 Jetty threads: 4/150 (25 idle, 0 queued) (343 total active threads) Queries in flight: 90 (0 queued); postgres DB 3 connections: 1/1 (1 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (32 DB calls) App DB connections: 0/100 Jetty threads: 4/150 (25 idle, 0 queued) (343 total active threads) Queries in flight: 89 (0 queued); postgres DB 3 connections: 3/3 (2 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (32 DB calls) App DB connections: 0/100 Jetty threads: 2/150 (26 idle, 0 queued) (343 total active threads) Queries in flight: 87 (0 queued); postgres DB 3 connections: 3/3 (1 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (32 DB calls) App DB connections: 0/100 Jetty threads: 2/150 (26 idle, 0 queued) (343 total active threads) Queries in flight: 87 (0 queued); postgres DB 3 connections: 9/9 (3 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (32 DB calls) App DB connections: 0/100 Jetty threads: 2/150 (26 idle, 0 queued) (343 total active threads) Queries in flight: 86 (0 queued); postgres DB 3 connections: 7/7 (3 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2372/query 202 [ASYNC: canceled] 59.1 s (31 DB calls) App DB connections: 0/100 Jetty threads: 2/150 (26 idle, 0 queued) (343 total active threads) Queries in flight: 84 (0 queued); postgres DB 3 connections: 32/32 (27 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (32 DB calls) App DB connections: 1/100 Jetty threads: 2/150 (26 idle, 0 queued) (343 total active threads) Queries in flight: 84 (0 queued); postgres DB 3 connections: 8/8 (3 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 59.1 s (30 DB calls) App DB connections: 1/100 Jetty threads: 4/150 (25 idle, 0 queued) (343 total active threads) Queries in flight: 83 (0 queued); postgres DB 3 connections: 35/35 (45 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (32 DB calls) App DB connections: 1/100 Jetty threads: 2/150 (26 idle, 0 queued) (343 total active threads) Queries in flight: 81 (0 queued); postgres DB 3 connections: 7/7 (2 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (32 DB calls) App DB connections: 1/100 Jetty threads: 3/150 (26 idle, 0 queued) (343 total active threads) Queries in flight: 81 (0 queued); postgres DB 3 connections: 13/13 (1 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 59.1 s (32 DB calls) App DB connections: 1/100 Jetty threads: 3/150 (26 idle, 0 queued) (343 total active threads) Queries in flight: 80 (0 queued); postgres DB 3 connections: 35/35 (42 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 59.1 s (32 DB calls) App DB connections: 3/100 Jetty threads: 3/150 (26 idle, 0 queued) (343 total active threads) Queries in flight: 79 (0 queued); postgres DB 3 connections: 35/35 (43 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 59.1 s (31 DB calls) App DB connections: 3/100 Jetty threads: 3/150 (26 idle, 0 queued) (343 total active threads) Queries in flight: 78 (0 queued); postgres DB 3 connections: 35/35 (49 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 59.1 s (31 DB calls) App DB connections: 0/100 Jetty threads: 3/150 (25 idle, 0 queued) (343 total active threads) Queries in flight: 76 (0 queued); postgres DB 3 connections: 35/35 (46 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 59.1 s (31 DB calls) App DB connections: 0/100 Jetty threads: 3/150 (25 idle, 0 queued) (343 total active threads) Queries in flight: 76 (0 queued); postgres DB 3 connections: 35/35 (48 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2372/query 202 [ASYNC: canceled] 59.2 s (31 DB calls) App DB connections: 0/100 Jetty threads: 6/150 (22 idle, 0 queued) (343 total active threads) Queries in flight: 73 (0 queued); postgres DB 3 connections: 34/34 (41 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 59.2 s (32 DB calls) App DB connections: 0/100 Jetty threads: 6/150 (22 idle, 0 queued) (343 total active threads) Queries in flight: 73 (0 queued); postgres DB 3 connections: 35/35 (47 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 59.2 s (31 DB calls) App DB connections: 0/100 Jetty threads: 3/150 (25 idle, 0 queued) (343 total active threads) Queries in flight: 73 (0 queued); postgres DB 3 connections: 35/35 (41 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 59.3 s (31 DB calls) App DB connections: 1/100 Jetty threads: 3/150 (25 idle, 0 queued) (343 total active threads) Queries in flight: 71 (0 queued); postgres DB 3 connections: 39/39 (55 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 59.3 s (32 DB calls) App DB connections: 1/100 Jetty threads: 3/150 (25 idle, 0 queued) (343 total active threads) Queries in flight: 72 (0 queued); postgres DB 3 connections: 39/39 (53 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/286/query 202 [ASYNC: canceled] 59.2 s (31 DB calls) App DB connections: 2/100 Jetty threads: 3/150 (25 idle, 0 queued) (343 total active threads) Queries in flight: 65 (0 queued); postgres DB 3 connections: 39/39 (58 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 59.2 s (32 DB calls) App DB connections: 2/100 Jetty threads: 3/150 (25 idle, 0 queued) (343 total active threads) Queries in flight: 63 (0 queued); postgres DB 3 connections: 38/38 (50 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 59.2 s (32 DB calls) App DB connections: 2/100 Jetty threads: 3/150 (25 idle, 0 queued) (343 total active threads) Queries in flight: 63 (0 queued); postgres DB 3 connections: 39/39 (52 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 59.3 s (31 DB calls) App DB connections: 2/100 Jetty threads: 3/150 (25 idle, 0 queued) (343 total active threads) Queries in flight: 63 (0 queued); postgres DB 3 connections: 39/39 (57 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/286/query 202 [ASYNC: canceled] 59.2 s (30 DB calls) App DB connections: 2/100 Jetty threads: 3/150 (25 idle, 0 queued) (343 total active threads) Queries in flight: 63 (0 queued); postgres DB 3 connections: 39/39 (56 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 59.3 s (32 DB calls) App DB connections: 2/100 Jetty threads: 3/150 (25 idle, 0 queued) (343 total active threads) Queries in flight: 62 (0 queued); postgres DB 3 connections: 39/39 (59 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 59.3 s (31 DB calls) App DB connections: 2/100 Jetty threads: 3/150 (25 idle, 0 queued) (343 total active threads) Queries in flight: 63 (0 queued); postgres DB 3 connections: 39/39 (51 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 59.2 s (31 DB calls) App DB connections: 2/100 Jetty threads: 3/150 (25 idle, 0 queued) (343 total active threads) Queries in flight: 62 (0 queued); postgres DB 3 connections: 39/39 (50 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 59.3 s (31 DB calls) App DB connections: 2/100 Jetty threads: 3/150 (25 idle, 0 queued) (343 total active threads) Queries in flight: 62 (0 queued); postgres DB 3 connections: 39/39 (54 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 59.3 s (31 DB calls) App DB connections: 0/100 Jetty threads: 3/150 (25 idle, 0 queued) (343 total active threads) Queries in flight: 61 (0 queued); postgres DB 3 connections: 38/38 (49 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2372/query 202 [ASYNC: canceled] 59.2 s (31 DB calls) App DB connections: 0/100 Jetty threads: 3/150 (25 idle, 0 queued) (343 total active threads) Queries in flight: 60 (0 queued); postgres DB 3 connections: 38/38 (47 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2372/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 0/100 Jetty threads: 3/150 (25 idle, 0 queued) (343 total active threads) Queries in flight: 57 (0 queued); postgres DB 3 connections: 23/23 (12 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (32 DB calls) App DB connections: 0/100 Jetty threads: 3/150 (25 idle, 0 queued) (343 total active threads) Queries in flight: 57 (0 queued); postgres DB 3 connections: 16/16 (5 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2372/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 0/100 Jetty threads: 3/150 (25 idle, 0 queued) (343 total active threads) Queries in flight: 55 (0 queued); postgres DB 3 connections: 18/18 (7 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2372/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 0/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 55 (0 queued); postgres DB 3 connections: 23/23 (13 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 0/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 55 (0 queued); postgres DB 3 connections: 14/14 (4 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2372/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 5/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 33 (0 queued); postgres DB 3 connections: 32/32 (31 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 5/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 33 (0 queued); postgres DB 3 connections: 15/15 (4 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 5/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 33 (0 queued); postgres DB 3 connections: 18/18 (6 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 5/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 33 (0 queued); postgres DB 3 connections: 21/21 (10 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (32 DB calls) App DB connections: 5/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 33 (0 queued); postgres DB 3 connections: 16/16 (4 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2372/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 5/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 33 (0 queued); postgres DB 3 connections: 30/30 (20 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 1.0 mins (30 DB calls) App DB connections: 5/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 33 (0 queued); postgres DB 3 connections: 13/13 (3 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 5/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 33 (0 queued); postgres DB 3 connections: 12/12 (1 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 5/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 33 (0 queued); postgres DB 3 connections: 19/19 (9 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 6/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 25 (0 queued); postgres DB 3 connections: 32/32 (25 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (32 DB calls) App DB connections: 6/100 Jetty threads: 4/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 25 (0 queued); postgres DB 3 connections: 13/13 (2 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (32 DB calls) App DB connections: 6/100 Jetty threads: 4/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 25 (0 queued); postgres DB 3 connections: 23/23 (10 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (32 DB calls) App DB connections: 6/100 Jetty threads: 9/150 (20 idle, 0 queued) (344 total active threads) Queries in flight: 25 (0 queued); postgres DB 3 connections: 32/32 (29 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2372/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 6/100 Jetty threads: 4/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 25 (0 queued); postgres DB 3 connections: 32/32 (30 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 6/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 24 (0 queued); postgres DB 3 connections: 32/32 (24 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 6/100 Jetty threads: 5/150 (24 idle, 0 queued) (344 total active threads) Queries in flight: 24 (0 queued); postgres DB 3 connections: 34/34 (36 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 3/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 24 (0 queued); postgres DB 3 connections: 34/34 (37 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/286/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 3/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 24 (0 queued); postgres DB 3 connections: 33/33 (32 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/286/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 6/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 24 (0 queued); postgres DB 3 connections: 31/31 (20 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 3/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 24 (0 queued); postgres DB 3 connections: 32/32 (21 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 6/100 Jetty threads: 4/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 24 (0 queued); postgres DB 3 connections: 21/21 (9 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (32 DB calls) App DB connections: 2/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 24 (0 queued); postgres DB 3 connections: 19/19 (7 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 1.0 mins (30 DB calls) App DB connections: 2/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 24 (0 queued); postgres DB 3 connections: 32/32 (28 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (32 DB calls) App DB connections: 2/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 24 (0 queued); postgres DB 3 connections: 35/35 (44 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2372/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 2/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 24 (0 queued); postgres DB 3 connections: 19/19 (8 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (32 DB calls) App DB connections: 3/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 24 (0 queued); postgres DB 3 connections: 23/23 (11 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2372/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 3/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 24 (0 queued); postgres DB 3 connections: 29/29 (18 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (32 DB calls) App DB connections: 3/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 24 (0 queued); postgres DB 3 connections: 13/13 (4 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2372/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 3/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 24 (0 queued); postgres DB 3 connections: 32/32 (20 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (32 DB calls) App DB connections: 3/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 24 (0 queued); postgres DB 3 connections: 20/20 (9 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 3/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 24 (0 queued); postgres DB 3 connections: 34/34 (33 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:41+01:00 INFO metabase.query-processor.middleware.cache Query took 59.2 s to run; minimum for cache eligibility is 4.0 s
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:42+01:00 DEBUG metabase.server.middleware.log POST /api/card/2372/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 3/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 5 (0 queued); postgres DB 3 connections: 32/32 (23 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:42+01:00 DEBUG metabase.server.middleware.log POST /api/card/2372/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 3/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 3 (0 queued); postgres DB 3 connections: 34/34 (38 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:42+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 3/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 3 (0 queued); postgres DB 3 connections: 34/34 (35 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:42+01:00 DEBUG metabase.server.middleware.log POST /api/card/2372/query 202 [ASYNC: canceled] 1.0 mins (30 DB calls) App DB connections: 3/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 3 (0 queued); postgres DB 3 connections: 30/30 (19 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:42+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 3/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 3 (0 queued); postgres DB 3 connections: 34/34 (34 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:42+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (32 DB calls) App DB connections: 3/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 3 (0 queued); postgres DB 3 connections: 27/27 (16 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:42+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 1.0 mins (30 DB calls) App DB connections: 3/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 3 (0 queued); postgres DB 3 connections: 33/33 (31 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:42+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (32 DB calls) App DB connections: 3/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 3 (0 queued); postgres DB 3 connections: 26/26 (16 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:42+01:00 DEBUG metabase.server.middleware.log POST /api/card/2372/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 3/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 3 (0 queued); postgres DB 3 connections: 33/33 (33 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:42+01:00 DEBUG metabase.server.middleware.log POST /api/card/2372/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 3/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 3 (0 queued); postgres DB 3 connections: 27/27 (18 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:42+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 3/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 3 (0 queued); postgres DB 3 connections: 29/29 (19 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:42+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 3/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 3 (0 queued); postgres DB 3 connections: 34/34 (40 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:42+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (32 DB calls) App DB connections: 3/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 3 (0 queued); postgres DB 3 connections: 24/24 (13 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:42+01:00 DEBUG metabase.server.middleware.log POST /api/card/2372/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 3/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 3 (0 queued); postgres DB 3 connections: 29/29 (17 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:42+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 3/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 3 (0 queued); postgres DB 3 connections: 24/24 (15 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:42+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (32 DB calls) App DB connections: 3/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 3 (0 queued); postgres DB 3 connections: 29/29 (16 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:42+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 3/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 3 (0 queued); postgres DB 3 connections: 24/24 (14 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:42+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (32 DB calls) App DB connections: 3/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 3 (0 queued); postgres DB 3 connections: 16/16 (6 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:42+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (32 DB calls) App DB connections: 3/100 Jetty threads: 5/150 (24 idle, 0 queued) (344 total active threads) Queries in flight: 2 (0 queued); postgres DB 3 connections: 26/26 (15 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:42+01:00 DEBUG metabase.server.middleware.log POST /api/card/2374/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 3/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 2 (0 queued); postgres DB 3 connections: 24/24 (16 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:42+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (32 DB calls) App DB connections: 2/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 2 (0 queued); postgres DB 3 connections: 27/27 (17 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:42+01:00 DEBUG metabase.server.middleware.log POST /api/card/167/query 202 [ASYNC: canceled] 1.0 mins (32 DB calls) App DB connections: 3/100 Jetty threads: 3/150 (25 idle, 0 queued) (344 total active threads) Queries in flight: 2 (0 queued); postgres DB 3 connections: 32/32 (22 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:42+01:00 DEBUG metabase.server.middleware.log POST /api/card/2372/query 202 [ASYNC: canceled] 1.0 mins (31 DB calls) App DB connections: 4/100 Jetty threads: 3/150 (24 idle, 0 queued) (343 total active threads) Queries in flight: 1 (0 queued); postgres DB 3 connections: 32/32 (26 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:42+01:00 DEBUG metabase.server.middleware.log POST /api/dataset 202 [ASYNC: completed] 39.1 s (4 DB calls) App DB connections: 0/100 Jetty threads: 4/150 (24 idle, 0 queued) (343 total active threads) Queries in flight: 1 (0 queued); postgres DB 3 connections: 50/50 (46 threads blocked)
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:52+01:00 INFO metabase.query-processor.middleware.cache Query took 1.2 mins to run; minimum for cache eligibility is 4.0 s
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:53+01:00 INFO metabase.query-processor.middleware.cache Query took 1.2 mins to run; minimum for cache eligibility is 4.0 s
[32f4440e-4ca2-447f-ad7b-2c62062ea6ec] 2021-12-01T00:07:54+01:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
I've also looked at
select count(*) used from pg_stat_activity;
--> max I got was 56 or so during the fail loading of the dashboard.
select setting::int max_conn from pg_settings where name=$$max_connections$$
--> always get 500.
Here are more details about the logs from one of the 2 tests (cut because it was too big):
> [
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:16:00.398266+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:19:00.057202+01:00","pid":9689,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:19:00.057178+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":50026},
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:16:00.353239+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:19:04.260293+01:00","pid":9688,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:19:04.260269+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":50024},
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:16:00.346127+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:18:57.98919+01:00","pid":9687,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:18:57.989168+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":50022},
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:16:00.252965+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:18:55.513206+01:00","pid":9686,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:18:55.513179+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":50020},
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:16:00.249261+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:17:00.849196+01:00","pid":9685,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:17:00.849167+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":50018},
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:16:00.209268+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:19:03.465211+01:00","pid":9684,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:19:03.46518+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":50016},
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:16:00.097166+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:19:04.695363+01:00","pid":9683,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:19:04.69534+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":50014},
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:16:00.094789+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:19:04.832684+01:00","pid":9682,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:19:04.832664+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":50012},
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:16:00.057263+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:19:05.113175+01:00","pid":9681,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:19:05.113152+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":50010},
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:15:59.943519+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:16:59.605194+01:00","pid":9679,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:16:59.605157+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":50006},
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:15:59.94336+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:18:44.889776+01:00","pid":9680,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:18:44.889754+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":50008},
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:15:59.937246+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:19:01.645203+01:00","pid":9678,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:19:01.645178+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":50004},
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:15:59.825933+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:19:03.577208+01:00","pid":9677,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:19:03.577185+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":50002},
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:15:59.822866+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:18:54.293207+01:00","pid":9675,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:18:54.293184+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":49998},
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:15:59.821274+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:19:04.209196+01:00","pid":9676,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:19:04.209172+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":50000},
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:15:59.71374+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:19:05.548768+01:00","pid":9674,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:19:05.548741+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":49996},
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:15:59.713559+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:16:59.713683+01:00","pid":9673,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:16:59.713633+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":49994},
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:15:59.711293+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:16:59.594157+01:00","pid":9672,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:16:59.594117+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":49992},
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:15:59.589251+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:19:04.82611+01:00","pid":9671,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:19:04.826084+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":49990},
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:15:59.557271+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:16:59.722202+01:00","pid":9670,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:16:59.722175+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":49988},
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:15:59.557268+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:16:59.475787+01:00","pid":9669,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:16:59.47576+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":49986},
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:15:59.498134+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:19:04.629893+01:00","pid":9668,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:19:04.629871+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":49984},
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:15:59.461225+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:16:59.666881+01:00","pid":9667,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:16:59.666834+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":49982},
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:15:59.458177+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:19:04.950046+01:00","pid":9666,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:19:04.950024+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":49980},
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:15:59.4253+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:16:59.673719+01:00","pid":9665,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:16:59.67368+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":49978},
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:15:59.36632+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:16:59.647266+01:00","pid":9663,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:16:59.64707+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":49974},
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:15:59.364758+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:16:59.60919+01:00","pid":9662,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:16:59.609159+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":49972},
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:15:59.361254+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:19:05.437779+01:00","pid":9664,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:19:05.437755+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":49976},
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:15:59.304169+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:16:59.729187+01:00","pid":9660,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:16:59.729153+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":49968},
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:15:59.302412+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:19:05.449967+01:00","pid":9661,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:19:05.449945+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":49970},
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:15:59.301261+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:19:04.738721+01:00","pid":9659,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:19:04.738697+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":49966},
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:15:59.241953+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:17:01.660314+01:00","pid":9658,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:17:01.660275+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":49964},
> {"client_addr":"34.244.195.34","xact_start":null,"backend_xid":null,"wait_event":"ClientRead","usesysid":16384,"backend_type":"client backend","backend_start":"2021-12-01T00:15:59.23445+01:00","query":"SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED","state_change":"2021-12-01T00:19:02.881202+01:00","pid":9657,"datname":"d33b4cjhp5ms6","client_hostname":null,"application_name":"Metabase v0.41.2 [32f4440e-4ca2-447f-ad7b-2c62062ea6ec]","wait_event_type":"Client","state":"idle","datid":16402,"query_start":"2021-12-01T00:19:02.881171+01:00","backend_xmin":null,"usename":"ubmh8t9qchmi1h","client_port":49962},
PS: I remember changing the parameters for the cache helped with overall performances. Perhaps, the values we use are problematic ?
- MINIMUM QUERY DURATION = 5
- TTL = 50
- MAX CACHE ENTRY SIZE = 200000
Then I changed today the param to:
- MINIMUM QUERY DURATION = 4
- TTL = 2
- MAX CACHE ENTRY SIZE = 100000
To see if it would make an impact. Performances are not worse but there are definitely not better.
Thanks in advance for your help !