sasog23
sasog23
EXPLAIN (ANALYZE, BUFFERS) Aggregate (cost=587.91..587.92 rows=1 width=32) (actual time=8830.090..8830.115 rows=1 loops=1) Buffers: shared hit=1976728, temp read=954 written=956 -> Subquery Scan on info (cost=582.01..587.87 rows=7 width=152) (actual time=8677.645..8829.953 rows=57 loops=1) Buffers:...
what helps is SET enable_nestloop = off; query takes less then 2seconds but it's probably not a good idea to change this flag
upgrade to "PostgreSQL 16.3 (Debian 16.3-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit" solved the problem
after a few weeks the problem reappeared
slow query is only the first one 
after executing bellow script, the "response time" of the query went back to "normal"...less than 1s DO $$ DECLARE r RECORD; BEGIN FOR r IN (SELECT nspname FROM pg_namespace WHERE...