Hello,
I have three tables:
- test_db_bench_1
- test_db_bench_tenants
- test_db_bench_tenant_closure
And the query to join them:
SELECT "test_db_bench_1"."id" id, "test_db_bench_1"."tenant_id"
FROM "test_db_bench_1"
JOIN "test_db_bench_tenants" AS "tenants_child" ON
(("tenants_chil
ll
remains much longer than the query execution time.
As for the stats - default_statistics_target has not been changed, has a
value of 100, and no explicit settings for the columns have been applied
("Stats target" is empty).
Could it be a regression? I'll check it on PG14 when I
('4c79c1c5-21ae-45a0-8734-75d67abd0330');
id | tenant_id
+---
(0 rows)
Time: 1.311 ms
# EXECUTE the_query('4c79c1c5-21ae-45a0-8734-75d67abd0330');
id | tenant_id
+---
(0 rows)
Time: 1.230 ms
--
Mikhail
On Mon, 11 Sept 2023 at 09:23, Anupam b wrote:
