Console Output
02:46:20 [2025-11-29T02:46:20.224Z] + export POSTGRES_DB=****
02:46:20 [2025-11-29T02:46:20.224Z] + export POSTGRES_USER=****
02:46:20 [2025-11-29T02:46:20.224Z] + export PGPASSWORD=****
02:46:20 [2025-11-29T02:46:20.224Z] + echo 📈 Running basic performance queries...
02:46:20 [2025-11-29T02:46:20.224Z] 📈 Running basic performance queries...
02:46:20 [2025-11-29T02:46:20.225Z] + docker exec -e PGPASSWORD=**** ****-**** psql -h localhost -U **** -d **** -c
02:46:20 [2025-11-29T02:46:20.225Z] -- Test basic query performance
02:46:20 [2025-11-29T02:46:20.225Z] EXPLAIN ANALYZE SELECT 1 as test_query;
02:46:20 [2025-11-29T02:46:20.225Z]
02:46:20 [2025-11-29T02:46:20.225Z] -- Test system catalog performance
02:46:20 [2025-11-29T02:46:20.225Z] EXPLAIN ANALYZE SELECT COUNT(*) FROM information_schema.tables;
02:46:20 [2025-11-29T02:46:20.225Z]
02:46:20 [2025-11-29T02:46:20.225Z] -- Test connection info
02:46:20 [2025-11-29T02:46:20.225Z] SELECT database_name, process_count FROM (
02:46:20 [2025-11-29T02:46:20.225Z] SELECT datname as database_name, COUNT(*) as process_count
02:46:20 [2025-11-29T02:46:20.226Z] FROM pg_stat_activity
02:46:20 [2025-11-29T02:46:20.226Z] GROUP BY datname
02:46:20 [2025-11-29T02:46:20.226Z] ) as activity_stats;
02:46:20 [2025-11-29T02:46:20.226Z]
02:46:20 [2025-11-29T02:46:20.477Z] QUERY PLAN
02:46:20 [2025-11-29T02:46:20.477Z] ---------------------------------------------------------------------------------------
02:46:20 [2025-11-29T02:46:20.477Z] Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.006..0.012 rows=1.00 loops=1)
02:46:20 [2025-11-29T02:46:20.477Z] Planning:
02:46:20 [2025-11-29T02:46:20.477Z] Buffers: shared hit=3
02:46:20 [2025-11-29T02:46:20.477Z] Planning Time: 0.235 ms
02:46:20 [2025-11-29T02:46:20.477Z] Execution Time: 0.162 ms
02:46:20 [2025-11-29T02:46:20.477Z] (5 rows)
02:46:20 [2025-11-29T02:46:20.477Z]
02:46:20 [2025-11-29T02:46:20.478Z] QUERY PLAN
02:46:20 [2025-11-29T02:46:20.478Z] --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
02:46:20 [2025-11-29T02:46:20.478Z] Aggregate (cost=71.97..71.98 rows=1 width=8) (actual time=13.089..13.147 rows=1.00 loops=1)
02:46:20 [2025-11-29T02:46:20.478Z] Buffers: shared hit=28 read=12
02:46:20 [2025-11-29T02:46:20.478Z] -> Hash Left Join (cost=36.66..71.69 rows=112 width=0) (actual time=9.005..12.574 rows=215.00 loops=1)
02:46:20 [2025-11-29T02:46:20.478Z] Hash Cond: (c.reloftype = t.oid)
02:46:20 [2025-11-29T02:46:20.479Z] Buffers: shared hit=28 read=12
02:46:20 [2025-11-29T02:46:20.479Z] -> Hash Join (cost=1.09..34.58 rows=112 width=4) (actual time=0.793..3.240 rows=215.00 loops=1)
02:46:20 [2025-11-29T02:46:20.479Z] Hash Cond: (c.relnamespace = nc.oid)
02:46:20 [2025-11-29T02:46:20.479Z] Buffers: shared hit=22 read=1
02:46:20 [2025-11-29T02:46:20.479Z] -> Seq Scan on pg_class c (cost=0.00..32.67 rows=150 width=8) (actual time=0.114..1.383 rows=215.00 loops=1)
02:46:20 [2025-11-29T02:46:20.479Z] Filter: ((relkind = ANY ('{r,v,f,p}'::"char"[])) AND (pg_has_role(relowner, 'USAGE'::text) OR has_table_privilege(oid, 'SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER'::text) OR has_any_column_privilege(oid, 'SELECT, INSERT, UPDATE, REFERENCES'::text)))
02:46:20 [2025-11-29T02:46:20.479Z] Rows Removed by Filter: 202
02:46:20 [2025-11-29T02:46:20.480Z] Buffers: shared hit=13 read=1
02:46:20 [2025-11-29T02:46:20.480Z] -> Hash (cost=1.05..1.05 rows=3 width=4) (actual time=0.571..0.580 rows=4.00 loops=1)
02:46:20 [2025-11-29T02:46:20.480Z] Buckets: 1024 Batches: 1 Memory Usage: 9kB
02:46:20 [2025-11-29T02:46:20.480Z] Buffers: shared hit=9
02:46:20 [2025-11-29T02:46:20.480Z] -> Seq Scan on pg_namespace nc (cost=0.00..1.05 rows=3 width=4) (actual time=0.195..0.505 rows=4.00 loops=1)
02:46:20 [2025-11-29T02:46:20.480Z] Filter: (NOT pg_is_other_temp_schema(oid))
02:46:20 [2025-11-29T02:46:20.480Z] Buffers: shared hit=9
02:46:20 [2025-11-29T02:46:20.480Z] -> Hash (cost=27.29..27.29 rows=662 width=4) (actual time=8.117..8.140 rows=639.00 loops=1)
02:46:20 [2025-11-29T02:46:20.480Z] Buckets: 1024 Batches: 1 Memory Usage: 31kB
02:46:20 [2025-11-29T02:46:20.481Z] Buffers: shared hit=6 read=11
02:46:20 [2025-11-29T02:46:20.481Z] -> Hash Join (cost=1.09..27.29 rows=662 width=4) (actual time=0.284..6.019 rows=639.00 loops=1)
02:46:20 [2025-11-29T02:46:20.481Z] Hash Cond: (t.typnamespace = nt.oid)
02:46:20 [2025-11-29T02:46:20.481Z] Buffers: shared hit=6 read=11
02:46:20 [2025-11-29T02:46:20.481Z] -> Seq Scan on pg_type t (cost=0.00..22.62 rows=662 width=8) (actual time=0.069..2.159 rows=639.00 loops=1)
02:46:20 [2025-11-29T02:46:20.481Z] Buffers: shared hit=5 read=11
02:46:20 [2025-11-29T02:46:20.481Z] -> Hash (cost=1.04..1.04 rows=4 width=4) (actual time=0.155..0.163 rows=4.00 loops=1)
02:46:20 [2025-11-29T02:46:20.481Z] Buckets: 1024 Batches: 1 Memory Usage: 9kB
02:46:20 [2025-11-29T02:46:20.481Z] Buffers: shared hit=1
02:46:20 [2025-11-29T02:46:20.482Z] -> Seq Scan on pg_namespace nt (cost=0.00..1.04 rows=4 width=4) (actual time=0.093..0.108 rows=4.00 loops=1)
02:46:20 [2025-11-29T02:46:20.482Z] Buffers: shared hit=1
02:46:20 [2025-11-29T02:46:20.482Z] Planning:
02:46:20 [2025-11-29T02:46:20.482Z] Buffers: shared hit=332 read=14
02:46:20 [2025-11-29T02:46:20.482Z] Planning Time: 15.763 ms
02:46:20 [2025-11-29T02:46:20.482Z] Execution Time: 15.111 ms
02:46:20 [2025-11-29T02:46:20.482Z] (35 rows)
02:46:20 [2025-11-29T02:46:20.482Z]
02:46:20 [2025-11-29T02:46:20.482Z] database_name | process_count
02:46:20 [2025-11-29T02:46:20.482Z] ---------------+---------------
02:46:20 [2025-11-29T02:46:20.482Z] | 8
02:46:20 [2025-11-29T02:46:20.482Z] **** | 1
02:46:20 [2025-11-29T02:46:20.482Z] authentik | 7
02:46:20 [2025-11-29T02:46:20.482Z] (3 rows)
02:46:20 [2025-11-29T02:46:20.482Z]
