AlloyDB - pgbench

Table of contents:

Report generated on: 2024-10-07 15:54:21.50275+00 on database: pgbench by user: postgres using: pg2html.sql v.1.0.28b
Software by Meo

Summary
Item Value
Database : pgbench
DB Size: 1603 MB
Version : PostgreSQL 15.7
Memory buffers (MB) : 12840
Wal Archiving : on
Started : 2024-10-07 12:38:35.73761+00
Work area (MB) : 131
Defined Users/Roles : 9 / 14
Defined Schemata : 2
Defined Tables : 74
Databases : 4
Sessions : 88
Sessions (active) : 4
Host IP : 34.154.13.269/32
Port (used): 5432
Port (configured): 5432

Version
PostgreSQL 15.7 on x86_64-pc-linux-gnu, compiled by Debian clang version 12.0.1, 64-bit15.7150007

Version check
Version Supported Recent major release (up to N-2) Recent minor release (up to N-1) Notes
PostgreSQL 15.7 YES YES YES Latest Releases: 16.4, 15.8, 14.13, 13.16, 12.20
Latest Unsupported: 11.22, 10.23, 9.6.24, 9.5.25, 9.4.26, 9.3.25, 9.2.24, 9.1.24, 9.0.23, 8.4.21, 8.3.23, 8.2.23, 8.1.23, 8.0.26; 7.4.30, 6.5.3

Databases
Name OID Owner Size HR Size
postgres 5 alloydbsuperuser 21821106 21 MB
alloydbadmin 16384 alloydbadmin 15128242 14 MB
alloydbmetadata 16414 alloydbadmin 12367538 12 MB
pgbench 27779 postgres 1593276082 1519 MB
TOTAL (MB) 6 1602 1603 MB

Schema/Object Matrix
SchemaOwner Table Index Part. Table Part. Index View Sequence Composite type Foreign table TOAST table Materialized view TOTAL Partitions Not Partitions Unlogged Temporary
information_schema alloydbadmin 4 0 0 0 65 0 0 0 0 0 69 0 4 0 0
pg_catalog alloydbadmin 66 124 0 0 75 0 0 0 0 0 265 0 66 0 0
pg_toast alloydbadmin 0 42 0 0 0 0 0 0 42 0 84 0 0 0 0
public alloydbadmin 0 0 0 0 43 0 0 0 0 0 43 0 0 0 0
public postgres 4 3 0 0 3 0 0 0 0 0 10 0 4 0 0
TOTALTOTAL 74 169 0 0 186 0 0 0 42 0 471 0 74 0 0

Constraints
Schema Primary Unique Foreign Check Trigger Exclusion TOTAL
public 3 0 0 0 0 0 3

Partitions
SchemaOwner Object Type Partitioned Objects Partitions

Schema/Function Matrix
SchemaOwner Functions Procedures TOTAL
information_schema alloydbadmin 11 0 11
pg_catalog alloydbadmin 3235 0 3235
public alloydbadmin 133 0 133
TOTALTOTAL 3379 0 3379

Schema/Trigger Matrix
Schema INSERT UPDATE DELETE Row Statement BEFORE AFTER INSTEAD TOTAL

Event Triggers
Event Name Owner Function Enabled Enable mode Tags

Tablespaces
Name Owner Location HR Size
pg_default alloydbadmin 1603 MB
pg_global alloydbadmin 3812 kB

Tablespace Space Usage
Tablespace Table# Tables rows Tables KBytes Indexes KBytes TOAST KBytes Total KBytes
pg_global 13 22 40 328 0 368
61 10,023,204 1,315,040 222,872 584 1,538,496

Space Usage
SchemaOwner Table# Tables rows Tables KBytes Indexes KBytes TOAST KBytes Total KBytes
information_schema alloydbadmin 4 759 88 0 0 88
pg_catalog alloydbadmin 66 21,367 3,400 3,376 0 6,776
pg_toast alloydbadmin 0 0 0 352 584 936
public alloydbadmin 0 0 0 0 0 0
public postgres 4 10,001,100 1,311,592 219,472 0 1,531,064
TOTALTOTAL 74 10,023,225 1,315,080 223,200 584 1,538,864

Internals
Tables# Rows Relpages*8 Total Size Main Fork Free Space Map Visibility Map Initialization Fork
74 10,023,225 1,315,080 1,558,984 1,327,832 1,400 376 0

Vacuum and Analyze
# Tables Last autoVACUUM Last VACUUM Last autoANALYZE Last ANALYZE
4 2024-10-07 15:44:06.563868+00 2024-10-07 15:54:02.688737+00 2024-10-07 15:44:06.61567+00 2024-10-07 13:15:45.993086+00

High dead tuples
Table Tuples Dead tuples Dead% Last autoVACUUM Last VACUUM Last autoANALYZE Last ANALYZE
Big Table Tuples Dead tuples - Last autoVACUUM Last VACUUM Last autoANALYZE Last ANALYZE
public.pgbench_accounts 10000035 112822 - 2024-10-07 13:15:45.878787+00 2024-10-07 13:15:45.981603+00
public.pgbench_history 5873 0 - 2024-10-07 15:44:06.563868+00 2024-10-07 13:15:45.992931+00 2024-10-07 15:44:06.61567+00 2024-10-07 13:15:45.993086+00
pg_catalog.pg_attribute 3474 88 - 2024-10-07 13:03:04.774724+00 2024-10-07 13:03:04.79195+00
pg_catalog.pg_proc 3383 10 - 2024-10-07 13:03:04.806576+00 2024-10-07 13:03:04.827986+00
public.pgbench_tellers 1000 403 - 2024-10-07 15:44:06.548411+00 2024-10-07 15:54:02.688737+00 2024-10-07 15:44:06.549232+00 2024-10-07 13:15:45.864884+00

Bloated tables (estimated size)
Table Fillfactor Table Size HR Size Bloat HR Bloat Bloat%
public.pgbench_accounts 100 1342955520 1281 MB 19070976 18 MB 1 %
public.pgbench_tellers 100 81920 80 kB 32768 32 kB 40 %
pg_catalog.pg_depend 100 180224 176 kB 32768 32 kB 18 %
public.pgbench_branches 100 32768 32 kB 24576 24 kB 75 %
pg_catalog.pg_description 100 368640 360 kB 16384 16 kB 4 %
pg_catalog.pg_init_privs 100 32768 32 kB 8192 8192 bytes 25 %
information_schema.sql_features 100 65536 64 kB 8192 8192 bytes 12 %
Bloated tables (estimated percentage)
Table Fillfactor Table Size HR Size Bloat HR Bloat Bloat%
public.pgbench_branches 100 32768 32 kB 24576 24 kB 75 %
public.pgbench_tellers 100 81920 80 kB 32768 32 kB 40 %
pg_catalog.pg_init_privs 100 32768 32 kB 8192 8192 bytes 25 %
pg_catalog.pg_depend 100 180224 176 kB 32768 32 kB 18 %
information_schema.sql_features 100 65536 64 kB 8192 8192 bytes 12 %

Database max age
Database Max XID age % Wraparound
alloydbadmin 144217 0.01
template0 144217 0.01
postgres 144217 0.01
template1 144217 0.01
alloydbmetadata 144217 0.01
pgbench 144217 0.01

Relations too aged
Schema Relation XID age Overdue HR Size HR Total Size

Users/Roles
Role Login Inherit Superuser Expiry time Max Connections Config
alloydbadmin true true true -1
alloydbagent true true false -1
alloydbexport true true false -1
alloydbimportexport true true false -1
alloydbmetadata true true false -1
alloydbobservability true true false -1
alloydbreplica true true false -1
alloydbsuperuser true true false -1
postgres true true false -1
alloydbiamuser false true false -1
pg_checkpoint false true false -1
pg_database_owner false true false -1
pg_execute_server_program false true false -1
pg_monitor false true false -1
pg_read_all_data false true false -1
pg_read_all_settings false true false -1
pg_read_all_stats false true false -1
pg_read_server_files false true false -1
pg_signal_backend false true false -1
pg_stat_scan_tables false true false -1
pg_use_reserved_worker_processes false true false -1
pg_write_all_data false true false -1
pg_write_server_files false true false -1
TOTAL Users 9
TOTAL Roles 14

Users with poor password
Username Password Note

HBA Rules
Type Database User Address Netmask Auth Options Error 

Non-Superuser Ownership


Object Type Name Owner

Database  alloydbadmin  alloydbadmin

Database  alloydbmetadata  alloydbadmin

Database  postgres  alloydbsuperuser

Schema  information_schema  alloydbadmin

Schema  pg_catalog  alloydbadmin

Schema  pg_toast  alloydbadmin

Schema  public  alloydbsuperuser




Granted Roles


Grantee Admin Option Granted Roles

 alloydbagent  f  alloydbsuperuser

 alloydbexport  f  pg_read_all_data

 alloydbimportexport  f  alloydbsuperuser

 alloydbobservability  f  pg_monitor

 alloydbsuperuser  f  pg_monitor

 pg_monitor  f  pg_read_all_settings, pg_read_all_stats, pg_stat_scan_tables




Grants on Objects


Grantee Schema Count Privileges

 PUBLIC  public  45  SELECT

Per-User Sessions
User Database Count Active Idle TX
postgres pgbench 66 7 49
alloydbadmin alloydbadmin 11 0 0
8 0 0
alloydbadmin 3 0 0
TOTAL ( 2 distinct users)88 10 49
Per-Host Sessions
Host Database Count Active Idle TX
93.39.13.269 pgbench 65 6 53
11 0 0
127.0.0.1 alloydbadmin 9 0 0
alloydbadmin 2 0 0
pgbench 1 1 0
TOTAL ( 2 distinct clients)88 8 53
Per-APP Sessions
APP Database Count Active Idle TX
pgbench pgbench 65 6 54
11 0 0
alloydbagent alloydbadmin 3 0 0
alloydbadmin 1 0 0
alloydbagent-health_agent-cached_read alloydbadmin 1 0 0
alloydbagent-health_agent-cached_write alloydbadmin 1 0 0
alloydbagent-health_agent-healthz alloydbadmin 1 0 0
alloydbagent-health_agent-main alloydbadmin 1 0 0
alloydbagent-health_agent-non-critical alloydbadmin 1 0 0
alloydbagent-telemetry-reader alloydbadmin 1 0 0
perfsnap_worker alloydbadmin 1 0 0
psql pgbench 1 1 0
TOTAL ( 11 distinct applications)88 6 52

Sessions
Pid Database User Address Session start State Query start Duration Backend Application Query
81120 pgbench postgres 93.39.13.269 2024-10-07 15:54:03 active 2024-10-07 15:54:25.11798+00 00:00:00.264556 client backend pgbench UPDATE pgbench_branches SET bbalance = bbalance + -269 WHERE bid = 41;
81148 pgbench postgres 93.39.13.269 2024-10-07 15:54:05 active 2024-10-07 15:54:25.20794+00 00:00:00.174596 client backend pgbench UPDATE pgbench_branches SET bbalance = bbalance + 4472 WHERE bid = 18;
81242 pgbench postgres 93.39.13.269 2024-10-07 15:54:08 active 2024-10-07 15:54:25.342988+00 00:00:00.039548 client backend pgbench UPDATE pgbench_branches SET bbalance = bbalance + 4742 WHERE bid = 17;
81144 pgbench postgres 93.39.13.269 2024-10-07 15:54:04 active 2024-10-07 15:54:25.350083+00 00:00:00.032453 client backend pgbench UPDATE pgbench_branches SET bbalance = bbalance + 2365 WHERE bid = 100;
81122 pgbench postgres 93.39.13.269 2024-10-07 15:54:04 active 2024-10-07 15:54:25.383169+00 -00:00:00.000633 client backend pgbench END;
81169 pgbench postgres 93.39.13.269 2024-10-07 15:54:05 active 2024-10-07 15:54:25.383364+00 -00:00:00.000828 client backend pgbench END;
6822 alloydbadmin alloydbadmin 127.0.0.1 2024-10-07 12:38:57 idle 2024-10-07 12:38:57.087194+00 03:15:28.295342 client backend alloydbagent-telemetry-reader ;
6341 alloydbadmin alloydbadmin 2024-10-07 12:38:42 idle 2024-10-07 12:40:55.968348+00 03:13:29.414188 g_stats worker perfsnap_worker INSERT INTO pgsnap.snapshot(instance_id , node_id , snap_description , snap_type) SELECT pgsnap.g_instance_id() , NULL , $1 , $2 RETURNING snap_id
81009 alloydbadmin alloydbadmin 127.0.0.1 2024-10-07 15:53:52 idle 2024-10-07 15:53:52.184899+00 00:00:33.197637 client backend alloydbagent SELECT * FROM alloydb_pass_valid.get_policy_errors(reset => false);
79547 alloydbadmin alloydbadmin 127.0.0.1 2024-10-07 15:50:00 idle 2024-10-07 15:54:20.181899+00 00:00:05.200637 client backend alloydbagent-health_agent-non-critical SELECT * FROM (SELECT client_addr, application_name, state, CASE flush_lsn >= pg_current_wal_flush_lsn() WHEN true THEN 0::bigint WHEN false THEN ROUND(EXTRACT(epoch FROM flush_lag)*1000)::bigint END AS flush_lag_ms, CASE replay_lsn >= pg_current_wal_flush_lsn() WHEN true THEN 0::bigint WHEN false THEN ROUND(EXTRACT(epoch FROM replay_lag)*1000)::bigint END AS replay_lag_ms, ROUND(EXTRACT(epoch FROM now()-backend_start)*1000)::bigint AS uptime_ms, pg_current_wal_flush_lsn() AS local_flush_lsn, flush_lsn AS remote_flush_lsn, replay_lsn FROM pg_stat_replication) as a WHERE application_name LIKE '%-rep' AND client_addr IS NOT NULL AND flush_lag_ms IS NOT NULL AND replay_lag_ms IS NOT NULL AND uptime_ms IS NOT NULL;
79691 alloydbadmin alloydbadmin 127.0.0.1 2024-10-07 15:50:26 idle 2024-10-07 15:54:23.611485+00 00:00:01.771051 client backend alloydbagent-health_agent-main SELECT master_time, (now() at time zone 'utc') as current_time FROM public.heartbeat WHERE id = 1;
7503 alloydbadmin alloydbadmin 127.0.0.1 2024-10-07 12:40:28 idle 2024-10-07 15:54:24.70273+00 00:00:00.679806 client backend alloydbagent-health_agent-cached_write UPDATE health_data_write SET v=v+1
81031 alloydbadmin alloydbadmin 127.0.0.1 2024-10-07 15:53:54 idle 2024-10-07 15:54:24.906388+00 00:00:00.476148 client backend alloydbagent ;
6409 alloydbadmin alloydbadmin 127.0.0.1 2024-10-07 12:38:43 idle 2024-10-07 15:54:25.012133+00 00:00:00.370403 client backend alloydbagent-health_agent-healthz SELECT NOT pg_is_in_recovery();
6410 alloydbadmin alloydbadmin 127.0.0.1 2024-10-07 12:38:43 idle 2024-10-07 15:54:25.20841+00 00:00:00.174126 client backend alloydbagent-health_agent-cached_read SELECT (CASE WHEN pg_is_in_recovery() THEN pg_last_wal_replay_lsn() ELSE pg_current_wal_flush_lsn() END) - '0/0'::pg_lsn, (CASE WHEN pg_is_in_recovery() THEN pg_last_wal_receive_lsn() ELSE pg_current_wal_lsn() END) - '0/0'::pg_lsn, (CASE WHEN pg_is_in_recovery() THEN pg_last_wal_receive_lsn() ELSE pg_current_wal_insert_lsn() END) - '0/0'::pg_lsn
81020 alloydbadmin alloydbadmin 127.0.0.1 2024-10-07 15:53:53 idle 2024-10-07 15:54:25.31697+00 00:00:00.065566 client backend alloydbagent SELECT pg_is_in_recovery();
81240 pgbench postgres 93.39.13.269 2024-10-07 15:54:08 idle 2024-10-07 15:54:25.367372+00 00:00:00.015164 client backend pgbench END;
81118 pgbench postgres 93.39.13.269 2024-10-07 15:54:03 idle 2024-10-07 15:54:25.367728+00 00:00:00.014808 client backend pgbench END;
81193 pgbench postgres 93.39.13.269 2024-10-07 15:54:06 idle 2024-10-07 15:54:25.368457+00 00:00:00.014079 client backend pgbench END;
81176 pgbench postgres 93.39.13.269 2024-10-07 15:54:06 idle 2024-10-07 15:54:25.380936+00 00:00:00.0016 client backend pgbench END;
81094 pgbench postgres 93.39.13.269 2024-10-07 15:54:02 idle in transaction 2024-10-07 15:54:24.912254+00 00:00:00.470282 client backend pgbench BEGIN;
81167 pgbench postgres 93.39.13.269 2024-10-07 15:54:05 idle in transaction 2024-10-07 15:54:24.933058+00 00:00:00.449478 client backend pgbench UPDATE pgbench_accounts SET abalance = abalance + 4376 WHERE aid = 5370370;
81142 pgbench postgres 93.39.13.269 2024-10-07 15:54:04 idle in transaction 2024-10-07 15:54:25.144758+00 00:00:00.237778 client backend pgbench UPDATE pgbench_branches SET bbalance = bbalance + 4723 WHERE bid = 18;
81220 pgbench postgres 93.39.13.269 2024-10-07 15:54:08 idle in transaction 2024-10-07 15:54:25.144816+00 00:00:00.23772 client backend pgbench UPDATE pgbench_tellers SET tbalance = tbalance + -3027 WHERE tid = 754;
81109 pgbench postgres 93.39.13.269 2024-10-07 15:54:03 idle in transaction 2024-10-07 15:54:25.144955+00 00:00:00.237581 client backend pgbench INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (162, 17, 2687751, 516, CURRENT_TIMESTAMP);
81131 pgbench postgres 93.39.13.269 2024-10-07 15:54:04 idle in transaction 2024-10-07 15:54:25.145191+00 00:00:00.237345 client backend pgbench SELECT abalance FROM pgbench_accounts WHERE aid = 8025940;
81112 pgbench postgres 93.39.13.269 2024-10-07 15:54:03 idle in transaction 2024-10-07 15:54:25.145192+00 00:00:00.237344 client backend pgbench BEGIN;
81244 pgbench postgres 93.39.13.269 2024-10-07 15:54:08 idle in transaction 2024-10-07 15:54:25.145388+00 00:00:00.237148 client backend pgbench SELECT abalance FROM pgbench_accounts WHERE aid = 6046442;
81218 pgbench postgres 93.39.13.269 2024-10-07 15:54:07 idle in transaction 2024-10-07 15:54:25.145532+00 00:00:00.237004 client backend pgbench UPDATE pgbench_accounts SET abalance = abalance + 4787 WHERE aid = 6249454;
81146 pgbench postgres 93.39.13.269 2024-10-07 15:54:04 idle in transaction 2024-10-07 15:54:25.147211+00 00:00:00.235325 client backend pgbench UPDATE pgbench_accounts SET abalance = abalance + -3553 WHERE aid = 8000439;
81195 pgbench postgres 93.39.13.269 2024-10-07 15:54:07 idle in transaction 2024-10-07 15:54:25.288512+00 00:00:00.094024 client backend pgbench UPDATE pgbench_accounts SET abalance = abalance + 33 WHERE aid = 8225692;
81107 pgbench postgres 93.39.13.269 2024-10-07 15:54:03 idle in transaction 2024-10-07 15:54:25.32143+00 00:00:00.061106 client backend pgbench UPDATE pgbench_branches SET bbalance = bbalance + -1535 WHERE bid = 33;
81129 pgbench postgres 93.39.13.269 2024-10-07 15:54:04 idle in transaction 2024-10-07 15:54:25.321565+00 00:00:00.060971 client backend pgbench UPDATE pgbench_branches SET bbalance = bbalance + -776 WHERE bid = 26;
81229 pgbench postgres 93.39.13.269 2024-10-07 15:54:08 idle in transaction 2024-10-07 15:54:25.32262+00 00:00:00.059916 client backend pgbench UPDATE pgbench_branches SET bbalance = bbalance + 1785 WHERE bid = 100;
81154 pgbench postgres 93.39.13.269 2024-10-07 15:54:05 idle in transaction 2024-10-07 15:54:25.322813+00 00:00:00.059723 client backend pgbench UPDATE pgbench_accounts SET abalance = abalance + 2665 WHERE aid = 6680415;
81138 pgbench postgres 93.39.13.269 2024-10-07 15:54:04 idle in transaction 2024-10-07 15:54:25.342682+00 00:00:00.039854 client backend pgbench SELECT abalance FROM pgbench_accounts WHERE aid = 9770479;
81179 pgbench postgres 93.39.13.269 2024-10-07 15:54:06 idle in transaction 2024-10-07 15:54:25.343375+00 00:00:00.039161 client backend pgbench BEGIN;
81174 pgbench postgres 93.39.13.269 2024-10-07 15:54:05 idle in transaction 2024-10-07 15:54:25.343595+00 00:00:00.038941 client backend pgbench SELECT abalance FROM pgbench_accounts WHERE aid = 7463268;
81202 pgbench postgres 93.39.13.269 2024-10-07 15:54:07 idle in transaction 2024-10-07 15:54:25.343807+00 00:00:00.038729 client backend pgbench SELECT abalance FROM pgbench_accounts WHERE aid = 2217330;
81160 pgbench postgres 93.39.13.269 2024-10-07 15:54:05 idle in transaction 2024-10-07 15:54:25.345214+00 00:00:00.037322 client backend pgbench BEGIN;
81197 pgbench postgres 93.39.13.269 2024-10-07 15:54:07 idle in transaction 2024-10-07 15:54:25.347125+00 00:00:00.035411 client backend pgbench UPDATE pgbench_branches SET bbalance = bbalance + 230 WHERE bid = 23;
81212 pgbench postgres 93.39.13.269 2024-10-07 15:54:07 idle in transaction 2024-10-07 15:54:25.350211+00 00:00:00.032325 client backend pgbench INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (57, 20, 8345195, -2102, CURRENT_TIMESTAMP);
81134 pgbench postgres 93.39.13.269 2024-10-07 15:54:04 idle in transaction 2024-10-07 15:54:25.350687+00 00:00:00.031849 client backend pgbench UPDATE pgbench_tellers SET tbalance = tbalance + 2722 WHERE tid = 998;
81246 pgbench postgres 93.39.13.269 2024-10-07 15:54:09 idle in transaction 2024-10-07 15:54:25.351618+00 00:00:00.030918 client backend pgbench UPDATE pgbench_branches SET bbalance = bbalance + 2021 WHERE bid = 7;
81248 pgbench postgres 93.39.13.269 2024-10-07 15:54:09 idle in transaction 2024-10-07 15:54:25.35162+00 00:00:00.030916 client backend pgbench UPDATE pgbench_branches SET bbalance = bbalance + -2747 WHERE bid = 15;
81185 pgbench postgres 93.39.13.269 2024-10-07 15:54:06 idle in transaction 2024-10-07 15:54:25.35244+00 00:00:00.030096 client backend pgbench SELECT abalance FROM pgbench_accounts WHERE aid = 1065770;
81103 pgbench postgres 93.39.13.269 2024-10-07 15:54:03 idle in transaction 2024-10-07 15:54:25.35378+00 00:00:00.028756 client backend pgbench INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (760, 44, 2516192, 4312, CURRENT_TIMESTAMP);
81216 pgbench postgres 93.39.13.269 2024-10-07 15:54:07 idle in transaction 2024-10-07 15:54:25.364452+00 00:00:00.018084 client backend pgbench UPDATE pgbench_tellers SET tbalance = tbalance + -3455 WHERE tid = 573;
81098 pgbench postgres 93.39.13.269 2024-10-07 15:54:03 idle in transaction 2024-10-07 15:54:25.366173+00 00:00:00.016363 client backend pgbench UPDATE pgbench_tellers SET tbalance = tbalance + -2634 WHERE tid = 971;
81124 pgbench postgres 93.39.13.269 2024-10-07 15:54:04 idle in transaction 2024-10-07 15:54:25.366404+00 00:00:00.016132 client backend pgbench BEGIN;
81188 pgbench postgres 93.39.13.269 2024-10-07 15:54:06 idle in transaction 2024-10-07 15:54:25.366763+00 00:00:00.015773 client backend pgbench INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (794, 28, 2615710, 4683, CURRENT_TIMESTAMP);
81206 pgbench postgres 93.39.13.269 2024-10-07 15:54:07 idle in transaction 2024-10-07 15:54:25.366937+00 00:00:00.015599 client backend pgbench SELECT abalance FROM pgbench_accounts WHERE aid = 9231296;
81231 pgbench postgres 93.39.13.269 2024-10-07 15:54:08 idle in transaction 2024-10-07 15:54:25.367204+00 00:00:00.015332 client backend pgbench UPDATE pgbench_tellers SET tbalance = tbalance + 445 WHERE tid = 587;
81209 pgbench postgres 93.39.13.269 2024-10-07 15:54:07 idle in transaction 2024-10-07 15:54:25.367258+00 00:00:00.015278 client backend pgbench INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (217, 59, 3591367, 3791, CURRENT_TIMESTAMP);
81233 pgbench postgres 93.39.13.269 2024-10-07 15:54:08 idle in transaction 2024-10-07 15:54:25.367549+00 00:00:00.014987 client backend pgbench BEGIN;
81092 pgbench postgres 93.39.13.269 2024-10-07 15:54:02 idle in transaction 2024-10-07 15:54:25.367585+00 00:00:00.014951 client backend pgbench UPDATE pgbench_accounts SET abalance = abalance + 3002 WHERE aid = 8498061;
81151 pgbench postgres 93.39.13.269 2024-10-07 15:54:05 idle in transaction 2024-10-07 15:54:25.367634+00 00:00:00.014902 client backend pgbench UPDATE pgbench_accounts SET abalance = abalance + 2226 WHERE aid = 9756225;
81191 pgbench postgres 93.39.13.269 2024-10-07 15:54:06 idle in transaction 2024-10-07 15:54:25.368074+00 00:00:00.014462 client backend pgbench INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (187, 90, 9746754, -4030, CURRENT_TIMESTAMP);
81183 pgbench postgres 93.39.13.269 2024-10-07 15:54:06 idle in transaction 2024-10-07 15:54:25.368172+00 00:00:00.014364 client backend pgbench UPDATE pgbench_branches SET bbalance = bbalance + -1794 WHERE bid = 27;
81214 pgbench postgres 93.39.13.269 2024-10-07 15:54:07 idle in transaction 2024-10-07 15:54:25.36879+00 00:00:00.013746 client backend pgbench UPDATE pgbench_tellers SET tbalance = tbalance + 493 WHERE tid = 896;
81224 pgbench postgres 93.39.13.269 2024-10-07 15:54:08 idle in transaction 2024-10-07 15:54:25.368916+00 00:00:00.01362 client backend pgbench SELECT abalance FROM pgbench_accounts WHERE aid = 9157713;
81222 pgbench postgres 93.39.13.269 2024-10-07 15:54:08 idle in transaction 2024-10-07 15:54:25.368939+00 00:00:00.013597 client backend pgbench INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (15, 60, 8038542, -1803, CURRENT_TIMESTAMP);
81204 pgbench postgres 93.39.13.269 2024-10-07 15:54:07 idle in transaction 2024-10-07 15:54:25.369925+00 00:00:00.012611 client backend pgbench UPDATE pgbench_accounts SET abalance = abalance + 3954 WHERE aid = 6903425;
81140 pgbench postgres 93.39.13.269 2024-10-07 15:54:04 idle in transaction 2024-10-07 15:54:25.38104+00 00:00:00.001496 client backend pgbench UPDATE pgbench_branches SET bbalance = bbalance + 1565 WHERE bid = 69;
81162 pgbench postgres 93.39.13.269 2024-10-07 15:54:05 idle in transaction 2024-10-07 15:54:25.381069+00 00:00:00.001467 client backend pgbench UPDATE pgbench_tellers SET tbalance = tbalance + 4578 WHERE tid = 987;
81105 pgbench postgres 93.39.13.269 2024-10-07 15:54:03 idle in transaction 2024-10-07 15:54:25.3813+00 00:00:00.001236 client backend pgbench UPDATE pgbench_tellers SET tbalance = tbalance + 864 WHERE tid = 67;
81096 pgbench postgres 93.39.13.269 2024-10-07 15:54:03 idle in transaction 2024-10-07 15:54:25.381428+00 00:00:00.001108 client backend pgbench UPDATE pgbench_accounts SET abalance = abalance + 4074 WHERE aid = 3127252;
81158 pgbench postgres 93.39.13.269 2024-10-07 15:54:05 idle in transaction 2024-10-07 15:54:25.381601+00 00:00:00.000935 client backend pgbench UPDATE pgbench_tellers SET tbalance = tbalance + -3277 WHERE tid = 167;
81238 pgbench postgres 93.39.13.269 2024-10-07 15:54:08 idle in transaction 2024-10-07 15:54:25.381867+00 00:00:00.000669 client backend pgbench UPDATE pgbench_branches SET bbalance = bbalance + 3742 WHERE bid = 36;
81171 pgbench postgres 93.39.13.269 2024-10-07 15:54:05 idle in transaction 2024-10-07 15:54:25.38207+00 00:00:00.000466 client backend pgbench SELECT abalance FROM pgbench_accounts WHERE aid = 5503588;
81136 pgbench postgres 93.39.13.269 2024-10-07 15:54:04 idle in transaction 2024-10-07 15:54:25.38259+00 -00:00:00.000054 client backend pgbench UPDATE pgbench_tellers SET tbalance = tbalance + -194 WHERE tid = 539;
81116 pgbench postgres 93.39.13.269 2024-10-07 15:54:03 idle in transaction 2024-10-07 15:54:25.38274+00 -00:00:00.000204 client backend pgbench INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (524, 3, 8864451, 1557, CURRENT_TIMESTAMP);
81114 pgbench postgres 93.39.13.269 2024-10-07 15:54:03 idle in transaction 2024-10-07 15:54:25.383083+00 -00:00:00.000547 client backend pgbench SELECT abalance FROM pgbench_accounts WHERE aid = 1790295;
81089 pgbench postgres 93.39.13.269 2024-10-07 15:54:02 idle in transaction 2024-10-07 15:54:25.383396+00 -00:00:00.00086 client backend pgbench INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (632, 41, 9837221, 1628, CURRENT_TIMESTAMP);
3873 2024-10-07 12:38:35 checkpointer
3874 2024-10-07 12:38:35 background writer
3876 2024-10-07 12:38:35 dogfish helper
3911 2024-10-07 12:38:36 lux background writer
3912 2024-10-07 12:38:36 lux wal preallocator
6336 alloydbadmin alloydbadmin 2024-10-07 12:38:42 ultra fast cache prewarm launcher
6340 alloydbadmin 2024-10-07 12:38:42 job scheduler leader
7486 2024-10-07 12:40:27 walwriter
7490 2024-10-07 12:40:27 autovacuum launcher
7491 2024-10-07 12:40:27 archiver
7492 alloydbadmin 2024-10-07 12:40:27 btree gc root worker
7493 alloydbadmin 2024-10-07 12:40:27 logical replication launcher

Waiting Locks
Pid Type Database Relation Mode Granted Wait start
81222 transactionid ShareLock f 2024-10-07 15:54:25.4531+00
81134 transactionid ShareLock f 2024-10-07 15:54:25.494379+00
81220 transactionid ShareLock f 2024-10-07 15:54:25.594717+00
81185 transactionid ShareLock f 2024-10-07 15:54:25.605694+00

Blocking Locks
Blocked Pid Blocked User Blocking Pid Blocking User Blocked Statement Blocking Session Current Statement
81160 postgres 81183 postgres UPDATE pgbench_branches SET bbalance = bbalance + -2617 WHERE bid = 27; UPDATE pgbench_branches SET bbalance = bbalance + -1794 WHERE bid = 27;
81144 postgres 81240 postgres UPDATE pgbench_branches SET bbalance = bbalance + 976 WHERE bid = 11; INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (939, 11, 3308169, -3387, CURRENT_TIMESTAMP);
81238 postgres 81167 postgres UPDATE pgbench_branches SET bbalance = bbalance + -3451 WHERE bid = 44; UPDATE pgbench_branches SET bbalance = bbalance + -2294 WHERE bid = 44;
81222 postgres 81140 postgres UPDATE pgbench_tellers SET tbalance = tbalance + 318 WHERE tid = 976; INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (976, 69, 3016504, 1565, CURRENT_TIMESTAMP);
81107 postgres 81160 postgres UPDATE pgbench_branches SET bbalance = bbalance + -3308 WHERE bid = 27; UPDATE pgbench_branches SET bbalance = bbalance + -2617 WHERE bid = 27;
81134 postgres 81248 postgres UPDATE pgbench_branches SET bbalance = bbalance + 2722 WHERE bid = 15; INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (833, 15, 2520810, -2747, CURRENT_TIMESTAMP);

Locks
Pid Type Database Relation Mode Granted
81129 transactionid ShareLock f
81138 transactionid ShareLock f
81193 transactionid ShareLock f
81206 transactionid ShareLock f
81248 transactionid ShareLock f
81089 virtualxid ExclusiveLock t
81089 relation pgbench pgbench_accounts RowExclusiveLock t
81089 transactionid ExclusiveLock t
81089 relation pgbench pgbench_accounts_pkey RowExclusiveLock t
81092 relation pgbench pgbench_accounts_pkey AccessShareLock t
81092 transactionid ExclusiveLock t
81092 relation pgbench pgbench_tellers RowExclusiveLock t
81092 relation pgbench pgbench_branches_pkey RowExclusiveLock t
81092 relation pgbench pgbench_accounts AccessShareLock t
81092 virtualxid ExclusiveLock t
81092 relation pgbench pgbench_branches RowExclusiveLock t
81092 relation pgbench pgbench_accounts RowExclusiveLock t
81092 relation pgbench pgbench_accounts_pkey RowExclusiveLock t
81092 relation pgbench pgbench_tellers_pkey RowExclusiveLock t
81096 relation pgbench pgbench_accounts RowExclusiveLock t
81096 relation pgbench pgbench_branches_pkey RowExclusiveLock t
81096 relation pgbench pgbench_accounts AccessShareLock t
81096 relation pgbench pgbench_accounts_pkey AccessShareLock t
81096 virtualxid ExclusiveLock t
81096 relation pgbench pgbench_accounts_pkey RowExclusiveLock t
81096 relation pgbench pgbench_tellers RowExclusiveLock t
81096 relation pgbench pgbench_branches RowExclusiveLock t
81096 relation pgbench pgbench_tellers_pkey RowExclusiveLock t
81096 transactionid ExclusiveLock t
81096 relation pgbench pgbench_history RowExclusiveLock t
81098 virtualxid ExclusiveLock t
81103 relation pgbench pgbench_accounts_pkey RowExclusiveLock t
81103 transactionid ExclusiveLock t
81103 relation pgbench pgbench_accounts RowExclusiveLock t
81103 virtualxid ExclusiveLock t
81107 relation pgbench pgbench_tellers RowExclusiveLock t
81107 relation pgbench pgbench_accounts_pkey AccessShareLock t
81107 relation pgbench pgbench_accounts_pkey RowExclusiveLock t
81107 relation pgbench pgbench_accounts RowExclusiveLock t
81107 virtualxid ExclusiveLock t
81107 relation pgbench pgbench_branches_pkey RowExclusiveLock t
81107 relation pgbench pgbench_accounts AccessShareLock t
81107 relation pgbench pgbench_tellers_pkey RowExclusiveLock t
81107 relation pgbench pgbench_branches RowExclusiveLock t
81107 transactionid ExclusiveLock t
81109 relation pgbench pgbench_accounts_pkey AccessShareLock t
81109 relation pgbench pgbench_accounts_pkey RowExclusiveLock t
81109 relation pgbench pgbench_accounts AccessShareLock t
81109 relation pgbench pgbench_accounts RowExclusiveLock t
81109 virtualxid ExclusiveLock t
...
TOTAL tuple pgbench 1 ExclusiveLock f
TOTAL transactionid 5 ShareLock f
TOTAL relation pgbench 91 AccessShareLock t
TOTAL relation pgbench 222 RowExclusiveLock t
TOTAL tuple pgbench 5 ExclusiveLock t
TOTAL relation 3 AccessShareLock t
TOTAL transactionid 51 ExclusiveLock t
TOTAL virtualxid 62 ExclusiveLock t

Memory
Element Value Description
shared_buffers 13 GB Sets the number of shared memory buffers used by the server.
temp_buffers 8192 kB Sets the maximum number of temporary buffers used by each session.
wal_buffers 32 MB Sets the number of disk-page buffers in shared memory for WAL.
autovacuum_work_mem -1024 bytes Sets the maximum memory to be used by each autovacuum worker process.
logical_decoding_work_mem 64 MB Sets the maximum memory to be used for logical decoding.
maintenance_work_mem 64 MB Sets the maximum memory to be used for maintenance operations.
work_mem 4096 kB Sets the maximum memory to be used for query workspaces.

Database Statistics
Database Backends Commit TPS Rollback Read Hit Hit Ratio% Return Fetch Insert Update Delete Statistics reset
alloydbadmin 11 136143 10.20 78 1942 6429950 99.97 4087599 3379148 11761 19184 7017 2024-10-07 12:12:04.851704+00
postgres 0 7651 0.57 0 1504 1214109 99.88 2602842 708659 7035 967 2489 2024-10-07 12:12:04.880122+00
alloydbmetadata 0 7694 0.58 0 1016 1176208 99.91 1517114 711571 2515 542 2327 2024-10-07 12:12:04.920571+00
pgbench 66 126180 12.25 26 194587 6434750 97.06 24338839 1324214 10122724 364452 150 2024-10-07 13:02:50.021506+00
TOTAL ( 4 )77 277670 104 199049 15255100 32546421 6123618 10144035 385145 11983 2024-10-07 12:12:04.851704+00

BG Writer statistics
checkpoints_timed checkpoints_req buffers_checkpoint buffers_clean maxwritten_clean buffers_backend buffers_alloc checkpoint_write (s) checkpoint_sync (s) Statistics reset
41 3 1077 0 0 770 206088 96 0 2024-10-07 12:10:55.360272+00

Checkpointer/BGWriter KPI
Timed CP Ratio% Minutes between CP Clean by CP Ratio% Clean by BGW Ratio% BGW Halt Ratio%
93.18 5.08 58.31 0.00 0

Cache statistics
Object Type#Read #Hit Hit Ratio%
Table 167149 3483873 95.42
Index 27437 1233819 97.77

Instance restart: 2024-10-07 12:38:35.73761+00
Statement statistics reset: 2024-10-07 12:38:35.714951+00 Dealloc: 0

Statement statistics
Query User Calls Average (sec.) Max (sec.) Total Time Rows Hit Ratio% WAL MB T
UPDATE pgbench_branches SET bbalance = bbalance + $1 WHERE bid = $2 postgres 121567 0.003 0.836 322276 121567 100.00 9 T
copy pgbench_accounts from stdin with (freeze on) postgres 1 100.263 100.263 100263 10000000 99.99 1048 T
UPDATE pgbench_tellers SET tbalance = tbalance + $1 WHERE tid = $2 postgres 121580 0.001 0.854 70704 121580 100.00 10 T
SELECT default_version, installed_version FROM pg_catalog.pg_available_extensions WHERE name = $1 alloydbadmin 1385 0.032 0.135 43785 1385 99.93 0 T
SELECT COUNT($1) FROM perfsnap.g$snapshots alloydbadmin 193 0.201 0.366 38791 193 100.00 0 T
SELECT g_buffer_accessed_pages() alloydbadmin 193 0.170 0.350 32844 193 0 T
SELECT default_version, installed_version FROM pg_catalog.pg_available_extensions WHERE name = $1 alloydbadmin 588 0.036 0.161 21375 588 99.83 0 T
SELECT setting FROM pg_catalog.pg_settings WHERE name=$1 alloydbadmin 1176 0.010 0.070 11815 1176 0 T
SELECT COUNT($1) FROM perfsnap.g$snapshots alloydbadmin 193 0.059 0.166 11453 193 100.00 0 T
SELECT default_version, installed_version FROM pg_catalog.pg_available_extensions WHERE name = $1 alloydbadmin 392 0.029 0.093 11428 392 100.00 0 T
SELECT (SELECT setting=$1 FROM pg_catalog.pg_settings WHERE name=$2) AND (SELECT setting=$3 FROM pg_catalog.pg_settings WHERE name=$4) AND (SELECT setting=$5 FROM pg_catalog.pg_settings WHERE name=$6) alloydbadmin 196 0.058 0.156 11289 196 0 T
SELECT name, default_version, installed_version FROM pg_catalog.pg_available_extensions alloydbadmin 196 0.051 0.115 10077 21560 100.00 0 T
SELECT a.event, a.class, SUM(a.elapsed_time) AS total_elapsed_time, SUM(a.num_waits) AS total_wait_count, b.is_alloydb AS is_alloydb FROM pgsnap.g$system_wait_stat a JOIN pgsnap.g$wait_event_name_base b ON a.event = b.name GROUP BY a.event, a.class, b.is_alloydb HAVING a.class <> $1 alloydbadmin 193 0.044 0.110 8431 7770 100.00 0 T
select (select setting=$1 from pg_catalog.pg_settings where name=$2) AND (select setting=$3 from pg_catalog.pg_settings where name=$4) alloydbadmin 392 0.021 0.111 8383 392 0 T
SELECT wait_event, ARRAY[ wait_1us, wait_2us, wait_4us, wait_8us, wait_16us, wait_32us, wait_64us, wait_128us, wait_256us, wait_512us, wait_1ms, wait_2ms, wait_4ms, wait_8ms, wait_16ms, wait_32ms, wait_64ms, wait_128ms, wait_256ms, wait_512ms, wait_1s, wait_2s, wait_4s, wait_8s, wait_16s, wait_32s, wait_64s, wait_128s, wait_256s, wait_512s, wait_1024s, wait_2048s], pg_postmaster_start_time() AS start_time FROM pgsnap.g$system_wait_stat_histogram alloydbadmin 193 0.042 0.126 8039 14282 100.00 0 T
SELECT wait_event, ARRAY[ wait_1us, wait_2us, wait_4us, wait_8us, wait_16us, wait_32us, wait_64us, wait_128us, wait_256us, wait_512us, wait_1ms, wait_2ms, wait_4ms, wait_8ms, wait_16ms, wait_32ms, wait_64ms, wait_128ms, wait_256ms, wait_512ms, wait_1s, wait_2s, wait_4s, wait_8s, wait_16s, wait_32s, wait_64s, wait_128s, wait_256s, wait_512s, wait_1024s, wait_2048s], pg_postmaster_start_time() AS start_time FROM pgsnap.g$system_bg_wait_stat_histogram alloydbadmin 193 0.041 0.132 7852 14282 100.00 0 T
SELECT event, elapsed_time, last_cleared_time FROM pgsnap.g$active_system_wait_stat WHERE type = $1 AND (event = $2 OR event = $3 OR event = $4) alloydbadmin 193 0.040 0.114 7717 0 100.00 0 T
SELECT default_version, installed_version FROM pg_catalog.pg_available_extensions WHERE name = $1 alloydbadmin 344 0.019 0.080 6587 344 100.00 0 T
SELECT name, default_version, installed_version FROM pg_catalog.pg_available_extensions alloydbadmin 196 0.031 0.074 6099 21560 99.49 0 T
alter table pgbench_accounts add primary key (aid) postgres 1 5.713 5.713 5713 0 100.00 196 T

Slowest Statements
Query User Calls Average (sec.) Max (sec.) Total Time Rows Hit Ratio% WAL MB
copy pgbench_accounts from stdin with (freeze on) postgres 1 100.263 100.263 100263 10000000 99.99 1048
alter table pgbench_accounts add primary key (aid) postgres 1 5.713 5.713 5713 0 100.00 196
SELECT c.relname, c.relkind, count(*) as buffers, pg_size_pretty(count(*) * $1) as buffered, round($2 * count(*)/(SELECT setting FROM pg_settings WHERE name=$3)::integer, $4) as buffers_pct, round($5 * count(*) * $6 / pg_relation_size(c.oid), $7) as relation_pct, round(avg(usagecount), $8) as usage_avg FROM pg_class c INNER JOIN pg_buffercache b ON b.relfilenode = c.relfilenode INNER JOIN pg_database d ON (b.reldatabase = d.oid AND d.datname = current_database()) WHERE pg_relation_size(c.oid) > $9 GROUP BY c.oid, c.relname, c.relkind ORDER BY 3 DESC LIMIT $10 postgres 2 2.343 2.574 4686 60 100.00 0
create database pgbench postgres 1 1.179 1.179 1179 0 55.99 8
SELECT pg_size_pretty(count(*) * $1) as minimal_cache_size_est FROM pg_buffercache WHERE usagecount >= $2 postgres 2 0.551 0.598 1101 2 0
SELECT pgsnap.g_sql_capture_json_snapshot($1, $2, $3, $4) alloydbadmin 1 0.374 0.374 374 1 92.76 0
CREATE EXTENSION IF NOT EXISTS g_stats SCHEMA public alloydbadmin 1 0.308 0.308 308 0 98.92 4
SELECT pg_promote() alloydbadmin 1 0.300 0.300 300 1 0
CREATE EXTENSION IF NOT EXISTS g_stats SCHEMA public alloydbadmin 1 0.238 0.238 238 0 99.06 4
SELECT COUNT($1) FROM perfsnap.g$snapshots alloydbadmin 193 0.201 0.366 38791 193 100.00 0

Database Calls DBcpu IOcpu Stmt/sec.
alloydbadmin 107717 0.01745 0.00004 9.166
alloydbmetadata 3392 0.00189 0.00001 0.289
pgbench 856027 0.04503 0.00000 72.845
postgres 2428 0.00461 0.00005 0.207
template1 15 0.00002 0.00001 0.001
TOTAL 969647 0.06900 0.00011

Table Statistics (reset: 2024-10-07 13:02:50.021506+00)
SchemaTable #Rows Seq. Readed Tuples Idx. Readed Tuples Sequential Scan Index Scan Insert Update Hot Update Delete Index Usage Ratio% HOT Update Ratio%
public pgbench_accounts 10000035 10000000 242912 2 242912 10000000 121456 35140 0 99 28
public pgbench_branches 100 12146600 0 121466 0 100 121456 120925 0 0 99
public pgbench_tellers 1000 1000 121456 1 121456 1000 121456 120303 0 99 99
public pgbench_history 7113 0 0 0 0 121456 0 0 0 -1 -1

Tables Caching
SchemaTable Heap Reads Index Reads TOAST Reads Heap Hit Ratio% Index Hit Ratio% TOAST Hit Ratio%
public pgbench_accounts 165605 27422 0 92 97 -1
public pgbench_history 1518 0 0 99 -1 -1
public pgbench_tellers 18 13 0 99 99 -1
public pgbench_branches 12 2 0 99 99 -1 

Tables without Unique Indexes

public.pgbench_history


Tables without Primary Key

public.pgbench_history


Index Usage - Details




Defined indexes

SchemaTypeCount  Primary   Unique   Avg #keys   Max #keys 

 public  btree  3  3  3  1.00  1



Constraints


Schema  Primary  Unique  Foreign  Check  Trigger  Exclusion

public 3 0 0 0 0 0



Invalid indexes

Schema Index On Table



Missing indexes(using foreign constraints)

SchemaRelation ContraintIssue Parent Columns
#Table Writes #Table Scan #Parent Scan
Table Size Parent Size



Unused indexes

SchemaTable Index Size



Most used indexes

SchemaTable Index Size Scan Tuples

 public  pgbench_accounts  pgbench_accounts_pkey  224641024  243780  243780

 public  pgbench_tellers  pgbench_tellers_pkey  81920  121890  121890



All indexes

SchemaRelation IndexDDL

 public  pgbench_accounts  pgbench_accounts_pkey  CREATE UNIQUE INDEX pgbench_accounts_pkey ON public.pgbench_accounts USING btree (aid)

 public  pgbench_branches  pgbench_branches_pkey  CREATE UNIQUE INDEX pgbench_branches_pkey ON public.pgbench_branches USING btree (bid)

 public  pgbench_tellers  pgbench_tellers_pkey  CREATE UNIQUE INDEX pgbench_tellers_pkey ON public.pgbench_tellers USING btree (tid)




Partitions


SchemaOwner  Partitioned Object  # Partition  Tuples



Partitioning Details


SchemaOwner  Partitioned Object  Partition  Expression  Tuples

Tuning Parameters (most important ones)
Parameter Value Min Max Unit Context Description Setting Source
autovacuum_vacuum_cost_delay 2 ms -1 100 ms sighup Vacuum cost delay in milliseconds, for autovacuum. 2 default
autovacuum_vacuum_cost_limit -1 -1 10000 sighup Vacuum cost amount available before napping, for autovacuum. -1 default
bgwriter_lru_maxpages 200 0 1073741823 sighup Background writer maximum number of LRU pages to flush per round. 200 configuration file
bgwriter_lru_multiplier 2 0 10 sighup Multiple of the average buffer usage to free per round. 2 default
checkpoint_completion_target 0.9 0 1 sighup Time spent flushing dirty buffers during checkpoint, as fraction of checkpoint interval. 0.9 configuration file
checkpoint_timeout 300 s 30 86400 s sighup Sets the maximum time between automatic WAL checkpoints. 300 default
commit_delay 0 0 100000 superuser Sets the delay in microseconds between transaction commit and flushing WAL to disk. 0 default
commit_siblings 5 0 1000 user Sets the minimum number of concurrent open transactions required before performing commit_delay. 5 default
effective_cache_size 13 GB 1 2147483647 8kB user Sets the planner's assumption about the total size of the data caches. 1638599 configuration file
fsync on sighup Forces synchronization of updates to disk. on default
max_connections 1000 1 262143 postmaster Sets the maximum number of concurrent connections. 1000 configuration file
max_wal_size 1504 MB 2 2147483647 MB sighup Sets the WAL size that triggers a checkpoint. 1504 configuration file
random_page_cost 4 0 1.79769e+308 user Sets the planner's estimate of the cost of a nonsequentially fetched disk page. 4 default
shared_buffers 13 GB 0 1073741823 8kB postmaster Sets the number of shared memory buffers used by the server. 1638400 configuration file
synchronous_commit on user Sets the current transaction's synchronization level. on configuration file
synchronous_standby_names sighup Number of synchronous standbys and list of names of potential synchronous ones. default
temp_buffers 8192 kB 100 1073741823 8kB user Sets the maximum number of temporary buffers used by each session. 1024 default
wal_buffers 32 MB -1 2147483647 8kB postmaster Sets the number of disk-page buffers in shared memory for WAL. 4096 default
wal_writer_delay 200 ms 1 10000 ms sighup Time between WAL flushes performed in the WAL writer. 200 default
work_mem 4096 kB 64 2147483647 kB user Sets the maximum memory to be used for query workspaces. 4096 configuration file

Biggest Objects
Object Type Owner Schema Rows Size (relpages main)Bytes (relation) HR Size (total)
pgbench_accounts Table postgres public 10,000,000 1,342,955,520 1,355,554,816 1509 MB
pgbench_accounts_pkey Index postgres public 10,000,000 224,641,024 224,641,024
pg_proc Table alloydbadmin pg_catalog 3,379 925,696 925,696 1488 kB
pg_attribute Table alloydbadmin pg_catalog 3,376 581,632 581,632 1064 kB
pg_toast_2618 TOAST Table alloydbadmin pg_toast 278 557,056 557,056
pg_description Table alloydbadmin pg_catalog 5,138 368,640 368,640 712 kB
pg_proc_proname_args_nsp_index Index alloydbadmin pg_catalog 3,379 319,488 319,488
pg_rewrite Table alloydbadmin pg_catalog 185 286,720 286,720 1000 kB
pg_description_o_c_o_index Index alloydbadmin pg_catalog 5,138 262,144 262,144
pg_depend_depender_index Index alloydbadmin pg_catalog 2,442 245,760 245,760
pg_statistic Table alloydbadmin pg_catalog 404 212,992 212,992 488 kB
pg_attribute_relid_attnum_index Index alloydbadmin pg_catalog 3,376 196,608 196,608
pg_attribute_relid_attnam_index Index alloydbadmin pg_catalog 3,376 196,608 196,608
pg_depend Table alloydbadmin pg_catalog 2,442 180,224 180,224 672 kB
pg_type Table alloydbadmin pg_catalog 701 155,648 155,648 368 kB
pg_depend_reference_index Index alloydbadmin pg_catalog 2,442 147,456 147,456
pg_class Table alloydbadmin pg_catalog 461 122,880 122,880 352 kB
pg_collation Table alloydbadmin pg_catalog 812 114,688 114,688 272 kB
pg_operator Table alloydbadmin pg_catalog 799 114,688 114,688 264 kB
pg_proc_oid_index Index alloydbadmin pg_catalog 3,379 98,304 98,304
pg_class_relname_nsp_index Index alloydbadmin pg_catalog 461 98,304 98,304
pgbench_tellers_pkey Index postgres public 1,000 81,920 81,920
pgbench_tellers Table postgres public 1,000 81,920 81,920 248 kB
sql_features Table alloydbadmin information_schema 714 65,536 65,536 136 kB
pg_type_oid_index Index alloydbadmin pg_catalog 701 65,536 65,536
pg_statistic_relid_att_inh_index Index alloydbadmin pg_catalog 404 65,536 65,536
pg_amop Table alloydbadmin pg_catalog 945 57,344 57,344 256 kB
pg_type_typname_nsp_index Index alloydbadmin pg_catalog 701 57,344 57,344
pg_amop_opr_fam_index Index alloydbadmin pg_catalog 945 49,152 49,152
pg_amop_fam_strat_index Index alloydbadmin pg_catalog 945 49,152 49,152
pg_collation_name_enc_nsp_index Index alloydbadmin pg_catalog 812 49,152 49,152
pg_operator_oprname_l_r_n_index Index alloydbadmin pg_catalog 799 49,152 49,152

Largest TOASTs
TOAST Owner Table Chunks Bytes
pg_toast_2618 alloydbadmin pg_catalog.pg_rewrite 278 557,056
pg_toast_2619 alloydbadmin pg_catalog.pg_statistic 14 49,152
pg_toast_1255 alloydbadmin pg_catalog.pg_proc 3 8,192

Biggest Partitioned Objects
Object Hierarchy level Partition# HR Size Bytes

Procedural Languages
Available languages
internal
c
sql
plpgsql

PL Objects
Owner Kind Language Count Source size
alloydbadmin Aggregate func. internal 148 2220
alloydbadmin Function c 222 6168
alloydbadmin Function internal 2933 44498
alloydbadmin Function sql 61 502
alloydbadmin Window func. internal 15 278 

Data Types - Details


Tables/Columns


Owner Schema Tables Columns



Data Types


Owner Schema Data type Count

Physical Backup
Parameter Value
archive_mode on
archive_timeout 300
Write xlog location 0/7B484870
Insert xlog location 0/7B4859D8

Archiver Statistics
Archived Count Last Archived WAL Last Archived Time Failed Count Last Failed WAL Last Failed Time Statistics Reset Archiving WALS ps
120 00000001000000000000007A 2024-10-07 15:52:32.720935+00 0 2024-10-07 12:10:55.360272+00 t 0.00894597112875191561

Replication
In Recovery Mode false
Parameter Value
archive_command /bin/true
archive_mode on
hot_standby on
hot_standby_feedback on
ignore_invalid_pages off
max_slot_wal_keep_size 819200
max_standby_archive_delay 30000
max_standby_streaming_delay 30000
max_wal_senders 50
max_wal_size 1504
primary_conninfo
primary_slot_name
recovery_target_timeline latest
synchronous_commit on
synchronous_standby_names
vacuum_defer_cleanup_age 0
wal_keep_size 102400
wal_level replica
wal_receiver_create_temp_slot off

Master Statistics
Client State Sync Current Snapshot Sent loc. Write loc. Flush loc. Replay loc. Backend Start Write lag Flush lag Replay lag

Replication Slots
Name Type Active XMIN Catalog XMIN Restart LSN

Slave Statistics
Last Replication Replication Delay Current Snapshot Receive loc. Replay loc.
03:14:02.465041 0 0/700C570 0/700C570

WAL Receiver
PID Status Connection Latest LSN Latest time

Logical Replication - Subscriptions
Subscription Name Pid Relation OID Received Last Message Send Last Message Receipt Latest location Latest time 

Logical Replication - Details


Publications


Publication Name Owner All tables Insert Update Delete

Publication Name Schema Table



Subscriptions


Subscription Name Database Owner Enabled Sync. Commit  Slot   Connection 

Subscription Name Schema Table State LSN

Extensions
Name Default Version Installed Version Description
google_columnar_engine 1.0 1.0 Google extension for columnar engine
google_db_advisor 1.0 1.0 Google extension for Database Advisor
hypopg 1.3.2 1.3.2 Hypothetical indexes for PostgreSQL
pg_buffercache 1.3 1.3 examine the shared buffer cache
pg_stat_statements 1.10 1.10 track planning and execution statistics of all SQL statements executed
plpgsql 1.0 1.0 PL/pgSQL procedural language
address_standardizer 3.2.5 Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
address_standardizer_data_us 3.2.5 Address Standardizer US dataset example
alloydb_ai_nl 1.0 Google Extension for AlloyDB AI & Natural Language
alloydb_scann 0.1.0 AlloyDB ScaNN Search
amcheck 1.3 functions for verifying relation integrity
anon 1.0.0 Data anonymization tools
autoinc 1.0 functions for autoincrementing fields
bloom 1.0 bloom access method - signature file based index
btree_gin 1.3 support for indexing common datatypes in GIN
btree_gist 1.7 support for indexing common datatypes in GiST
citext 1.6 data type for case-insensitive character strings
cube 1.5 data type for multidimensional cubes
dblink 1.2 connect to other PostgreSQL databases from within a database
dict_int 1.0 text search dictionary template for integers
dict_xsyn 1.0 text search dictionary template for extended synonym processing
earthdistance 1.1 calculate great-circle distances on the surface of the Earth
fuzzystrmatch 1.1 determine similarities and distance between strings
google_ml_integration 1.4.1 Google extension for ML integration
google_plan_management 1.0 Google Extension for Plan Management
hll 2.18 type for storing hyperloglog data
hstore 1.8 data type for storing sets of (key, value) pairs
insert_username 1.0 functions for tracking who changed a table
intagg 1.1 integer aggregator and enumerator (obsolete)
intarray 1.5 functions, operators, and index support for 1-D arrays of integers
ip4r 2.4
isn 1.2 data types for international product numbering standards
lo 1.1 Large Object maintenance
ltree 1.2 data type for hierarchical tree-like structures
moddatetime 1.0 functions for tracking last modification time
oracle_fdw 1.2 foreign data wrapper for Oracle access
orafce 4.7 Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS
pageinspect 1.11 inspect the contents of database pages at a low level
parameterized_views 1.0 Google Extension for Parameterized Views
pg_background 1.2 Run SQL queries in the background
pg_bigm 1.2 text similarity measurement and index searching based on bigrams
pg_cron 1.6.3 Job scheduler for PostgreSQL
pg_freespacemap 1.2 examine the free space map (FSM)
pg_hint_plan 1.5
pg_partman 4.7.4 Extension to manage partitioned tables by time or ID
pg_prewarm 1.2 prewarm relation data
pg_proctab 0.0.10 Access operating system process table
pg_repack 1.5.0 Reorganize tables in PostgreSQL databases with minimal locks
pg_similarity 1.0 support similarity queries
pg_squeeze 1.5 A tool to remove unused space from a relation.
pg_trgm 1.6 text similarity measurement and index searching based on trigrams
pg_visibility 1.2 examine the visibility map (VM) and page-level visibility info
pg_wait_sampling 1.1 sampling based statistics of wait events
pgaudit 1.7 provides auditing functionality
pgcrypto 1.3 cryptographic functions
pgfincore 1.3.1 examine and manage the os buffer cache
pglogical 2.4.3 PostgreSQL Logical Replication
pgrouting 3.6.2 pgRouting Extension
pgrowlocks 1.2 show row-level locking information
pgstattuple 1.5 show tuple-level statistics
pgtap 1.3.0 Unit testing for PostgreSQL
pgtt 3.0.0 Extension to add Global Temporary Tables feature to PostgreSQL
plproxy 2.11.0 Database partitioning implemented as procedural language
plv8 3.2.2 PL/JavaScript (v8) trusted procedural language
postgis 3.2.5 PostGIS geometry and geography spatial types and functions
postgis_raster 3.2.5 PostGIS raster types and functions
postgis_sfcgal 3.2.5 PostGIS SFCGAL functions
postgis_tiger_geocoder 3.2.5 PostGIS tiger geocoder and reverse geocoder
postgis_topology 3.2.5 PostGIS topology spatial types and functions
postgres_fdw 1.1 foreign-data wrapper for remote PostgreSQL servers
prefix 1.2.0 Prefix Range module for PostgreSQL
rdkit 4.3.0 Cheminformatics functionality for PostgreSQL.
refint 1.0 functions for implementing referential integrity (obsolete)
sslinfo 1.2 information about SSL certificates
tablefunc 1.0 functions that manipulate whole tables, including crosstab
tcn 1.0 Triggered change notifications
temporal_tables 1.2.2 temporal tables
tsm_system_rows 1.0 TABLESAMPLE method which accepts number of rows as a limit
tsm_system_time 1.0 TABLESAMPLE method which accepts time in milliseconds as a limit
unaccent 1.1 text search dictionary that removes accents
uuid-ossp 1.1 generate universally unique identifiers (UUIDs)
vector 0.7.2.google-1 vector data type and ivfflat and hnsw access methods

NLS Settings
Parameter Value Description
lc_collate C Shows the collation order locale.
lc_ctype C Shows the character classification and case conversion locale.
lc_messages en_US.UTF8 Sets the language in which messages are displayed.
lc_monetary en_US.UTF8 Sets the locale for formatting monetary amounts.
lc_numeric en_US.UTF8 Sets the locale for formatting numbers.
lc_time en_US.UTF8 Sets the locale for formatting date and time values.
OID Database Collate
16384 alloydbadmin C
4 template0 C
5 postgres C
1 template1 C
16414 alloydbmetadata C
27779 pgbench C 

Columns with non default collation


Schema Table Column Collate

public  hypopg_list_indexes  schema_name  C

public  hypopg_list_indexes  table_name  C

public  hypopg_list_indexes  am_name  C

Configured Parameters
Parameter Value Description Source Setting
archive_command /bin/true Sets the shell command that will be called to archive a WAL file. configuration file /bin/true
archive_mode on Allows archiving of WAL files using archive_command. configuration file on
archive_timeout 300 s Sets the amount of time to wait before forcing a switch to the next WAL file. configuration file 300
bgwriter_delay 50 ms Background writer sleep time between rounds. configuration file 50
bgwriter_lru_maxpages 200 Background writer maximum number of LRU pages to flush per round. configuration file 200
checkpoint_completion_target 0.9 Time spent flushing dirty buffers during checkpoint, as fraction of checkpoint interval. configuration file 0.9
DateStyle ISO, MDY Sets the display format for date and time values. configuration file ISO, MDY
default_text_search_config pg_catalog.english Sets default text search configuration. configuration file pg_catalog.english
dynamic_shared_memory_type posix Selects the dynamic shared memory implementation used. configuration file posix
effective_cache_size 13 GB Sets the planner's assumption about the total size of the data caches. configuration file 1638599
full_page_writes off Writes full pages to WAL when first modified after a checkpoint. command line off
google_columnar_engine.memory_size_in_mb 4800 Sets the size (in MB) of the shared memory for columnar engine. configuration file 4800
google_insights.enabled on Sets whether to enable the extension. configuration file on
google_insights.num_query_plans_per_minute 5 Sets the number of execution plans to sample per minute for all connections. configuration file 5
google_insights.track on Sets whether to enable stats tracking, which can be set on the fly to disable the code path. configuration file on
google_insights.track_client_address off Sets whether to track client addresses in statistic tables. When they are tracked, the same statement executed by clients from different addresses produces different records. configuration file off
google_insights.track_comment off Sets whether to enable stats recording for tags table. configuration file off
hot_standby on Allows connections and queries during recovery. configuration file on
hot_standby_feedback on Allows feedback from a hot standby to the primary that will avoid query conflicts. configuration file on
huge_pages on Use of huge pages on Linux or Windows. configuration file on
lc_messages en_US.UTF8 Sets the language in which messages are displayed. configuration file en_US.UTF8
lc_monetary en_US.UTF8 Sets the locale for formatting monetary amounts. configuration file en_US.UTF8
lc_numeric en_US.UTF8 Sets the locale for formatting numbers. configuration file en_US.UTF8
lc_time en_US.UTF8 Sets the locale for formatting date and time values. configuration file en_US.UTF8
listen_addresses * Sets the host name or IP address(es) to listen to. command line *
log_autovacuum_min_duration 0 ms Sets the minimum execution time above which autovacuum actions will be logged. configuration file 0
log_directory log Sets the destination directory for log files. configuration file log
log_filename postgres Sets the file name pattern for log files. configuration file postgres
log_line_prefix %m [%p]: [%l-1] db=%d,user=%u Controls information prefixed to each log line. configuration file %m [%p]: [%l-1] db=%d,user=%u
log_rotation_age 0 min Sets the amount of time to wait before forcing log file rotation. configuration file 0
log_rotation_size 0 bytes Sets the maximum size a log file can reach before being rotated. configuration file 0
log_temp_files 0 bytes Log the use of temporary files larger than this number of kilobytes. configuration file 0
log_timezone UTC Sets the time zone to use in log messages. configuration file UTC
max_connections 1000 Sets the maximum number of concurrent connections. configuration file 1000
max_locks_per_transaction 64 Sets the maximum number of locks per transaction. configuration file 64
max_parallel_workers 8 Sets the maximum number of parallel workers that can be active at one time. configuration file 8
max_parallel_workers_per_gather 2 Sets the maximum number of parallel processes per executor node. configuration file 2
max_prepared_transactions 0 Sets the maximum number of simultaneously prepared transactions. configuration file 0
max_replication_slots 50 Sets the maximum number of simultaneously defined replication slots. configuration file 50
max_slot_wal_keep_size 800 GB Sets the maximum WAL size that can be reserved by replication slots. configuration file 819200
max_wal_senders 50 Sets the maximum number of simultaneously running WAL sender processes. configuration file 50
max_wal_size 1504 MB Sets the WAL size that triggers a checkpoint. configuration file 1504
max_worker_processes 64 Maximum number of concurrent worker processes. configuration file 64
password.enforce_complexity on Sets whether to enable password complexity. configuration file on
port 5432 Sets the TCP port the server listens on. command line 5432
recovery_target_timeline latest Specifies the timeline to recover into. configuration file latest
restore_command cp "/mnt/disks/pgsql/data/pg_remote_wal/%f" "%p" Sets the shell command that will be called to retrieve an archived WAL file. configuration file cp "/mnt/disks/pgsql/data/pg_remote_wal/%f" "%p"
shared_buffers 13 GB Sets the number of shared memory buffers used by the server. configuration file 1638400
shared_preload_libraries alloydb_password_validation,alloydb_scann,g_stat_activity,g_stats,google_columnar_engine,google_db_advisor,google_insights,google_job_scheduler,google_stats_collection,google_storage,pg_stat_statements,vector Lists shared libraries to preload into server. configuration file alloydb_password_validation,alloydb_scann,g_stat_activity,g_stats,google_columnar_engine,google_db_advisor,google_insights,google_job_scheduler,google_stats_collection,google_storage,pg_stat_statements,vector
ssl on Enables SSL connections. configuration file on
ssl_cert_file /mnt/stateful_partition/cert/server/cert.pem Location of the SSL server certificate file. configuration file /mnt/stateful_partition/cert/server/cert.pem
ssl_key_file /mnt/stateful_partition/cert/server/key.pem Location of the SSL server private key file. configuration file /mnt/stateful_partition/cert/server/key.pem
synchronous_commit on Sets the current transaction's synchronization level. configuration file on
TimeZone UTC Sets the time zone for displaying and interpreting time stamps. configuration file UTC
track_io_timing on Collects timing statistics for database I/O activity. configuration file on
track_lockwait_timing on Collects timing statistics for lock wait events. configuration file on
track_misc_time on Collects timing statistics for miscellaneous activity other than wait events. configuration file on
track_wait_histogram on Collects wait histogram information. configuration file on
track_wait_time on Collects timing statistics for wait events. configuration file on
unix_socket_directories /mnt/disks/pgsql Sets the directories where Unix-domain sockets will be created. command line /mnt/disks/pgsql
wal_init_zero off Writes zeroes to new WAL files before first use. configuration file off
wal_keep_size 100 GB Sets the size of WAL files held for standby servers. configuration file 102400
wal_level replica Sets the level of information written to the WAL. configuration file replica
work_mem 4096 kB Sets the maximum memory to be used for query workspaces. configuration file 4096

PostgreSQL Parameters (all)
Parameter Value Min Max Description Category Context Unit Source Setting
add_partial_paths_with_sort_node on Adds partial paths with sort nodes on top of cheapest_partial_path (by total_cost) for each useful pathkey. Google AlloyDB Options user default on
allow_in_place_tablespaces off Allows tablespaces directly inside pg_tblspc, for testing. Developer Options superuser default off
allow_system_table_mods off Allows modifications of the structure of system tables. Developer Options superuser default off
alloydb.audit_log_line_prefix %m [%p]: [%l-1] db=%d,user=%u Controls information prefixed to each audit log line. Reporting and Logging / What to Log sighup default %m [%p]: [%l-1] db=%d,user=%u
alloydb.enable_anon off Enable postgresql_anonymizer extension to mask or replace PII or sensitive data from a database. Ungrouped superuser default off
alloydb.enable_auto_explain off Enable auto_explain extension for logging execution plans. Reporting and Logging / What to Log postmaster default off
alloydb.enable_pg_bigm off Enable pg_bigm extension to provide full text search capability. Ungrouped superuser default off
alloydb.enable_pg_cron off Enable pg_cron extension to run periodic jobs. Ungrouped superuser default off
alloydb.enable_pg_hint_plan off Enable pg_hint_plan extension to control execution plans. Ungrouped superuser default off
alloydb.enable_pg_squeeze off Enable pg_squeeze extension that removes unused space from a table and optionally sort tuples according to particular index Ungrouped superuser default off
alloydb.enable_pg_wait_sampling off Enable pg_wait_sampling extension to collect sampling-based statistics of wait events. Reporting and Logging / What to Log postmaster default off
alloydb.enable_pgaudit off Start a subprocess to enable and capture audit logs into log files. Reporting and Logging / Where to Log postmaster default off
alloydb.extension_maintenance off Enable maintenance of extensions Ungrouped superuser default off
alloydb.fs_access off Allow file system access Ungrouped postmaster default off
alloydb.log_throttling_window 0 s 0 2147483647 Sets the time window between logging of identical log message again. Reporting and Logging / When to Log user s default 0
alloydb.logical_decoding off Ensure enough information is written to the WAL to support PostgreSQL logical decoding features. Write-Ahead Log / Settings postmaster default off
alloydb.max_parallel_worker_threads 1 -1 2147483647 Maximum number of concurrent worker threads. Google AlloyDB Options postmaster default 1
alloydb.pg_authid_select_role Role to allow SELECT of the pg_authid table. Developer Options superuser default
alloydb.pg_shadow_select_role Role to allow SELECT of the pg_shadow view. Developer Options superuser default
alloydbg.coredump_at_location file_name:XX Set at which location should result in a coredump. Developer Options user default file_name:XX
alloydbg.coredump_on_error XXXXX Set at which error code should result in a coredump. Developer Options user default XXXXX
alloydbg.enable_coredump_on_PANIC off Sets whether a PANIC level error should produce a coredump. Developer Options user default off
application_name psql Sets the application name to be reported in statistics and logs. Reporting and Logging / What to Log user client psql
archive_cleanup_command Sets the shell command that will be executed at every restart point. Write-Ahead Log / Archive Recovery sighup default
archive_command /bin/true Sets the shell command that will be called to archive a WAL file. Write-Ahead Log / Archiving sighup configuration file /bin/true
archive_library Sets the library that will be called to archive a WAL file. Write-Ahead Log / Archiving sighup default
archive_mode on Allows archiving of WAL files using archive_command. Write-Ahead Log / Archiving postmaster configuration file on
archive_timeout 300 s 0 1073741823 Sets the amount of time to wait before forcing a switch to the next WAL file. Write-Ahead Log / Archiving sighup s configuration file 300
array_nulls on Enable input of NULL elements in arrays. Version and Platform Compatibility / Previous PostgreSQL Versions user default on
authentication_timeout 60 s 1 600 Sets the maximum allowed time to complete client authentication. Connections and Authentication / Authentication sighup s default 60
autovacuum on Starts the autovacuum subprocess. Autovacuum sighup default on
autovacuum_analyze_scale_factor 0.1 0 100 Number of tuple inserts, updates, or deletes prior to analyze as a fraction of reltuples. Autovacuum sighup default 0.1
autovacuum_analyze_threshold 50 0 2147483647 Minimum number of tuple inserts, updates, or deletes prior to analyze. Autovacuum sighup default 50
autovacuum_freeze_max_age 200000000 100000 2000000000 Age at which to autovacuum a table to prevent transaction ID wraparound. Autovacuum postmaster default 200000000
autovacuum_max_workers 3 1 262143 Sets the maximum number of simultaneously running autovacuum worker processes. Autovacuum postmaster default 3
autovacuum_multixact_freeze_max_age 400000000 10000 2000000000 Multixact age at which to autovacuum a table to prevent multixact wraparound. Autovacuum postmaster default 400000000
autovacuum_naptime 60 s 1 2147483 Time to sleep between autovacuum runs. Autovacuum sighup s default 60
autovacuum_vacuum_cost_delay 2 ms -1 100 Vacuum cost delay in milliseconds, for autovacuum. Autovacuum sighup ms default 2
autovacuum_vacuum_cost_limit -1 -1 10000 Vacuum cost amount available before napping, for autovacuum. Autovacuum sighup default -1
autovacuum_vacuum_insert_scale_factor 0.2 0 100 Number of tuple inserts prior to vacuum as a fraction of reltuples. Autovacuum sighup default 0.2
autovacuum_vacuum_insert_threshold 1000 -1 2147483647 Minimum number of tuple inserts prior to vacuum, or -1 to disable insert vacuums. Autovacuum sighup default 1000
autovacuum_vacuum_scale_factor 0.2 0 100 Number of tuple updates or deletes prior to vacuum as a fraction of reltuples. Autovacuum sighup default 0.2
autovacuum_vacuum_threshold 50 0 2147483647 Minimum number of tuple updates or deletes prior to vacuum. Autovacuum sighup default 50
autovacuum_work_mem -1024 bytes -1 2147483647 Sets the maximum memory to be used by each autovacuum worker process. Resource Usage / Memory sighup kB default -1
backend_flush_after 0 bytes 0 256 Number of pages after which previously performed writes are flushed to disk. Resource Usage / Asynchronous Behavior user 8kB default 0
backslash_quote safe_encoding Sets whether "\'" is allowed in string literals. Version and Platform Compatibility / Previous PostgreSQL Versions user default safe_encoding
backtrace_functions Log backtrace for errors in these functions. Developer Options superuser default
bgwriter_delay 50 ms 10 10000 Background writer sleep time between rounds. Resource Usage / Background Writer sighup ms configuration file 50
bgwriter_flush_after 512 kB 0 256 Number of pages after which previously performed writes are flushed to disk. Resource Usage / Background Writer sighup 8kB default 64
bgwriter_lru_maxpages 200 0 1073741823 Background writer maximum number of LRU pages to flush per round. Resource Usage / Background Writer sighup configuration file 200
bgwriter_lru_multiplier 2 0 10 Multiple of the average buffer usage to free per round. Resource Usage / Background Writer sighup default 2
block_size 8192 8192 8192 Shows the size of a disk block. Preset Options internal default 8192
bonjour off Enables advertising the server via Bonjour. Connections and Authentication / Connection Settings postmaster default off
bonjour_name Sets the Bonjour service name. Connections and Authentication / Connection Settings postmaster default
bytea_output hex Sets the output format for bytea. Client Connection Defaults / Statement Behavior user default hex
check_function_bodies on Check routine bodies during CREATE FUNCTION and CREATE PROCEDURE. Client Connection Defaults / Statement Behavior user default on
checkpoint_completion_target 0.9 0 1 Time spent flushing dirty buffers during checkpoint, as fraction of checkpoint interval. Write-Ahead Log / Checkpoints sighup configuration file 0.9
checkpoint_flush_after 256 kB 0 256 Number of pages after which previously performed writes are flushed to disk. Write-Ahead Log / Checkpoints sighup 8kB default 32
checkpoint_timeout 300 s 30 86400 Sets the maximum time between automatic WAL checkpoints. Write-Ahead Log / Checkpoints sighup s default 300
checkpoint_warning 30 s 0 2147483647 Sets the maximum time before warning if checkpoints triggered by WAL volume happen too frequently. Write-Ahead Log / Checkpoints sighup s default 30
client_connection_check_interval 0 ms 0 2147483647 Sets the time interval between checks for disconnection while running queries. Connections and Authentication / Connection Settings user ms default 0
client_encoding UTF8 Sets the client's character set encoding. Client Connection Defaults / Locale and Formatting user client UTF8
client_min_messages notice Sets the message levels that are sent to the client. Client Connection Defaults / Statement Behavior user default notice
cluster_name Sets the name of the cluster, which is included in the process title. Reporting and Logging / Process Title postmaster default
commit_delay 0 0 100000 Sets the delay in microseconds between transaction commit and flushing WAL to disk. Write-Ahead Log / Settings superuser default 0
commit_siblings 5 0 1000 Sets the minimum number of concurrent open transactions required before performing commit_delay. Write-Ahead Log / Settings user default 5
compute_query_id auto Enables in-core computation of query identifiers. Statistics / Monitoring superuser default auto
config_file /mnt/disks/pgsql/data/postgresql.conf Sets the server's main configuration file. File Locations postmaster override /mnt/disks/pgsql/data/postgresql.conf
consider_partial_path_startup_cost on Whether to consider startup cost of partial paths. Google AlloyDB Options user default on
constraint_exclusion partition Enables the planner to use constraints to optimize queries. Query Tuning / Other Planner Options user default partition
cpu_index_tuple_cost 0.005 0 1.79769e+308 Sets the planner's estimate of the cost of processing each index entry during an index scan. Query Tuning / Planner Cost Constants user default 0.005
cpu_operator_cost 0.0025 0 1.79769e+308 Sets the planner's estimate of the cost of processing each operator or function call. Query Tuning / Planner Cost Constants user default 0.0025
cpu_tuple_cost 0.01 0 1.79769e+308 Sets the planner's estimate of the cost of processing each tuple (row). Query Tuning / Planner Cost Constants user default 0.01
cursor_tuple_fraction 0.1 0 1 Sets the planner's estimate of the fraction of a cursor's rows that will be retrieved. Query Tuning / Other Planner Options user default 0.1
data_checksums off Shows whether data checksums are turned on for this cluster. Preset Options internal default off
data_directory /mnt/disks/pgsql/data Sets the server's data directory. File Locations postmaster override /mnt/disks/pgsql/data
data_directory_mode 0700 0 511 Shows the mode of the data directory. Preset Options internal default 0700
data_sync_retry off Whether to continue running after a failure to sync data files. Error Handling postmaster default off
DateStyle ISO, MDY Sets the display format for date and time values. Client Connection Defaults / Locale and Formatting user configuration file ISO, MDY
db_user_namespace off Enables per-database user names. Connections and Authentication / Authentication sighup default off
deadlock_timeout 1000 ms 1 2147483647 Sets the time to wait on a lock before checking for deadlock. Lock Management superuser ms default 1000
debug_assertions off Shows whether the running server has assertion checks enabled. Preset Options internal default off
debug_discard_caches 0 0 0 Aggressively flush system caches for debugging purposes. Developer Options superuser default 0
debug_materialized_view_rewrite off Debugs materialized view rewrite. Query Tuning / Planner Method Configuration user default off
debug_pretty_print on Indents parse and plan tree displays. Reporting and Logging / What to Log user default on
debug_print_parse off Logs each query's parse tree. Reporting and Logging / What to Log user default off
debug_print_plan off Logs each query's execution plan. Reporting and Logging / What to Log user default off
debug_print_rewritten off Logs each query's rewritten parse tree. Reporting and Logging / What to Log user default off
default_statistics_target 100 1 10000 Sets the default statistics target. Query Tuning / Other Planner Options user default 100
default_table_access_method heap Sets the default table access method for new tables. Client Connection Defaults / Statement Behavior user default heap
default_tablespace Sets the default tablespace to create tables and indexes in. Client Connection Defaults / Statement Behavior user default
default_text_search_config pg_catalog.english Sets default text search configuration. Client Connection Defaults / Locale and Formatting user configuration file pg_catalog.english
default_toast_compression pglz Sets the default compression method for compressible values. Client Connection Defaults / Statement Behavior user default pglz
default_transaction_deferrable off Sets the default deferrable status of new transactions. Client Connection Defaults / Statement Behavior user default off
default_transaction_isolation read committed Sets the transaction isolation level of each new transaction. Client Connection Defaults / Statement Behavior user default read committed
default_transaction_read_only off Sets the default read-only status of new transactions. Client Connection Defaults / Statement Behavior user default off
diskless_replication_validation on When flag enable_diskless_replication is on, walsender reads from WAL buffer and WAL physical files and compares its output. It prints a warning message if they don't match. Google AlloyDB Options postmaster default on
diskless_replication_validation_panic off When flag enable_diskless_replication is on, walsender reads from WAL buffer and WAL physical files and compares its output. It panics if they don't match. Google AlloyDB Options postmaster default off
drop_cache_timeout_ms 15000 0 600000 Timeout to wait for drop cache request to complete. Google AlloyDB Options sighup default 15000
dynamic_library_path $libdir Sets the path for dynamically loadable modules. Client Connection Defaults / Other Defaults superuser default $libdir
dynamic_shared_memory_max_socket_backlog 10 -1 2147483647 The socket backlog limit to pause dynamic shared memory adjustment. Google AlloyDB Options sighup default 10
dynamic_shared_memory_type posix Selects the dynamic shared memory implementation used. Resource Usage / Memory postmaster configuration file posix
effective_cache_size 13 GB 1 2147483647 Sets the planner's assumption about the total size of the data caches. Query Tuning / Planner Cost Constants user 8kB configuration file 1638599
effective_io_concurrency 128 0 1000 Number of simultaneous requests that can be handled efficiently by the disk subsystem. Resource Usage / Asynchronous Behavior user default 128
enable_async_append on Enables the planner's use of async append plans. Query Tuning / Planner Method Configuration user default on
enable_bitmapscan on Enables the planner's use of bitmap-scan plans. Query Tuning / Planner Method Configuration user default on
enable_debugging_for_local_unlogged_tables off When on, we will use LOG_SERVER_ONLY for any debug messages involving unlogged tables. Google AlloyDB Options postmaster default off
enable_diskless_replication on walsender uses the WAL buffer before trying WAL files when reading WAL entries for replication. Google AlloyDB Options postmaster default on
enable_gathermerge on Enables the planner's use of gather merge plans. Query Tuning / Planner Method Configuration user default on
enable_google_adaptive_autovacuum on Enable google adaptive autovacuum. Google AlloyDB Options sighup default on
enable_google_adaptive_autovacuum_delay_by_system_usage on Enable google adaptive autovacuum delay by real time system usage. Google AlloyDB Options sighup default on
enable_hashagg on Enables the planner's use of hashed aggregation plans. Query Tuning / Planner Method Configuration user default on
enable_hashjoin on Enables the planner's use of hash join plans. Query Tuning / Planner Method Configuration user default on
enable_incremental_sort on Enables the planner's use of incremental sort steps. Query Tuning / Planner Method Configuration user default on
enable_indexonlyscan on Enables the planner's use of index-only-scan plans. Query Tuning / Planner Method Configuration user default on
enable_indexscan on Enables the planner's use of index-scan plans. Query Tuning / Planner Method Configuration user default on
enable_material on Enables the planner's use of materialization. Query Tuning / Planner Method Configuration user default on
enable_materialized_view_rewrite off Enables materialized view rewrite. Query Tuning / Planner Method Configuration user default off
enable_memoize on Enables the planner's use of memoization. Query Tuning / Planner Method Configuration user default on
enable_mergejoin on Enables the planner's use of merge join plans. Query Tuning / Planner Method Configuration user default on
enable_nestloop on Enables the planner's use of nested-loop join plans. Query Tuning / Planner Method Configuration user default on
enable_parallel_append on Enables the planner's use of parallel append plans. Query Tuning / Planner Method Configuration user default on
enable_parallel_hash on Enables the planner's use of parallel hash plans. Query Tuning / Planner Method Configuration user default on
enable_parallel_select_for_insert_select on Enables parallel select for insert into select statement. Query Tuning / Planner Method Configuration user default on
enable_partition_pruning on Enables plan-time and execution-time partition pruning. Query Tuning / Planner Method Configuration user default on
enable_partitionwise_aggregate off Enables partitionwise aggregation and grouping. Query Tuning / Planner Method Configuration user default off
enable_partitionwise_join off Enables partitionwise join. Query Tuning / Planner Method Configuration user default off
enable_RI_based_join_elimination on If enabled, enable RI based join elimination Google AlloyDB Options user default on
enable_seqscan on Enables the planner's use of sequential-scan plans. Query Tuning / Planner Method Configuration user default on
enable_sort on Enables the planner's use of explicit sort steps. Query Tuning / Planner Method Configuration user default on
enable_tidscan on Enables the planner's use of TID scan plans. Query Tuning / Planner Method Configuration user default on
enable_unnesting_correlated_any_subquery off Enables unnesting correlated ANY subquery. Query Tuning / Planner Method Configuration user default off
escape_string_warning on Warn about backslash escapes in ordinary string literals. Version and Platform Compatibility / Previous PostgreSQL Versions user default on
event_source PostgreSQL Sets the application name used to identify PostgreSQL messages in the event log. Reporting and Logging / Where to Log postmaster default PostgreSQL
exit_on_error off Terminate session on any error. Error Handling user default off
external_pid_file Writes the postmaster PID to the specified file. File Locations postmaster default
extra_float_digits 1 -15 3 Sets the number of digits displayed for floating-point values. Client Connection Defaults / Locale and Formatting user default 1
force_parallel_mode off Forces use of parallel query facilities. Developer Options user default off
from_collapse_limit 8 1 2147483647 Sets the FROM-list size beyond which subqueries are not collapsed. Query Tuning / Other Planner Options user default 8
fsync on Forces synchronization of updates to disk. Write-Ahead Log / Settings sighup default on
full_page_writes off Writes full pages to WAL when first modified after a checkpoint. Write-Ahead Log / Settings sighup command line off
g_stat_activity.constraints_enabled off Enable/disabled foreign key constraints for tables in g_activity Customized Options postmaster default off
g_stat_activity.query_level_track top Selects which statements are tracked. Customized Options superuser default top
g_stat_activity.track_alloydb_agent on Enable/disabled tracking alloydb agent stats Customized Options superuser default on
g_stat_activity.track_enabled off Enable/disabled tracking stats in general Customized Options superuser default off
g_stat_activity.track_normalized_query off Enable/disabled tracking normalized query Customized Options superuser default off
g_stat_activity.track_plan off Enable/disabled tracking plan Customized Options superuser default off
g_stat_activity.track_plan_node off Enable/disabled tracking plan node Customized Options superuser default off
g_stat_activity.track_planning off Enable/disabled tracking planning. Customized Options superuser default off
g_stat_activity.track_query_node off Enable/disabled tracking query instance node Customized Options superuser default off
g_stat_activity.track_raw_plan off Enable/disabled tracking raw plan Customized Options superuser default off
g_stat_activity.track_transaction on Enable/disabled tracking transaction Customized Options superuser default on
g_stat_activity.track_utility off Enable/disabled tracking utility commands. Customized Options superuser default off
geqo on Enables genetic query optimization. Query Tuning / Genetic Query Optimizer user default on
geqo_effort 5 1 10 GEQO: effort is used to set the default for other GEQO parameters. Query Tuning / Genetic Query Optimizer user default 5
geqo_generations 0 0 2147483647 GEQO: number of iterations of the algorithm. Query Tuning / Genetic Query Optimizer user default 0
geqo_pool_size 0 0 2147483647 GEQO: number of individuals in the population. Query Tuning / Genetic Query Optimizer user default 0
geqo_seed 0 0 1 GEQO: seed for random path selection. Query Tuning / Genetic Query Optimizer user default 0
geqo_selection_bias 2 1.5 2 GEQO: selective pressure within the population. Query Tuning / Genetic Query Optimizer user default 2
geqo_threshold 12 2 2147483647 Sets the threshold of FROM items beyond which GEQO is used. Query Tuning / Genetic Query Optimizer user default 12
gin_fuzzy_search_limit 0 0 2147483647 Sets the maximum allowed result for exact search by GIN. Client Connection Defaults / Other Defaults user default 0
gin_pending_list_limit 4096 kB 64 2147483647 Sets the maximum size of the pending list for GIN index. Client Connection Defaults / Statement Behavior user kB default 4096
google_auto_hints.enabled off Enable google auto_hints. Google AlloyDB Options postmaster default off
google_columnar_engine.adaptive_auto_refresh_schedule The schedule for adaptive auto refresh Customized Options sighup default
google_columnar_engine.auto_columnarization_schedule The schedule for auto columnarization Customized Options sighup default
google_columnar_engine.columnar_hash_joins_cost_factor 100 1 10000 Factor by which cost of disfavored paths will be multiplied by, when google_columnar_engine.force_group_columnar_hash_joins is enabled. Google AlloyDB Options user default 100
google_columnar_engine.enable_aggregate_distinct_in_aggregate_pushdown off Indicates whether to do SELECT AggFunc(DISTINCT) optimizations in aggregate pushdown. Customized Options user default off
google_columnar_engine.enable_auto_columnarization on Enable auto columnarization Customized Options sighup default on
google_columnar_engine.enable_auto_columnarization_local_storage_spill off Enable auto columnarization with local storage spill Customized Options sighup default off
google_columnar_engine.enable_auto_cu_selection off Indicates whether auto CU selection is enabled. Customized Options user default off
google_columnar_engine.enable_columnar_scan on Sets whether to enable columnar scan (for session). Customized Options user default on
google_columnar_engine.enable_hashed_inlist off Indicates whether hashed INLISTs are enabled. Customized Options user default off
google_columnar_engine.enable_materialized_view on Indicates whether materialized view can be loaded into columnar engine. Customized Options user default on
google_columnar_engine.enable_select_distinct_in_aggregate_pushdown on Indicates whether to do SELECT DISTINCT optimizations in aggregate pushdown. Customized Options user default on
google_columnar_engine.enable_timestamptz_date on Sets whether to enable columnar scan for timestamptz_date Customized Options user default on
google_columnar_engine.enable_vectorized_join off Sets whether to enable joins using vectorized method Customized Options user default off
google_columnar_engine.enable_vectorized_join_on_storage off Sets whether to enable vectorized joins if the columns are in storage Customized Options user default off
google_columnar_engine.enabled off Enable google columnar engine. Google AlloyDB Options postmaster default off
google_columnar_engine.enforce_new_defaults off Enforce new defaults for columnar engine. Google AlloyDB Options postmaster default off
google_columnar_engine.heap_fragmentation_max_percentage 1 0 100 Expected fragmentation in the heap Customized Options sighup default 1
google_columnar_engine.ipc_reduction_ratio_for_vec_join 0.8 0.1 1 Sets the planner's ipc cost reduction ratio for vectorized join Query Tuning / Planner Cost Constants user default 0.8
google_columnar_engine.memory_size_in_mb 4800 128 2147483647 Sets the size (in MB) of the shared memory for columnar engine. Google AlloyDB Options postmaster configuration file 4800
google_columnar_engine.parallel_distinct_aggregate_pushdown_threshold 1 0 100 Threshold for doing parallel SELECT AggFunc(DISTINCT) optimizations. Customized Options user default 1
google_columnar_engine.populate_detoasted_max_bytes 64 16 2147483647 Column values are stored detoasted up to given max bytes per column Customized Options sighup default 64
google_columnar_engine.refresh_threshold_percentage 50 -1 100 Threshold on invalid blocks percentage for refreshing the columnar unit Customized Options sighup default 50
google_columnar_engine.refresh_threshold_scan_count 5 0 2147483647 Threshold on scan count without interleaving DMLs for refreshing the columnar unit Customized Options sighup default 5
google_columnar_engine.refresh_threshold_scan_count_by_costing 20 0 2147483647 Threshold on scan count without interleaving DMLs for refreshing the columnar unit Customized Options sighup default 20
google_columnar_engine.relations Tables which need to be present in the columnar cache. Customized Options sighup default
google_columnar_engine.scan_mode 0 0 2 Scan Mode (0:Voxel, 1:Native, 2:RowStore) Customized Options user default 0
google_columnar_engine.vacuum_materialized_view_before_population on Vacuum materialized view before repopulate on primary if the mv is in columnar engine. Customized Options user default on
google_db_advisor.auto_advisor_max_time_in_seconds_per_day 1800 0 86400 The maximum amount of time in seconds auto advisor spends per day. Customized Options sighup default 1800
google_db_advisor.auto_advisor_schedule The schedule to run database advisor automatically Customized Options sighup default
google_db_advisor.auto_ce_cpu_available_min_threshold -1 -1 100 The minimum available CPU percentage to enable CE by default. Customized Options sighup default -1
google_db_advisor.auto_ce_enabled off Sets whether to enable auto CE. Customized Options sighup default off
google_db_advisor.auto_ce_max_ce_memory_percent -1 -1 100 The maximum percent of DRAM allocated to columnar engine when CE is enabled by default. Customized Options sighup default -1
google_db_advisor.auto_ce_max_ce_ssd_percent -1 -1 100 The maximum percentage of SSD allocated to columnar engine when CE is enabled by default. Customized Options sighup default -1
google_db_advisor.auto_ce_memory_available_min_threshold -1 -1 100 The minimum available memory percentage to enable CE by default. Customized Options sighup default -1
google_db_advisor.auto_ce_ssd_available_min_threshold -1 -1 100 The minimum available SSD percentage to enable CE by default. Customized Options sighup default -1
google_db_advisor.enable_auto_advisor on Sets whether to enable running database advisor automatically based on the schedule specified by google_db_advisor.auto_advisor_schedule. Customized Options sighup default on
google_db_advisor.enabled on Enable google db advisor. Google AlloyDB Options sighup default on
google_db_advisor.max_index_width 2 1 2147483647 Index advisor will recommend indexes that contain at most the specified number of columns. Customized Options user default 2
google_db_advisor.max_num_indexable_columns 1000 1 2147483647 The maximum number of indexable columns that index advisor will consider to recommend indexes. Customized Options user default 1000
google_db_advisor.max_statement_length 102400 0 2147483647 The maximum length of a statement that is captured. Customized Options user default 102400
google_db_advisor.max_storage_size_in_mb 0 0 2147483647 Index advisor will recommend indexes with their total size less than the specified max storage size. Customized Options user default 0
google_db_advisor.recommend_indexes_on_partitions off Sets whether to enable recommending indexes on individual table partitions. Customized Options user default off
google_db_advisor.recommendation_max_time_in_seconds 600 0 2147483647 The maximum time in seconds to recommend indexes for a database. Customized Options user default 600
google_db_advisor.top_k_slowest_statements 100 1 2147483647 Index advisor will recommend indexes for the top-K slowest statements. Customized Options user default 100
google_db_advisor.workload_advisory_max_file_size 1048576 0 2147483647 The maximum file size in bytes for the workload advisory file. Customized Options sighup default 1048576
google_insights.allocate_memory on Sets whether to allcoate memory for the extension. Customized Options postmaster default on
google_insights.allocate_memory_active_queries off Sets whether to allocate memory for active query data. Customized Options postmaster default off
google_insights.enabled on Sets whether to enable the extension. Customized Options superuser configuration file on
google_insights.max_active_query_entry_read_attempt 256 0 4096 Sets the maximum number of attempts to read active query backend entry. Customized Options superuser default 256
google_insights.max_active_query_length 127 63 4095 Sets the maximum size of active query string length. Customized Options postmaster default 127
google_insights.max_aggregated_stats_entry 5000 10 10000 Sets the maximum number of entries for aggregated stats recording. Customized Options postmaster default 5000
google_insights.max_per_database_statements_counts 100 10 500 Sets the maximum number of databases for which statements counts will be tracked Customized Options postmaster default 100
google_insights.max_query_length 1024 256 4500 Sets the length of the query recorded Customized Options postmaster default 1024
google_insights.max_query_stats_entry 5000 10 10000 Sets the maximum number of entries for top N query stats recording. Customized Options postmaster default 5000
google_insights.max_tag_stats_entry 5000 10 10000 Sets the maximum number of entries for top N tag stats recording. Customized Options postmaster default 5000
google_insights.num_query_plans_per_minute 5 0 20 Sets the number of execution plans to sample per minute for all connections. Customized Options superuser configuration file 5
google_insights.num_trace_context_query_plans_per_minute 5 0 100 Sets the number of execution plans for trace context to sample per minute for all connections. Customized Options superuser default 5
google_insights.skip_acquired_sample_lock on Sets whether to skip sample lock if its already acquired. Customized Options superuser default on
google_insights.trace_buffer_size_in_kb 1024 256 4096 Sets the size (in KB) of buffer in shared memory that stores query execution plans. Customized Options postmaster default 1024
google_insights.track on Sets whether to enable stats tracking, which can be set on the fly to disable the code path. Customized Options superuser configuration file on
google_insights.track_active_queries off Sets whether to enable the extension. Customized Options superuser default off
google_insights.track_additional_utility_commands on Sets whether to track additional utility commands. Customized Options superuser default on
google_insights.track_client_address off Sets whether to track client addresses in statistic tables. When they are tracked, the same statement executed by clients from different addresses produces different records. Customized Options superuser configuration file off
google_insights.track_comment off Sets whether to enable stats recording for tags table. Customized Options superuser configuration file off
google_insights.track_internal_metrics on Sets whether to track internal metrics. Customized Options superuser default on
google_insights.track_new_connection_stats off Sets whether to track new connection count. Customized Options superuser default off
google_insights.track_statements_executed_count on Sets whether to track statements executed count. Customized Options superuser default on
google_job_scheduler.maintenance_cpu_percentage 20 0 100 Maximum percentage of CPU cores to use for maintenance jobs. Customized Options sighup default 20
google_job_scheduler.max_parallel_workers_per_job 2 0 262143 Maximum number of parallel processes per job. Customized Options user default 2
google_ml_integration.enable_model_support off Enable Alloydb AI support for general models. Google AlloyDB Options sighup default off
google_plan_management.enabled off Enable google plan management. Google AlloyDB Options postmaster default off
google_stats_collection_enabled off Enable database kernel statistics collection. Google Statistics Collection Options postmaster default off
hash_mem_multiplier 2 1 1000 Multiple of work_mem to use for hash tables. Resource Usage / Memory user default 2
hba_file /mnt/disks/pgsql/data/pg_hba.conf Sets the server's "hba" configuration file. File Locations postmaster override /mnt/disks/pgsql/data/pg_hba.conf
hnsw.ef_search 40 1 1000 Sets the size of the dynamic candidate list for search Customized Options user default 40
hot_standby on Allows connections and queries during recovery. Replication / Standby Servers postmaster configuration file on
hot_standby_feedback on Allows feedback from a hot standby to the primary that will avoid query conflicts. Replication / Standby Servers sighup configuration file on
huge_page_size 0 bytes 0 2147483647 The size of huge page that should be requested. Resource Usage / Memory postmaster kB default 0
huge_pages on Use of huge pages on Linux or Windows. Resource Usage / Memory postmaster configuration file on
ident_file /mnt/disks/pgsql/data/pg_ident.conf Sets the server's "ident" configuration file. File Locations postmaster override /mnt/disks/pgsql/data/pg_ident.conf
idle_in_transaction_session_timeout 0 ms 0 2147483647 Sets the maximum allowed idle time between queries, when in a transaction. Client Connection Defaults / Statement Behavior user ms default 0
idle_session_timeout 0 ms 0 2147483647 Sets the maximum allowed idle time between queries, when not in a transaction. Client Connection Defaults / Statement Behavior user ms default 0
ignore_checksum_failure off Continues processing after a checksum failure. Developer Options superuser default off
ignore_invalid_pages off Continues recovery after an invalid pages failure. Developer Options postmaster default off
ignore_system_indexes off Disables reading from system indexes. Developer Options backend default off
in_hot_standby off Shows whether hot standby is currently active. Preset Options internal default off
integer_datetimes on Shows whether datetimes are integer based. Preset Options internal default on
IntervalStyle postgres Sets the display format for interval values. Client Connection Defaults / Locale and Formatting user default postgres
ivf.probes 1 1 32768 Sets the number of probes Customized Options user default 1
ivfflat.probes 1 1 32768 Sets the number of probes Customized Options user default 1
jit on Allow JIT compilation. Query Tuning / Other Planner Options user default on
jit_above_cost 100000 -1 1.79769e+308 Perform JIT compilation if query is more expensive. Query Tuning / Planner Cost Constants user default 100000
jit_debugging_support off Register JIT-compiled functions with debugger. Developer Options superuser-backend default off
jit_dump_bitcode off Write out LLVM bitcode to facilitate JIT debugging. Developer Options superuser default off
jit_expressions on Allow JIT compilation of expressions. Developer Options user default on
jit_inline_above_cost 500000 -1 1.79769e+308 Perform JIT inlining if query is more expensive. Query Tuning / Planner Cost Constants user default 500000
jit_optimize_above_cost 500000 -1 1.79769e+308 Optimize JIT-compiled functions if query is more expensive. Query Tuning / Planner Cost Constants user default 500000
jit_profiling_support off Register JIT-compiled functions with perf profiler. Developer Options superuser-backend default off
jit_provider llvmjit JIT provider to use. Client Connection Defaults / Shared Library Preloading postmaster default llvmjit
jit_tuple_deforming on Allow JIT compilation of tuple deforming. Developer Options user default on
join_collapse_limit 8 1 2147483647 Sets the FROM-list size beyond which JOIN constructs are not flattened. Query Tuning / Other Planner Options user default 8
krb_caseins_users off Sets whether Kerberos and GSSAPI user names should be treated as case-insensitive. Connections and Authentication / Authentication sighup default off
krb_server_keyfile Sets the location of the Kerberos server key file. Connections and Authentication / Authentication sighup default
lc_collate C Shows the collation order locale. Preset Options internal default C
lc_ctype C Shows the character classification and case conversion locale. Preset Options internal default C
lc_messages en_US.UTF8 Sets the language in which messages are displayed. Client Connection Defaults / Locale and Formatting superuser configuration file en_US.UTF8
lc_monetary en_US.UTF8 Sets the locale for formatting monetary amounts. Client Connection Defaults / Locale and Formatting user configuration file en_US.UTF8
lc_numeric en_US.UTF8 Sets the locale for formatting numbers. Client Connection Defaults / Locale and Formatting user configuration file en_US.UTF8
lc_time en_US.UTF8 Sets the locale for formatting date and time values. Client Connection Defaults / Locale and Formatting user configuration file en_US.UTF8
listen_addresses * Sets the host name or IP address(es) to listen to. Connections and Authentication / Connection Settings postmaster command line *
lo_compat_privileges off Enables backward compatibility mode for privilege checks on large objects. Version and Platform Compatibility / Previous PostgreSQL Versions superuser default off
local_preload_libraries Lists unprivileged shared libraries to preload into each backend. Client Connection Defaults / Shared Library Preloading user default
lock_timeout 0 ms 0 2147483647 Sets the maximum allowed duration of any wait for a lock. Client Connection Defaults / Statement Behavior user ms default 0
log_autovacuum_min_duration 0 ms -1 2147483647 Sets the minimum execution time above which autovacuum actions will be logged. Reporting and Logging / What to Log sighup ms configuration file 0
log_checkpoints on Logs each checkpoint. Reporting and Logging / What to Log sighup default on
log_connections off Logs each successful connection. Reporting and Logging / What to Log superuser-backend default off
log_destination stderr Sets the destination for server log output. Reporting and Logging / Where to Log sighup default stderr
log_directory log Sets the destination directory for log files. Reporting and Logging / Where to Log sighup configuration file log
log_disconnections off Logs end of a session, including duration. Reporting and Logging / What to Log superuser-backend default off
log_duration off Logs the duration of each completed SQL statement. Reporting and Logging / What to Log superuser default off
log_error_verbosity default Sets the verbosity of logged messages. Reporting and Logging / What to Log superuser default default
log_executor_stats off Writes executor performance statistics to the server log. Statistics / Monitoring superuser default off
log_file_mode 0600 0 511 Sets the file permissions for log files. Reporting and Logging / Where to Log sighup default 0600
log_filename postgres Sets the file name pattern for log files. Reporting and Logging / Where to Log sighup configuration file postgres
log_hostname off Logs the host name in the connection logs. Reporting and Logging / What to Log sighup default off
log_line_prefix %m [%p]: [%l-1] db=%d,user=%u Controls information prefixed to each log line. Reporting and Logging / What to Log sighup configuration file %m [%p]: [%l-1] db=%d,user=%u
log_lock_waits off Logs long lock waits. Reporting and Logging / What to Log superuser default off
log_min_duration_sample -1 ms -1 2147483647 Sets the minimum execution time above which a sample of statements will be logged. Sampling is determined by log_statement_sample_rate. Reporting and Logging / When to Log superuser ms default -1
log_min_duration_statement -1 ms -1 2147483647 Sets the minimum execution time above which all statements will be logged. Reporting and Logging / When to Log superuser ms default -1
log_min_error_statement error Causes all statements generating error at or above this level to be logged. Reporting and Logging / When to Log superuser default error
log_min_messages warning Sets the message levels that are logged. Reporting and Logging / When to Log superuser default warning
log_parameter_max_length -1 bytes -1 1073741823 Sets the maximum length in bytes of data logged for bind parameter values when logging statements. Reporting and Logging / What to Log superuser B default -1
log_parameter_max_length_on_error 0 bytes -1 1073741823 Sets the maximum length in bytes of data logged for bind parameter values when logging statements, on error. Reporting and Logging / What to Log user B default 0
log_parser_stats off Writes parser performance statistics to the server log. Statistics / Monitoring superuser default off
log_planner_stats off Writes planner performance statistics to the server log. Statistics / Monitoring superuser default off
log_recovery_conflict_waits off Logs standby recovery conflict waits. Reporting and Logging / What to Log sighup default off
log_replication_commands off Logs each replication command. Reporting and Logging / What to Log superuser default off
log_rotation_age 0 min 0 35791394 Sets the amount of time to wait before forcing log file rotation. Reporting and Logging / Where to Log sighup min configuration file 0
log_rotation_size 0 bytes 0 2097151 Sets the maximum size a log file can reach before being rotated. Reporting and Logging / Where to Log sighup kB configuration file 0
log_startup_progress_interval 10000 ms 0 2147483647 Time between progress updates for long-running startup operations. Reporting and Logging / When to Log sighup ms default 10000
log_statement none Sets the type of statements logged. Reporting and Logging / What to Log superuser default none
log_statement_sample_rate 1 0 1 Fraction of statements exceeding log_min_duration_sample to be logged. Reporting and Logging / When to Log superuser default 1
log_statement_stats off Writes cumulative performance statistics to the server log. Statistics / Monitoring superuser default off
log_temp_files 0 bytes -1 2147483647 Log the use of temporary files larger than this number of kilobytes. Reporting and Logging / What to Log superuser kB configuration file 0
log_timezone UTC Sets the time zone to use in log messages. Reporting and Logging / What to Log sighup configuration file UTC
log_transaction_sample_rate 0 0 1 Sets the fraction of transactions from which to log all statements. Reporting and Logging / When to Log superuser default 0
log_truncate_on_rotation off Truncate existing log files of same name during log rotation. Reporting and Logging / Where to Log sighup default off
log_wait_event_on_shutdown off Writes/Aggregates wait event information while disconnecting a session Statistics / Cumulative Query and Index Statistics superuser default off
logging_collector off Start a subprocess to capture stderr output and/or csvlogs into log files. Reporting and Logging / Where to Log postmaster default off
logical_decoding_work_mem 64 MB 64 2147483647 Sets the maximum memory to be used for logical decoding. Resource Usage / Memory user kB default 65536
lux_enable_spill_files_debug off Enable debug mode for spill files. Used for testing. Google AlloyDB Options superuser default off
maintenance_io_concurrency 10 0 1000 A variant of effective_io_concurrency that is used for maintenance work. Resource Usage / Asynchronous Behavior user default 10
maintenance_work_mem 64 MB 1024 2147483647 Sets the maximum memory to be used for maintenance operations. Resource Usage / Memory user kB default 65536
max_connections 1000 1 262143 Sets the maximum number of concurrent connections. Connections and Authentication / Connection Settings postmaster configuration file 1000
max_files_per_process 1000 64 2147483647 Sets the maximum number of simultaneously open files for each server process. Resource Usage / Kernel Resources postmaster default 1000
max_function_args 100 100 100 Shows the maximum number of function arguments. Preset Options internal default 100
max_identifier_length 63 63 63 Shows the maximum identifier length. Preset Options internal default 63
max_index_keys 32 32 32 Shows the maximum number of index keys. Preset Options internal default 32
max_locks_per_transaction 64 10 2147483647 Sets the maximum number of locks per transaction. Lock Management postmaster configuration file 64
max_logical_replication_workers 4 0 262143 Maximum number of logical replication worker processes. Replication / Subscribers postmaster default 4
max_parallel_maintenance_workers 2 0 1024 Sets the maximum number of parallel processes per maintenance operation. Resource Usage / Asynchronous Behavior user default 2
max_parallel_workers 8 0 1024 Sets the maximum number of parallel workers that can be active at one time. Resource Usage / Asynchronous Behavior user configuration file 8
max_parallel_workers_per_gather 2 0 1024 Sets the maximum number of parallel processes per executor node. Resource Usage / Asynchronous Behavior user configuration file 2
max_pred_locks_per_page 2 0 2147483647 Sets the maximum number of predicate-locked tuples per page. Lock Management sighup default 2
max_pred_locks_per_relation -2 -2147483648 2147483647 Sets the maximum number of predicate-locked pages and tuples per relation. Lock Management sighup default -2
max_pred_locks_per_transaction 64 10 2147483647 Sets the maximum number of predicate locks per transaction. Lock Management postmaster default 64
max_prepared_transactions 0 0 262143 Sets the maximum number of simultaneously prepared transactions. Resource Usage / Memory postmaster configuration file 0
max_replication_slots 50 0 262143 Sets the maximum number of simultaneously defined replication slots. Replication / Sending Servers postmaster configuration file 50
max_slot_inactive_keep_time 604800 s -1 2147483647 Sets the maximum inactive time for replications slots before they are invalidated. Replication / Sending Servers sighup s default 604800
max_slot_wal_keep_size 800 GB -1 2147483647 Sets the maximum WAL size that can be reserved by replication slots. Replication / Sending Servers sighup MB configuration file 819200
max_stack_depth 2048 kB 100 2147483647 Sets the maximum stack depth, in kilobytes. Resource Usage / Memory superuser kB default 2048
max_standby_archive_delay 30000 ms -1 2147483647 Sets the maximum delay before canceling queries when a hot standby server is processing archived WAL data. Replication / Standby Servers sighup ms default 30000
max_standby_streaming_delay 30000 ms -1 2147483647 Sets the maximum delay before canceling queries when a hot standby server is processing streamed WAL data. Replication / Standby Servers sighup ms default 30000
max_sync_workers_per_subscription 2 0 262143 Maximum number of table synchronization workers per subscription. Replication / Subscribers sighup default 2
max_wal_senders 50 0 262143 Sets the maximum number of simultaneously running WAL sender processes. Replication / Sending Servers postmaster configuration file 50
max_wal_size 1504 MB 2 2147483647 Sets the WAL size that triggers a checkpoint. Write-Ahead Log / Checkpoints sighup MB configuration file 1504
max_worker_processes 64 0 262143 Maximum number of concurrent worker processes. Resource Usage / Asynchronous Behavior postmaster configuration file 64
min_dynamic_shared_memory 0 bytes 0 2147483647 Amount of dynamic shared memory reserved at startup. Resource Usage / Memory postmaster MB default 0
min_parallel_index_scan_size 512 kB 0 715827882 Sets the minimum amount of index data for a parallel scan. Query Tuning / Planner Cost Constants user 8kB default 64
min_parallel_table_scan_size 8192 kB 0 715827882 Sets the minimum amount of table data for a parallel scan. Query Tuning / Planner Cost Constants user 8kB default 1024
min_wal_size 80 MB 2 2147483647 Sets the minimum size to shrink the WAL to. Write-Ahead Log / Checkpoints sighup MB default 80
old_snapshot_threshold -1 min -1 86400 Time before a snapshot is too old to read pages changed after the snapshot was taken. Resource Usage / Asynchronous Behavior postmaster min default -1
omni_enable_post_startup_helper on Enables the post startup helper for One-Omni. Currently this worker's main responsibility is to reinstall Google extensions. Google AlloyDB Options postmaster default on
parallel_leader_participation on Controls whether Gather and Gather Merge also run subplans. Resource Usage / Asynchronous Behavior user default on
parallel_setup_cost 1000 0 1.79769e+308 Sets the planner's estimate of the cost of starting up worker processes for parallel query. Query Tuning / Planner Cost Constants user default 1000
parallel_tuple_cost 0.1 0 1.79769e+308 Sets the planner's estimate of the cost of passing each tuple (row) from worker to leader backend. Query Tuning / Planner Cost Constants user default 0.1
password_encryption scram-sha-256 Chooses the algorithm for encrypting passwords. Connections and Authentication / Authentication user default scram-sha-256
password.enforce_complexity on Sets whether to enable password complexity. Customized Options superuser configuration file on
password.enforce_expiration off Sets whether to enforce password expiration. Customized Options superuser default off
password.enforce_password_does_not_contain_username off Sets whether to enforce that password does not contain username. Customized Options superuser default off
password.expiration_in_days 90 0 10000 The number of days that a password will expire after. Customized Options superuser default 90
password.max_lowercase_letters 10000 0 10000 Maximum number of lowercase letters allowed in a password. Customized Options superuser default 10000
password.max_numerical_chars 10000 0 10000 Maximum number of numerical chars allowed in a password. Customized Options superuser default 10000
password.max_pass_length 10000 0 10000 Maximum length of a password. Customized Options superuser default 10000
password.max_special_chars 10000 0 10000 Maximum number of special chars allowed in a password. Customized Options superuser default 10000
password.max_uppercase_letters 10000 0 10000 Maximum number of uppercase letters allowed in a password. Customized Options superuser default 10000
password.min_lowercase_letters 0 0 10000 Minimum number of lowercase letters needed in a password. Customized Options superuser default 0
password.min_numerical_chars 0 0 10000 Minimum number of numerical chars needed in a password. Customized Options superuser default 0
password.min_pass_length 0 0 10000 Minimum length of a password. Customized Options superuser default 0
password.min_special_chars 0 0 10000 Minimum number of special chars needed in a password. Customized Options superuser default 0
password.min_uppercase_letters 0 0 10000 Minimum number of uppercase letters needed in a password. Customized Options superuser default 0
password.notify_expiration_in_days 30 0 10000 Number of days before password expired that user will get notification. Customized Options superuser default 30
perfsnap.max_manual_snapshots_to_keep 2500 0 10000 Maximum number of manual performance snapshots to keep Google AlloyDB Options sighup default 2500
pg_stat_statements.max 5000 100 1073741823 Sets the maximum number of statements tracked by pg_stat_statements. Customized Options postmaster default 5000
pg_stat_statements.save on Save pg_stat_statements statistics across server shutdowns. Customized Options sighup default on
pg_stat_statements.track top Selects which statements are tracked by pg_stat_statements. Customized Options superuser default top
pg_stat_statements.track_planning off Selects whether planning duration is tracked by pg_stat_statements. Customized Options superuser default off
pg_stat_statements.track_utility on Selects whether utility commands are tracked by pg_stat_statements. Customized Options superuser default on
plan_cache_mode auto Controls the planner's selection of custom or generic plan. Query Tuning / Other Planner Options user default auto
port 5432 1 65535 Sets the TCP port the server listens on. Connections and Authentication / Connection Settings postmaster command line 5432
post_auth_delay 0 s 0 2147 Sets the amount of time to wait after authentication on connection startup. Developer Options backend s default 0
pre_auth_delay 0 s 0 60 Sets the amount of time to wait before authentication on connection startup. Developer Options sighup s default 0
prespawned_worker_processes 1 -1 262143 Number of pre-spawned background worker processes. Google AlloyDB Options sighup default 1
prespawned_worker_wakeup_timeout_ms 60000 10 86400000 Timeout for pre-spawned background workers to handle interrupts while waiting for wakeup signal. Google AlloyDB Options sighup default 60000
primary_conninfo Sets the connection string to be used to connect to the sending server. Replication / Standby Servers sighup default
primary_slot_name Sets the name of the replication slot to use on the sending server. Replication / Standby Servers sighup default
promote_trigger_file Specifies a file name whose presence ends recovery in the standby. Replication / Standby Servers sighup default
quote_all_identifiers off When generating SQL fragments, quote all identifiers. Version and Platform Compatibility / Previous PostgreSQL Versions user default off
random_page_cost 4 0 1.79769e+308 Sets the planner's estimate of the cost of a nonsequentially fetched disk page. Query Tuning / Planner Cost Constants user default 4
recovery_end_command Sets the shell command that will be executed once at the end of recovery. Write-Ahead Log / Archive Recovery sighup default
recovery_init_sync_method fsync Sets the method for synchronizing the data directory before crash recovery. Error Handling sighup default fsync
recovery_min_apply_delay 0 ms 0 2147483647 Sets the minimum delay for applying changes during recovery. Replication / Standby Servers sighup ms default 0
recovery_prefetch off Prefetch referenced blocks during recovery. Write-Ahead Log / Recovery sighup default off
recovery_target Set to "immediate" to end recovery as soon as a consistent state is reached. Write-Ahead Log / Recovery Target postmaster default
recovery_target_action pause Sets the action to perform upon reaching the recovery target. Write-Ahead Log / Recovery Target postmaster default pause
recovery_target_inclusive on Sets whether to include or exclude transaction with recovery target. Write-Ahead Log / Recovery Target postmaster default on
recovery_target_lsn Sets the LSN of the write-ahead log location up to which recovery will proceed. Write-Ahead Log / Recovery Target postmaster default
recovery_target_name Sets the named restore point up to which recovery will proceed. Write-Ahead Log / Recovery Target postmaster default
recovery_target_time Sets the time stamp up to which recovery will proceed. Write-Ahead Log / Recovery Target postmaster default
recovery_target_timeline latest Specifies the timeline to recover into. Write-Ahead Log / Recovery Target postmaster configuration file latest
recovery_target_xid Sets the transaction ID up to which recovery will proceed. Write-Ahead Log / Recovery Target postmaster default
recursive_worktable_factor 10 0.001 1e+06 Sets the planner's estimate of the average size of a recursive query's working table. Query Tuning / Other Planner Options user default 10
remove_temp_files_after_crash on Remove temporary files after backend crash. Developer Options sighup default on
reserved_worker_processes 0 0 262143 Sets the number of worker slots reserved for roles with privileges of pg_use_reserved_worker_processes. Resource Usage / Asynchronous Behavior postmaster default 0
restart_after_crash off Reinitialize server after backend crash. Error Handling sighup default off
restore_command cp "/mnt/disks/pgsql/data/pg_remote_wal/%f" "%p" Sets the shell command that will be called to retrieve an archived WAL file. Write-Ahead Log / Archive Recovery sighup configuration file cp "/mnt/disks/pgsql/data/pg_remote_wal/%f" "%p"
restrict_nonsystem_relation_kind Sets relation kinds of non-system relation to restrict use Client Connection Defaults / Statement Behavior user default
row_security on Enable row security. Client Connection Defaults / Statement Behavior user default on
scann.allow_blocked_operations off Allow building scann index unsafely. Google AlloyDB Options user default off
scann.enable_pca on Enable PCA for dimensionality reduction Customized Options user default on
scann.expected_sample_size 1 1 2147483647 Defines the expected number of datapoints to sample. Customized Options user default 1
scann.max_num_prefetch_datasets 1000 10 6000 The maximum number of data batches to prefetch during index search phase, a batch is a group of buffer pages. Customized Options user default 1000
scann.min_qualifying_rows 1000 0 1.79769e+308 Minimum qualifying rows necessary to enable scann index scan. Customized Options user default 1000
scann.min_selectivity_percentage 0 0 100 Minimum selectivity in percentage to enable scann index scan. Customized Options user default 0
scann.num_leaves_to_search 0 0 2147483647 The number of leaves to search. If it's not specified or set as zero, it will be num_leaves * 0.01 (num_leaves is set when index is created). Customized Options user default 0
scann.num_search_threads -1 -1 4 The number searcher threads for multi-thread search. Customized Options user default -1
scann.pre_reordering_num_neighbors -1 -1 10000 The number of neighbors to return before reordering to improve recall.no-op when the value is smaller than limit value. Only applies to sq8 quantizer. Customized Options user default -1
search_path "$user", public Sets the schema search order for names that are not schema-qualified. Client Connection Defaults / Statement Behavior user default "$user", public
segment_size 1024 MB 0 2147483647 Shows the number of pages per disk file. Preset Options internal 8kB default 131072
seq_page_cost 1 0 1.79769e+308 Sets the planner's estimate of the cost of a sequentially fetched disk page. Query Tuning / Planner Cost Constants user default 1
server_encoding UTF8 Shows the server (database) character set encoding. Preset Options internal default UTF8
server_version 15.7 Shows the server version. Preset Options internal default 15.7
server_version_num 150007 150007 150007 Shows the server version as an integer. Preset Options internal default 150007
session_preload_libraries Lists shared libraries to preload into each backend. Client Connection Defaults / Shared Library Preloading superuser default
session_replication_role origin Sets the session's behavior for triggers and rewrite rules. Client Connection Defaults / Statement Behavior superuser default origin
shared_buffers 13 GB 0 1073741823 Sets the number of shared memory buffers used by the server. Resource Usage / Memory postmaster 8kB configuration file 1638400
shared_memory_expand_ratio 0.25 0 1.79769e+308 Sets the ratio that shared memory can expand to compared with initial estimate. Resource Usage / Memory postmaster default 0.25
shared_memory_size 2618 MB 0 2147483647 Shows the size of the server's main shared memory area (rounded up to the nearest MB). Preset Options internal MB default 2618
shared_memory_size_in_huge_pages 1309 -1 2147483647 Shows the number of huge pages needed for the main shared memory area. Preset Options internal default 1309
shared_memory_type mmap Selects the shared memory implementation used for the main shared memory region. Resource Usage / Memory postmaster default mmap
shared_preload_libraries alloydb_password_validation,alloydb_scann,g_stat_activity,g_stats,google_columnar_engine,google_db_advisor,google_insights,google_job_scheduler,google_stats_collection,google_storage,pg_stat_statements,vector Lists shared libraries to preload into server. Client Connection Defaults / Shared Library Preloading postmaster configuration file alloydb_password_validation,alloydb_scann,g_stat_activity,g_stats,google_columnar_engine,google_db_advisor,google_insights,google_job_scheduler,google_stats_collection,google_storage,pg_stat_statements,vector
ssl on Enables SSL connections. Connections and Authentication / SSL sighup configuration file on
ssl_ca_file Location of the SSL certificate authority file. Connections and Authentication / SSL sighup default
ssl_cert_file /mnt/stateful_partition/cert/server/cert.pem Location of the SSL server certificate file. Connections and Authentication / SSL sighup configuration file /mnt/stateful_partition/cert/server/cert.pem
ssl_ciphers HIGH:MEDIUM:+3DES:!aNULL Sets the list of allowed SSL ciphers. Connections and Authentication / SSL sighup default HIGH:MEDIUM:+3DES:!aNULL
ssl_crl_dir Location of the SSL certificate revocation list directory. Connections and Authentication / SSL sighup default
ssl_crl_file Location of the SSL certificate revocation list file. Connections and Authentication / SSL sighup default
ssl_dh_params_file Location of the SSL DH parameters file. Connections and Authentication / SSL sighup default
ssl_ecdh_curve prime256v1 Sets the curve to use for ECDH. Connections and Authentication / SSL sighup default prime256v1
ssl_key_file /mnt/stateful_partition/cert/server/key.pem Location of the SSL server private key file. Connections and Authentication / SSL sighup configuration file /mnt/stateful_partition/cert/server/key.pem
ssl_library OpenSSL Shows the name of the SSL library. Preset Options internal default OpenSSL
ssl_max_protocol_version Sets the maximum SSL/TLS protocol version to use. Connections and Authentication / SSL sighup default
ssl_min_protocol_version TLSv1.2 Sets the minimum SSL/TLS protocol version to use. Connections and Authentication / SSL sighup default TLSv1.2
ssl_passphrase_command Command to obtain passphrases for SSL. Connections and Authentication / SSL sighup default
ssl_passphrase_command_supports_reload off Controls whether ssl_passphrase_command is called during server reload. Connections and Authentication / SSL sighup default off
ssl_prefer_server_ciphers on Give priority to server ciphersuite order. Connections and Authentication / SSL sighup default on
standard_conforming_strings on Causes '...' strings to treat backslashes literally. Version and Platform Compatibility / Previous PostgreSQL Versions user default on
statement_timeout 0 ms 0 2147483647 Sets the maximum allowed duration of any statement. Client Connection Defaults / Statement Behavior user ms default 0
stats_fetch_consistency cache Sets the consistency of accesses to statistics data. Statistics / Cumulative Query and Index Statistics user default cache
superuser_reserved_connections 30 0 262143 Sets the number of connection slots reserved for superusers. Connections and Authentication / Connection Settings postmaster default 30
superuser_reserved_worker_processes 0 0 262143 Sets the number of worker slots reserved for superusers. Resource Usage / Asynchronous Behavior postmaster default 0
synchronize_seqscans on Enable synchronized sequential scans. Version and Platform Compatibility / Previous PostgreSQL Versions user default on
synchronous_commit on Sets the current transaction's synchronization level. Write-Ahead Log / Settings user configuration file on
synchronous_standby_names Number of synchronous standbys and list of names of potential synchronous ones. Replication / Primary Server sighup default
syslog_facility local0 Sets the syslog "facility" to be used when syslog enabled. Reporting and Logging / Where to Log sighup default local0
syslog_ident postgres Sets the program name used to identify PostgreSQL messages in syslog. Reporting and Logging / Where to Log sighup default postgres
syslog_sequence_numbers on Add sequence number to syslog messages to avoid duplicate suppression. Reporting and Logging / Where to Log sighup default on
syslog_split_messages on Split messages sent to syslog by lines and to fit into 1024 bytes. Reporting and Logging / Where to Log sighup default on
tcp_keepalives_count 5 0 2147483647 Maximum number of TCP keepalive retransmits. Connections and Authentication / Connection Settings user default 5
tcp_keepalives_idle 300 s 0 2147483647 Time between issuing TCP keepalives. Connections and Authentication / Connection Settings user s default 300
tcp_keepalives_interval 60 s 0 2147483647 Time between TCP keepalive retransmits. Connections and Authentication / Connection Settings user s default 60
tcp_user_timeout 0 ms 0 2147483647 TCP user timeout. Connections and Authentication / Connection Settings user ms default 0
temp_buffers 8192 kB 100 1073741823 Sets the maximum number of temporary buffers used by each session. Resource Usage / Memory user 8kB default 1024
temp_file_limit -1024 bytes -1 2147483647 Limits the total size of all temporary files used by each process. Resource Usage / Disk superuser kB default -1
temp_tablespaces Sets the tablespace(s) to use for temporary tables and sort files. Client Connection Defaults / Statement Behavior user default
TimeZone UTC Sets the time zone for displaying and interpreting time stamps. Client Connection Defaults / Locale and Formatting user configuration file UTC
timezone_abbreviations Default Selects a file of time zone abbreviations. Client Connection Defaults / Locale and Formatting user default Default
trace_notify off Generates debugging output for LISTEN and NOTIFY. Developer Options user default off
trace_recovery_messages log Enables logging of recovery-related debugging information. Developer Options sighup default log
trace_sort off Emit information about resource usage in sorting. Developer Options user default off
track_activities on Collects information about executing commands. Statistics / Cumulative Query and Index Statistics superuser default on
track_activity_query_size 1024 bytes 100 1048576 Sets the size reserved for pg_stat_activity.query, in bytes. Statistics / Cumulative Query and Index Statistics postmaster B default 1024
track_commit_timestamp off Collects transaction commit time. Replication / Sending Servers postmaster default off
track_counts on Collects statistics on database activity. Statistics / Cumulative Query and Index Statistics superuser default on
track_functions none Collects function-level statistics on database activity. Statistics / Cumulative Query and Index Statistics superuser default none
track_io_timing on Collects timing statistics for database I/O activity. Statistics / Cumulative Query and Index Statistics superuser configuration file on
track_lockwait_timing on Collects timing statistics for lock wait events. Statistics / Cumulative Query and Index Statistics superuser configuration file on
track_misc_time on Collects timing statistics for miscellaneous activity other than wait events. Statistics / Cumulative Query and Index Statistics superuser configuration file on
track_wait_histogram on Collects wait histogram information. Statistics / Cumulative Query and Index Statistics superuser configuration file on
track_wait_time on Collects timing statistics for wait events. Statistics / Cumulative Query and Index Statistics user configuration file on
track_wal_io_timing off Collects timing statistics for WAL I/O activity. Statistics / Cumulative Query and Index Statistics superuser default off
transaction_deferrable off Whether to defer a read-only serializable transaction until it can be executed with no possible serialization failures. Client Connection Defaults / Statement Behavior user override off
transaction_isolation read committed Sets the current transaction's isolation level. Client Connection Defaults / Statement Behavior user override read committed
transaction_read_only off Sets the current transaction's read-only status. Client Connection Defaults / Statement Behavior user override off
transform_null_equals off Treats "expr=NULL" as "expr IS NULL". Version and Platform Compatibility / Other Platforms and Clients user default off
unix_socket_directories /mnt/disks/pgsql Sets the directories where Unix-domain sockets will be created. Connections and Authentication / Connection Settings postmaster command line /mnt/disks/pgsql
unix_socket_group Sets the owning group of the Unix-domain socket. Connections and Authentication / Connection Settings postmaster default
unix_socket_permissions 0777 0 511 Sets the access permissions of the Unix-domain socket. Connections and Authentication / Connection Settings postmaster default 0777
update_process_title on Updates the process title to show the active SQL command. Reporting and Logging / Process Title superuser default on
vacuum_cost_delay 0 ms 0 100 Vacuum cost delay in milliseconds. Resource Usage / Cost-Based Vacuum Delay user ms default 0
vacuum_cost_limit 200 1 10000 Vacuum cost amount available before napping. Resource Usage / Cost-Based Vacuum Delay user default 200
vacuum_cost_page_dirty 20 0 10000 Vacuum cost for a page dirtied by vacuum. Resource Usage / Cost-Based Vacuum Delay user default 20
vacuum_cost_page_hit 1 0 10000 Vacuum cost for a page found in the buffer cache. Resource Usage / Cost-Based Vacuum Delay user default 1
vacuum_cost_page_miss 2 0 10000 Vacuum cost for a page not found in the buffer cache. Resource Usage / Cost-Based Vacuum Delay user default 2
vacuum_defer_cleanup_age 0 0 1000000 Number of transactions by which VACUUM and HOT cleanup should be deferred, if any. Replication / Primary Server sighup default 0
vacuum_failsafe_age 1200000000 0 2100000000 Age at which VACUUM should trigger failsafe to avoid a wraparound outage. Client Connection Defaults / Statement Behavior user default 1200000000
vacuum_freeze_min_age 50000000 0 1000000000 Minimum age at which VACUUM should freeze a table row. Client Connection Defaults / Statement Behavior user default 50000000
vacuum_freeze_table_age 150000000 0 2000000000 Age at which VACUUM should scan whole table to freeze tuples. Client Connection Defaults / Statement Behavior user default 150000000
vacuum_multixact_failsafe_age 1200000000 0 2100000000 Multixact age at which VACUUM should trigger failsafe to avoid a wraparound outage. Client Connection Defaults / Statement Behavior user default 1200000000
vacuum_multixact_freeze_min_age 5000000 0 1000000000 Minimum age at which VACUUM should freeze a MultiXactId in a table row. Client Connection Defaults / Statement Behavior user default 5000000
vacuum_multixact_freeze_table_age 150000000 0 2000000000 Multixact age at which VACUUM should scan whole table to freeze tuples. Client Connection Defaults / Statement Behavior user default 150000000
wal_block_size 8192 8192 8192 Shows the block size in the write ahead log. Preset Options internal default 8192
wal_buffers 32 MB -1 2147483647 Sets the number of disk-page buffers in shared memory for WAL. Write-Ahead Log / Settings postmaster 8kB default 4096
wal_compression off Compresses full-page writes written in WAL file with specified method. Write-Ahead Log / Settings superuser default off
wal_consistency_checking Sets the WAL resource managers for which WAL consistency checks are done. Developer Options superuser default
wal_decode_buffer_size 512 kB 65536 1073741823 Buffer size for reading ahead in the WAL during recovery. Write-Ahead Log / Recovery postmaster B default 524288
wal_init_zero off Writes zeroes to new WAL files before first use. Write-Ahead Log / Settings superuser configuration file off
wal_keep_size 100 GB 0 2147483647 Sets the size of WAL files held for standby servers. Replication / Sending Servers sighup MB configuration file 102400
wal_level replica Sets the level of information written to the WAL. Write-Ahead Log / Settings postmaster configuration file replica
wal_log_hints off Writes full pages to WAL when first modified after a checkpoint, even for a non-critical modification. Write-Ahead Log / Settings postmaster default off
wal_receiver_create_temp_slot off Sets whether a WAL receiver should create a temporary replication slot if no permanent slot is configured. Replication / Standby Servers sighup default off
wal_receiver_status_interval 10 s 0 2147483 Sets the maximum interval between WAL receiver status reports to the sending server. Replication / Standby Servers sighup s default 10
wal_receiver_timeout 60000 ms 0 2147483647 Sets the maximum wait time to receive data from the sending server. Replication / Standby Servers sighup ms default 60000
wal_recycle on Recycles WAL files by renaming them. Write-Ahead Log / Settings superuser default on
wal_retrieve_retry_interval 5000 ms 1 2147483647 Sets the time to wait before retrying to retrieve WAL after a failed attempt. Replication / Standby Servers sighup ms default 5000
wal_segment_size 16 MB 1048576 1073741824 Shows the size of write ahead log segments. Preset Options internal B default 16777216
wal_sender_timeout 60000 ms 0 2147483647 Sets the maximum time to wait for WAL replication. Replication / Sending Servers user ms default 60000
wal_skip_threshold 2048 kB 0 2147483647 Minimum size of new file to fsync instead of writing WAL. Write-Ahead Log / Settings user kB default 2048
wal_sync_method fdatasync Selects the method used for forcing WAL updates to disk. Write-Ahead Log / Settings sighup default fdatasync
wal_writer_delay 200 ms 1 10000 Time between WAL flushes performed in the WAL writer. Write-Ahead Log / Settings sighup ms default 200
wal_writer_flush_after 1024 kB 0 2147483647 Amount of WAL written out by WAL writer that triggers a flush. Write-Ahead Log / Settings sighup 8kB default 128
walsender_print_stats_every_secs 60 0 86400 How often to print the walsender stats. 0 means disabled.Stats will only be printed if there was activity in the walsender. Google AlloyDB Options sighup default 60
work_mem 4096 kB 64 2147483647 Sets the maximum memory to be used for query workspaces. Resource Usage / Memory user kB configuration file 4096
xmlbinary base64 Sets how binary values are to be encoded in XML. Client Connection Defaults / Statement Behavior user default base64
xmloption content Sets whether XML data in implicit parsing and serialization operations is to be considered as documents or content fragments. Client Connection Defaults / Statement Behavior user default content
zero_damaged_pages off Continues processing past damaged page headers. Developer Options superuser default off

HBA file





Autoconf file






LOG files (latest 20 files and last messages)



 log_files | log_total_size 
-----------+----------------
        20 | 830 kB

                                                       name                                                        |  size  |      modification      
-------------------------------------------------------------------------------------------------------------------+--------+------------------------
 dogfish.helper.INFO                                                                                               | 102250 | 2024-10-07 15:54:27+00
 dogfish.helper.x012-primary-instance-2c9d73da-ft9v.postgres.log.INFO.20241007-123835.3876                         | 102250 | 2024-10-07 15:54:27+00
 postgres.internal                                                                                                 | 333398 | 2024-10-07 15:54:02+00
 dogfish.helper.WARNING                                                                                            |   8800 | 2024-10-07 15:49:36+00
 dogfish.helper.x012-primary-instance-2c9d73da-ft9v.postgres.log.WARNING.20241007-123835.3876                      |   8800 | 2024-10-07 15:49:36+00
 dogfish.helper.x012-primary-instance-2c9d73da-ft9v.postgres.log.ERROR.20241007-123838.3876                        |   1241 | 2024-10-07 12:38:38+00
 dogfish.helper.ERROR                                                                                              |   1241 | 2024-10-07 12:38:38+00
 write-postmaster-startup-state.x012-primary-instance-2c9d73da-ft9v.postgres.log.WARNING.20241007-123812.3732      |   2216 | 2024-10-07 12:38:14+00
 write-postmaster-startup-state.WARNING                                                                            |   2216 | 2024-10-07 12:38:14+00
 write-postmaster-startup-state.INFO                                                                               |  22195 | 2024-10-07 12:38:14+00
 write-postmaster-startup-state.x012-primary-instance-2c9d73da-ft9v.postgres.log.INFO.20241007-123812.3732         |  22195 | 2024-10-07 12:38:14+00
 _DELETE.dogfish.helper.x012-primary-instance-7d608433-xm8g.postgres.log.INFO.20241007-121132.4268                 |  22797 | 2024-10-07 12:35:35+00
 dogfish.helper.x012-primary-instance-7d608433-xm8g.postgres.log.WARNING.20241007-121132.4268                      |   4957 | 2024-10-07 12:32:32+00
 dogfish.helper.x012-primary-instance-7d608433-xm8g.postgres.log.ERROR.20241007-121135.4268                        |   1238 | 2024-10-07 12:11:35+00
 write-postmaster-startup-state.x012-primary-instance-7d608433-xm8g.postgres.log.WARNING.20241007-121116.4067      |   2425 | 2024-10-07 12:11:18+00
 _DELETE.write-postmaster-startup-state.x012-primary-instance-7d608433-xm8g.postgres.log.INFO.20241007-121116.4067 |  50483 | 2024-10-07 12:11:18+00
 init-dogfish.WARNING                                                                                              |   2723 | 2024-10-07 12:11:13+00
 init-dogfish.INFO                                                                                                 |  77709 | 2024-10-07 12:11:13+00
 init-dogfish.x012-primary-instance-7d608433-xm8g.postgres.log.INFO.20241007-121109.3885                           |  77709 | 2024-10-07 12:11:13+00
 init-dogfish.x012-primary-instance-7d608433-xm8g.postgres.log.WARNING.20241007-121109.3885                        |   2723 | 2024-10-07 12:11:13+00






WAL files (first 5 and latest 20)


 wal_files | wal_total_size 
-----------+----------------
       124 | 1984 MB

           name           |   size   |      modification      
--------------------------+----------+------------------------
 000000010000000000000001 | 16777216 | 2024-10-07 12:11:40+00
 000000010000000000000002 | 16777216 | 2024-10-07 12:16:40+00
 000000010000000000000003 | 16777216 | 2024-10-07 12:21:40+00
 000000010000000000000004 | 16777216 | 2024-10-07 12:26:40+00
 000000010000000000000005 | 16777216 | 2024-10-07 12:31:40+00
 ...                      |          | 
 000000010000000000000069 | 16777216 | 2024-10-07 14:30:53+00
 00000001000000000000006A | 16777216 | 2024-10-07 14:35:53+00
 00000001000000000000006B | 16777216 | 2024-10-07 14:40:53+00
 00000001000000000000006C | 16777216 | 2024-10-07 14:45:53+00
 00000001000000000000006D | 16777216 | 2024-10-07 14:50:54+00
 00000001000000000000006E | 16777216 | 2024-10-07 14:55:54+00
 00000001000000000000006F | 16777216 | 2024-10-07 15:00:54+00
 000000010000000000000070 | 16777216 | 2024-10-07 15:05:54+00
 000000010000000000000071 | 16777216 | 2024-10-07 15:10:55+00
 000000010000000000000072 | 16777216 | 2024-10-07 15:15:55+00
 000000010000000000000073 | 16777216 | 2024-10-07 15:20:55+00
 000000010000000000000074 | 16777216 | 2024-10-07 15:23:42+00
 000000010000000000000075 | 16777216 | 2024-10-07 15:28:42+00
 000000010000000000000076 | 16777216 | 2024-10-07 15:33:42+00
 000000010000000000000077 | 16777216 | 2024-10-07 15:38:42+00
 000000010000000000000078 | 16777216 | 2024-10-07 15:42:32+00
 000000010000000000000079 | 16777216 | 2024-10-07 15:47:32+00
 00000001000000000000007A | 16777216 | 2024-10-07 15:52:32+00
 00000001000000000000007C | 16777216 | 2024-10-07 15:54:15+00
 00000001000000000000007B | 16777216 | 2024-10-07 15:54:30+00







Optional informations




Buffer cache content detailed information


             relname              | relkind | buffers | buffered | buffers_pct | relation_pct | usage_avg 
----------------------------------+---------+---------+----------+-------------+--------------+-----------
 pgbench_accounts                 | r       |  165645 | 1294 MB  |        10.1 |        100.1 |      3.25
 pgbench_accounts_pkey            | i       |   27422 | 214 MB   |         1.7 |        100.0 |      4.91
 pgbench_history                  | r       |     117 | 936 kB   |         0.0 |        106.4 |      4.90
 pg_toast_2618                    | t       |      76 | 608 kB   |         0.0 |        111.8 |      2.61
 pg_description                   | r       |      53 | 424 kB   |         0.0 |        117.8 |      1.13
 pg_rewrite                       | r       |      43 | 344 kB   |         0.0 |        122.9 |      2.74
 pg_description_o_c_o_index       | i       |      35 | 280 kB   |         0.0 |        109.4 |      1.26
 pg_statistic                     | r       |      34 | 272 kB   |         0.0 |        130.8 |      4.65
 pg_depend_depender_index         | i       |      33 | 264 kB   |         0.0 |        110.0 |      1.94
 pg_depend                        | r       |      30 | 240 kB   |         0.0 |        136.4 |      2.07
 pg_operator                      | r       |      22 | 176 kB   |         0.0 |        157.1 |      3.91
 pg_collation                     | r       |      22 | 176 kB   |         0.0 |        157.1 |      3.95
 pg_depend_reference_index        | i       |      21 | 168 kB   |         0.0 |        116.7 |      2.14
 pgbench_tellers                  | r       |      18 | 144 kB   |         0.0 |        150.0 |      4.33
 sql_features                     | r       |      16 | 128 kB   |         0.0 |        200.0 |      1.00
 pg_amop                          | r       |      15 | 120 kB   |         0.0 |        214.3 |      3.53
 pg_toast_2619                    | t       |      14 | 112 kB   |         0.0 |        233.3 |      3.57
 pgbench_tellers_pkey             | i       |      13 | 104 kB   |         0.0 |        130.0 |      4.08
 pg_amproc                        | r       |      13 | 104 kB   |         0.0 |        260.0 |      3.31
 pgbench_branches                 | r       |      12 | 96 kB    |         0.0 |        200.0 |      4.00
 pg_init_privs                    | r       |      12 | 96 kB    |         0.0 |        300.0 |      1.83
 pg_index                         | r       |      12 | 96 kB    |         0.0 |        300.0 |      3.67
 pg_opclass                       | r       |      11 | 88 kB    |         0.0 |        366.7 |      2.64
 pg_statistic_relid_att_inh_index | i       |      11 | 88 kB    |         0.0 |        137.5 |      3.36
 pg_constraint                    | r       |      11 | 88 kB    |         0.0 |        366.7 |      3.55
 pg_ts_config_map                 | r       |      11 | 88 kB    |         0.0 |        366.7 |      1.00
 pg_opfamily                      | r       |      10 | 80 kB    |         0.0 |        500.0 |      1.00
 pg_aggregate                     | r       |      10 | 80 kB    |         0.0 |        500.0 |      2.70
 pg_conversion                    | r       |      10 | 80 kB    |         0.0 |        500.0 |      1.00
 pg_cast                          | r       |      10 | 80 kB    |         0.0 |        500.0 |      2.70

 buffer_cache_size 
-------------------
 13 GB

 minimal_cache_size_est 
------------------------
 935 MB






Column statistics histograms (can be quite large: enable only on most intresting objects)



      parameter_name       | setting | min_val | max_val | source  
---------------------------+---------+---------+---------+---------
 default_statistics_target | 100     | 1       | 10000   | default

 tab_name | col_name | custom_statistics_target 
----------+----------+--------------------------

 sample |        tab_name         | col_name | avg_width | array_dims |         val          |    freq     | null_frac 
--------+-------------------------+----------+-----------+------------+----------------------+-------------+-----------
      1 | public.pgbench_accounts | abalance |         4 | [1:1]      | 0                    | 1           |         0
      1 | public.pgbench_accounts | aid      |         4 | [1:1]      | -                    | 0           |         0
      1 | public.pgbench_accounts | bid      |         4 | [1:100]    | 5                    | 0.011833333 |         0
      2 | public.pgbench_accounts | bid      |         4 | [1:100]    | 66                   | 0.0117      |         0
      3 | public.pgbench_accounts | bid      |         4 | [1:100]    | 99                   | 0.011566667 |         0
      4 | public.pgbench_accounts | bid      |         4 | [1:100]    | 63                   | 0.011533333 |         0
      5 | public.pgbench_accounts | bid      |         4 | [1:100]    | 79                   | 0.0114      |         0
      6 | public.pgbench_accounts | bid      |         4 | [1:100]    | 82                   | 0.011333333 |         0
      7 | public.pgbench_accounts | bid      |         4 | [1:100]    | 52                   | 0.0112      |         0
      8 | public.pgbench_accounts | bid      |         4 | [1:100]    | 42                   | 0.0112      |         0
      9 | public.pgbench_accounts | bid      |         4 | [1:100]    | 16                   | 0.011166667 |         0
      1 | public.pgbench_accounts | filler   |        85 | [1:1]      |                      | 1           |         0

 statistics_name | tab_name | owner | definition | Ndistinct | Dependencies | MCV 
-----------------+----------+-------+------------+-----------+--------------+-----

 sample | statistics_name | tab_name | col_names | array_dims | val1 | val2 | freq 
--------+-----------------+----------+-----------+------------+------+------+------






Additional PG9.6+ Statistics


 pid | phase | heap_blks_total | heap_blks_scanned | heap_blks_vacuumed | state | wait_event_type | wait_event | query 
-----+-------+-----------------+-------------------+--------------------+-------+-----------------+------------+-------






Additional PG12+ Statistics


 name | size | modification 
------+------+--------------

 schemaname | tablename | statistics_schemaname | statistics_name | statistics_owner | attnames | exprs | kinds | inherited | n_distinct | dependencies | most_common_vals | most_common_val_nulls | most_common_freqs | most_common_base_freqs 
------------+-----------+-----------------------+-----------------+------------------+----------+-------+-------+-----------+------------+--------------+------------------+-----------------------+-------------------+------------------------

  pid  | gss_authenticated | principal | encrypted 
-------+-------------------+-----------+-----------
  7503 | f                 |           | f
 81020 | f                 |           | f
 81031 | f                 |           | f
 81089 | f                 |           | f
  6410 | f                 |           | f
  6409 | f                 |           | f
 81298 | f                 |           | f
 81092 | f                 |           | f
  6822 | f                 |           | f
 79547 | f                 |           | f
 81094 | f                 |           | f
 79691 | f                 |           | f
 81096 | f                 |           | f
 81009 | f                 |           | f
 81098 | f                 |           | f
 81103 | f                 |           | f
 81105 | f                 |           | f
 81107 | f                 |           | f
 81109 | f                 |           | f
 81112 | f                 |           | f
 81114 | f                 |           | f
 81116 | f                 |           | f
 81118 | f                 |           | f
 81120 | f                 |           | f
 81122 | f                 |           | f
 81124 | f                 |           | f
 81129 | f                 |           | f
 81131 | f                 |           | f
 81134 | f                 |           | f
 81136 | f                 |           | f
 81138 | f                 |           | f
 81140 | f                 |           | f
 81142 | f                 |           | f
 81144 | f                 |           | f
 81146 | f                 |           | f
 81148 | f                 |           | f
 81151 | f                 |           | f
 81154 | f                 |           | f
 81158 | f                 |           | f
 81160 | f                 |           | f
 81162 | f                 |           | f
 81167 | f                 |           | f
 81169 | f                 |           | f
 81171 | f                 |           | f
 81174 | f                 |           | f
 81176 | f                 |           | f
 81179 | f                 |           | f
 81183 | f                 |           | f
 81185 | f                 |           | f
 81188 | f                 |           | f
 81191 | f                 |           | f
 81193 | f                 |           | f
 81195 | f                 |           | f
 81197 | f                 |           | f
 81202 | f                 |           | f
 81204 | f                 |           | f
 81206 | f                 |           | f
 81209 | f                 |           | f
 81212 | f                 |           | f
 81214 | f                 |           | f
 81216 | f                 |           | f
 81218 | f                 |           | f
 81220 | f                 |           | f
 81222 | f                 |           | f
 81224 | f                 |           | f
 81229 | f                 |           | f
 81231 | f                 |           | f
 81233 | f                 |           | f
 81238 | f                 |           | f
 81240 | f                 |           | f
 81242 | f                 |           | f
 81244 | f                 |           | f
 81246 | f                 |           | f
 81248 | f                 |           | f






Additional PG13+ Statistics


      name       | blks_zeroed | blks_hit | blks_read | blks_written | blks_exists | flushes | truncates |          stats_reset          
-----------------+-------------+----------+-----------+--------------+-------------+---------+-----------+-------------------------------
 CommitTs        |           0 |        0 |         0 |            0 |           0 |       0 |         0 | 2024-10-07 12:10:55.360272+00
 MultiXactMember |           0 |        0 |         0 |            0 |           0 |       0 |         0 | 2024-10-07 12:10:55.360272+00
 MultiXactOffset |           0 |        0 |         0 |            0 |           0 |       0 |         0 | 2024-10-07 12:10:55.360272+00
 Notify          |           0 |        0 |         0 |            0 |           0 |       0 |         0 | 2024-10-07 12:10:55.360272+00
 Serial          |           0 |        0 |         0 |            0 |           0 |       0 |         0 | 2024-10-07 12:10:55.360272+00
 Subtrans        |           0 |        0 |         0 |            0 |           0 |       0 |         0 | 2024-10-07 12:10:55.360272+00
 Xact            |           0 |        0 |         0 |            0 |           0 |       0 |         0 | 2024-10-07 12:10:55.360272+00
 other           |           0 |        0 |         0 |            0 |           0 |       0 |         0 | 2024-10-07 12:10:55.360272+00

                          name                   |    off     |   size    | allocated_size 
-------------------------------------------------+------------+-----------+----------------
                                                 | 2176912000 | 568259968 |      568259968
 Chill Cache Entry Descriptors                   |  643537664 | 564652032 |      564652032
 Chill Cache Content Lock Guards                 | 1410525056 | 376434608 |      376434688
 -anonymous-                                     |            | 213946624 |      213946624
 Buffer Descriptors                              |   45207808 | 209715200 |      209715200
 Eviction lsn related information                | 1222306048 | 188217376 |      188217472
 Chill Cache LRU Next                            |  455320320 |  94108672 |       94108672
 Chill Cache LRU Prev                            |  549428992 |  94108672 |       94108672
 dogfish_lsn_blockmap_entries                    | 1989748480 |  91749560 |       91749632
 Checkpointer Data                               |  412503424 |  39321664 |       39321728
 Google Global Wait Info                         | 1826961152 |  38075706 |       38075776
 log_replay                                      | 2143206656 |  33705232 |       33705344
 XLOG Ctl                                        |     357248 |  33629920 |       33629952
 WalBufferObject                                 | 2081505024 |  27263144 |       27263232
 Buffer IO Condition Variables                   |  254929664 |  26214400 |       26214400
 relation_tail_blocks_storage                    | 1931111424 |  26000000 |       26000000
 BtreeGC MPSC Queue                              | 1786960384 |  20000016 |       20000128
 BtreeGC Flushed buffers Queue                   | 1806960512 |  20000004 |       20000128
 Dogfish ClientControlBlock                      | 1957111424 |  19529728 |       19529728
 dogfish_lsn_blockmap_buckets                    | 1976641408 |  13107072 |       13107072
 Chill Cache Hash Bucket Headers                 | 1209758208 |  12547816 |       12547840
 Job Scheduler                                   | 2108784256 |  10485856 |       10485888
 Google vacuum info                              | 1865041920 |   5079320 |        5079424
 CommitTs                                        |   42565248 |   2147424 |        2147456
 Xact_2                                          |   38298368 |   2125312 |        2125312
 Xact_1                                          |   36164864 |   2125312 |        2125312
 Xact_0                                          |   34031360 |   2125312 |        2125312
 Xact_3                                          |   40431872 |   2125312 |        2125312
 Chill Cache Hash Bucket Spinlocks               | 1208189696 |   1568477 |        1568512
 Backend Activity Buffer                         |  410498816 |   1219584 |        1219584
 google_insights_trace_buffer                    | 2139451136 |   1048576 |        1048576
 replay_prefetcher                               | 2142548608 |    657992 |         658048
 Backend Status Array                            |  409784064 |    562152 |         562176
 g_stats                                         | 2119270144 |    421664 |         421760
 Backend SSL Status Buffer                       |  411718400 |    385884 |         385920
 KnownAssignedXids                               |  409399808 |    307320 |         307328
 Subtrans                                        |   44712832 |    272992 |         273024
 Shared Memory Stats                             |  452031744 |    263328 |         263424
 MultiXactMember                                 |   45058688 |    139520 |         139520
 Serial                                          |  400557824 |    139520 |         139520
 ProcSignal                                      |  412388992 |    114344 |         114432
 shmInvalBuffer                                  |  412275968 |    103392 |         103424
 google_insights_per_backend_statements_counts   | 2140500608 |     85104 |          85120
 Registered Bg Worker Data                       |  412198144 |     77824 |          77824
 KnownAssignedXidsValid                          |  409707136 |     76830 |          76928
 Backend Application Name Buffer                 |  410346240 |     76224 |          76288
 Backend Client Host Name Buffer                 |  410422528 |     76224 |          76288
 MultiXactOffset                                 |   44985856 |     72800 |          72832
 Notify                                          |  451958912 |     72800 |          72832
 Wal Sender Ctl                                  |  451847424 |     69280 |          69376
 Shared Buffer Lookup Table                      |  281144064 |     66384 |          66432
 Google Init Lux Reserve Buffer                  |  455254400 |     65536 |          65536
 Google Lux XLOG Ctl                             |   33987712 |     42080 |          42112
 Background Worker Data                          |  412161664 |     36368 |          36480
 dogfish_num_blocks_cache_table                  | 1870121728 |     33616 |          33664
 dogfish_db_num_blocks_table                     | 1928875648 |     33616 |          33664
 Async Queue Control                             |  451935104 |     23692 |          23808
 Query Instance Unique Id Buffer                 |  412142464 |     19056 |          19072
 Backend Unique Id Buffer                        |  412104320 |     19056 |          19072
 Transaction Unique Id Buffer                    |  412123392 |     19056 |          19072
 BTree Vacuum State                              |  451920128 |     14196 |          14208
 ReplicationSlot Ctl                             |  451830912 |     13600 |          13696
 google_db_advisor_report                        | 2119692672 |     12000 |          12032
 Shared MultiXact State                          |   45198208 |      9508 |           9600
 Google Process Control Semaphore Pool           |  455243264 |      9520 |           9600
 PMSignalState                                   |  412379392 |      9504 |           9600
 PREDICATELOCK hash                              |  382220928 |      9040 |           9088
 PROCLOCK hash                                   |  370418432 |      9040 |           9088
 Dynamic Shared Tracking                         |  254923136 |      6400 |           6400
 AutoVacuum Data                                 |  451825152 |      5704 |           5760
 PREDICATELOCKTARGET hash                        |  377534208 |      4944 |           4992
 LOCK hash                                       |  363532160 |      4944 |           4992
 google_db_advisor hash                          | 2119704704 |      4944 |           4992
 Proc Array                                      |  409394944 |      4768 |           4864
 Google DBG info                                 | 1865037056 |      4768 |           4864
 Fast Path Strong Relation Lock Data             |  377529984 |      4100 |           4224
 DogfishWALProgress                              | 2081500928 |      4088 |           4096
 Xact_3_hash                                     |   42557184 |      2896 |           2944
 Report V2 error reason counts                   | 2108777600 |      2896 |           2944
 AlloyDB IAM login error reason counts           | 2108770304 |      2896 |           2944
 google_insights_tag_stats_hash_table            | 2136502656 |      2896 |           2944
 SERIALIZABLEXID hash                            |  397208448 |      2896 |           2944
 Xact_0_hash                                     |   36156672 |      2896 |           2944
 Password validation validation error reason cou | 2127958912 |      2896 |           2944
 Google ProcCtrl HashTable                       |  452295296 |      2896 |           2944
 pg_stat_statements hash                         | 2140600064 |      2896 |           2944
 google_insights_aggregated_stats_hash_table     | 2127965568 |      2896 |           2944
 google_insights_aggregate_per_database_statemen | 2140585728 |      2896 |           2944
 google_insights_query_stats_hash_table          | 2129594112 |      2896 |           2944
 Xact_2_hash                                     |   40423680 |      2896 |           2944
 Xact_1_hash                                     |   38290176 |      2896 |           2944
 ReplicationOriginState                          |  451844608 |      2808 |           2816
 Wal Receiver Ctl                                |  451916800 |      2544 |           2560
 Eviction lsn window                             | 1410523520 |      1472 |           1536
 DogfishArchiverCheckpoint                       | 2108768512 |       912 |           1024
 Global AlloyDB Stat counters                    |  455252864 |       936 |           1024
 dogfish_shard_read_lsns                         | 2081498112 |       800 |            896
 dogfish_startup_shard_read_lsns                 | 2081499008 |       800 |            896
 Sync Scan Locations List                        |  451934336 |       656 |            768
 google_db_advisor                               | 2119691904 |       712 |            768
 AlloyDB IAM login metrics                       | 2108769664 |       568 |            640
 Password validation validation metrics          | 2127958272 |       568 |            640
 Report V2 metrics                               | 2108776960 |       568 |            640
 lux_read_or_prefetch_stats                      | 2081500032 |       600 |            640
 Logical Replication Launcher Data               |  451919488 |       456 |            512
 Partitioned CLOG LWLocks                        |   34030592 |       512 |            512
 Global AlloyDB Striped Stat counters            |  455253888 |       512 |            512
 SLRU covering partitions of CLOG                |   34030208 |       384 |            384
 Proc Header                                     |  400697472 |       328 |            384
 google_insights_internal_metrics                | 2140499840 |       312 |            384
 Control File                                    |   33987200 |       296 |            384
 should_write_to_dogfish_notification            | 2108768256 |       232 |            256
 dogfish_lsn_blockmap_structure                  | 1976641152 |       144 |            256
 google_insights_extension_latency_counts        | 2140599680 |       136 |            256
 Chill Cache Prewarm Checkpoint Statistics       | 1786959872 |       176 |            256
 LuxVacuumCtlData                                | 1826960896 |       152 |            256
 google_insights_statements_counts_start_time    | 2140500480 |         8 |            128
 Prepared Transaction Table                      |  412161536 |        16 |            128
 dogfish_low_watermark_lsn                       | 2081499904 |        20 |            128
 Google system CPU info                          | 1865036928 |        16 |            128
 Last Checkpoint Tracker                         |   33987584 |        56 |            128
 CommitTs shared                                 |   44712704 |        32 |            128
 LuxFlashbackCtlData                             | 1786960128 |        48 |            128
 google_xact_slru_lock_2                         |   38298240 |       128 |            128
 OldSnapshotControlData                          |  451920000 |        68 |            128
 DogfishWhiteboxHooksSingleton                   | 2081500672 |        64 |            128
 Dynamic Shared Lock                             |  254923008 |       128 |            128
 relation_tail_blocks                            | 1931111296 |        24 |            128
 XLogPrefetchStats                               |   34029824 |        72 |            128
 google_xact_slru_lock_1                         |   36164736 |       128 |            128
 Chill Cache Prewarmer stats                     | 1786959744 |        72 |            128
 Google ProcCtrl FrameWork                       |  452295168 |        40 |            128
 google_insights_total_statements_counts         | 2140599552 |        64 |            128
 lux_storage_quota                               | 2081500800 |        32 |            128
 google_xact_slru_lock_3                         |   40431744 |       128 |            128
 Google Shared Diagnostics Structures            | 1786960256 |        32 |            128
 google parallel thread control data             | 1826960768 |         8 |            128
 lux_num_blocks_cache                            | 1870121600 |        48 |            128
 Chill Cache Size Params                         |  455320064 |        32 |            128
 PredXactList                                    |  395222528 |        88 |            128
 Partitioned CLOG                                |   34030080 |        48 |            128
 pg_stat_statements                              | 2140599936 |        64 |            128
 Google Postmaster Statistics                    |  455319936 |        32 |            128
 google_insights_query_plan_internal_metrics     | 2140500224 |        56 |            128
 FinishedSerializableTransactions                |  400557696 |        16 |            128
 google_insights_query_statistics                | 2140500352 |        16 |            128
 Names of CLOG PartitionLocks                    |   34031104 |        32 |            128
 Buffer Strategy Status                          |  363531904 |        40 |            128
 SerialControlData                               |  400697344 |        12 |            128
 Dynamic Shared Active Buffers                   |  254929536 |         8 |            128
 GoogleBatchExtendInfoData                       | 1826960640 |         8 |            128
 Archiver Data                                   |  451919360 |         8 |            128
 XLOG Recovery Ctl                               |   34029952 |       104 |            128
 google_xact_slru_lock_0                         |   34031232 |       128 |            128
 google_insights_query_plan_sampler              | 2140499712 |        48 |            128
 Chill Cache LRU                                 |  455320192 |        32 |            128
 AlloyDBG Shared Memory                          | 2108769536 |        16 |            128
 RWConflictPool                                  |  397720704 |        24 |            128
 BufferSync statistics                           |  363532032 |        24 |            128






Additional PG14+ Statistics


 pid | datname | command | phase | total | done 
-----+---------+---------+-------+-------+------

 wal_records | wal_fpi | wal_bytes  | wal_buffers_full | wal_write | wal_sync | wal_write_time | wal_sync_time |          stats_reset          | wal_hour 
-------------+---------+------------+------------------+-----------+----------+----------------+---------------+-------------------------------+----------
     1919686 |   31987 | 1436557168 |                0 |      1601 |      203 |              0 |             0 | 2024-10-07 12:10:55.360272+00 | 368 MB

        name        |         ident         |       parent       | level | total_bytes | total_nblocks | free_bytes | free_chunks | used_bytes 
--------------------+-----------------------+--------------------+-------+-------------+---------------+------------+-------------+------------
 CacheMemoryContext |                       | TopMemoryContext   |     1 |     4210744 |            11 |    1891152 |           2 |    2319592
 TopMemoryContext   |                       |                    |     0 |      357504 |            11 |      20376 |          33 |     337128
 relation rules     | columns               | CacheMemoryContext |     2 |      238016 |            38 |       9216 |           3 |     228800
 Timezones          |                       | TopMemoryContext   |     1 |      104120 |             2 |       2616 |           0 |     101504
 relation rules     | pg_stats_ext          | CacheMemoryContext |     2 |       98304 |            15 |       3024 |           0 |      95280
 relation rules     | pg_statio_all_tables  | CacheMemoryContext |     2 |       90112 |            14 |       5064 |           2 |      85048
 relation rules     | pg_stats              | CacheMemoryContext |     2 |       90112 |            14 |       6088 |           2 |      84024
 relation rules     | pg_indexes            | CacheMemoryContext |     2 |       81920 |            13 |       3128 |           2 |      78792
 relation rules     | pg_stat_all_indexes   | CacheMemoryContext |     2 |       65536 |            11 |       4616 |           2 |      60920
 relation rules     | pg_statio_all_indexes | CacheMemoryContext |     2 |       65536 |            11 |       4696 |           2 |      60840

 slot_name | spill_txns | spill_count | spill_bytes | stream_txns | stream_count | stream_bytes | total_txns | total_bytes | stats_reset 
-----------+------------+-------------+-------------+-------------+--------------+--------------+------------+-------------+-------------

 dealloc |          stats_reset          
---------+-------------------------------
       0 | 2024-10-07 12:38:35.714951+00

 schemaname | tablename | statistics_schemaname | statistics_name | statistics_owner | expr | inherited | null_frac | avg_width | n_distinct | most_common_vals | most_common_freqs | histogram_bounds | correlation | most_common_elems | most_common_elem_freqs | elem_count_histogram 
------------+-----------+-----------------------+-----------------+------------------+------+-----------+-----------+-----------+------------+------------------+-------------------+------------------+-------------+-------------------+------------------------+----------------------






Additional PG15+ Statistics


 oid | parname | paracl 
-----+---------+--------







Google Cloud SQL


                         google_parameter_name                          | setting | unit | min_val |  max_val   |  context   |                                                                                   short_desc                                                                                   |       source       
------------------------------------------------------------------------+---------+------+---------+------------+------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------
 enable_google_adaptive_autovacuum                                      | on      |      |         |            | sighup     | Enable google adaptive autovacuum.                                                                                                                                             | default
 enable_google_adaptive_autovacuum_delay_by_system_usage                | on      |      |         |            | sighup     | Enable google adaptive autovacuum delay by real time system usage.                                                                                                             | default
 google_auto_hints.enabled                                              | off     |      |         |            | postmaster | Enable google auto_hints.                                                                                                                                                      | default
 google_columnar_engine.adaptive_auto_refresh_schedule                  |         |      |         |            | sighup     | The schedule for adaptive auto refresh                                                                                                                                         | default
 google_columnar_engine.auto_columnarization_schedule                   |         |      |         |            | sighup     | The schedule for auto columnarization                                                                                                                                          | default
 google_columnar_engine.columnar_hash_joins_cost_factor                 | 100     |      | 1       | 10000      | user       | Factor by which cost of disfavored paths will be multiplied by, when google_columnar_engine.force_group_columnar_hash_joins is enabled.                                        | default
 google_columnar_engine.enable_aggregate_distinct_in_aggregate_pushdown | off     |      |         |            | user       | Indicates whether to do SELECT AggFunc(DISTINCT) optimizations in aggregate pushdown.                                                                                          | default
 google_columnar_engine.enable_auto_columnarization                     | on      |      |         |            | sighup     | Enable auto columnarization                                                                                                                                                    | default
 google_columnar_engine.enable_auto_columnarization_local_storage_spill | off     |      |         |            | sighup     | Enable auto columnarization with local storage spill                                                                                                                           | default
 google_columnar_engine.enable_auto_cu_selection                        | off     |      |         |            | user       | Indicates whether auto CU selection is enabled.                                                                                                                                | default
 google_columnar_engine.enable_columnar_scan                            | on      |      |         |            | user       | Sets whether to enable columnar scan (for session).                                                                                                                            | default
 google_columnar_engine.enable_hashed_inlist                            | off     |      |         |            | user       | Indicates whether hashed INLISTs are enabled.                                                                                                                                  | default
 google_columnar_engine.enable_materialized_view                        | on      |      |         |            | user       | Indicates whether materialized view can be loaded into columnar engine.                                                                                                        | default
 google_columnar_engine.enable_select_distinct_in_aggregate_pushdown    | on      |      |         |            | user       | Indicates whether to do SELECT DISTINCT optimizations in aggregate pushdown.                                                                                                   | default
 google_columnar_engine.enable_timestamptz_date                         | on      |      |         |            | user       | Sets whether to enable columnar scan for timestamptz_date                                                                                                                      | default
 google_columnar_engine.enable_vectorized_join                          | off     |      |         |            | user       | Sets whether to enable joins using vectorized method                                                                                                                           | default
 google_columnar_engine.enable_vectorized_join_on_storage               | off     |      |         |            | user       | Sets whether to enable vectorized joins if the columns are in storage                                                                                                          | default
 google_columnar_engine.enabled                                         | off     |      |         |            | postmaster | Enable google columnar engine.                                                                                                                                                 | default
 google_columnar_engine.enforce_new_defaults                            | off     |      |         |            | postmaster | Enforce new defaults for columnar engine.                                                                                                                                      | default
 google_columnar_engine.heap_fragmentation_max_percentage               | 1       |      | 0       | 100        | sighup     | Expected fragmentation in the heap                                                                                                                                             | default
 google_columnar_engine.ipc_reduction_ratio_for_vec_join                | 0.8     |      | 0.1     | 1          | user       | Sets the planner's ipc cost reduction ratio for vectorized join                                                                                                                | default
 google_columnar_engine.memory_size_in_mb                               | 4800    |      | 128     | 2147483647 | postmaster | Sets the size (in MB) of the shared memory for columnar engine.                                                                                                                | configuration file
 google_columnar_engine.parallel_distinct_aggregate_pushdown_threshold  | 1       |      | 0       | 100        | user       | Threshold for doing parallel SELECT AggFunc(DISTINCT) optimizations.                                                                                                           | default
 google_columnar_engine.populate_detoasted_max_bytes                    | 64      |      | 16      | 2147483647 | sighup     | Column values are stored detoasted up to given max bytes per column                                                                                                            | default
 google_columnar_engine.refresh_threshold_percentage                    | 50      |      | -1      | 100        | sighup     | Threshold on invalid blocks percentage for refreshing the columnar unit                                                                                                        | default
 google_columnar_engine.refresh_threshold_scan_count                    | 5       |      | 0       | 2147483647 | sighup     | Threshold on scan count without interleaving DMLs for refreshing the columnar unit                                                                                             | default
 google_columnar_engine.refresh_threshold_scan_count_by_costing         | 20      |      | 0       | 2147483647 | sighup     | Threshold on scan count without interleaving DMLs for refreshing the columnar unit                                                                                             | default
 google_columnar_engine.relations                                       |         |      |         |            | sighup     | Tables which need to be present in the columnar cache.                                                                                                                         | default
 google_columnar_engine.scan_mode                                       | 0       |      | 0       | 2          | user       | Scan Mode (0:Voxel, 1:Native, 2:RowStore)                                                                                                                                      | default
 google_columnar_engine.vacuum_materialized_view_before_population      | on      |      |         |            | user       | Vacuum materialized view before repopulate on primary if the mv is in columnar engine.                                                                                         | default
 google_db_advisor.auto_advisor_max_time_in_seconds_per_day             | 1800    |      | 0       | 86400      | sighup     | The maximum amount of time in seconds auto advisor spends per day.                                                                                                             | default
 google_db_advisor.auto_advisor_schedule                                |         |      |         |            | sighup     | The schedule to run database advisor automatically                                                                                                                             | default
 google_db_advisor.auto_ce_cpu_available_min_threshold                  | -1      |      | -1      | 100        | sighup     | The minimum available CPU percentage to enable CE by default.                                                                                                                  | default
 google_db_advisor.auto_ce_enabled                                      | off     |      |         |            | sighup     | Sets whether to enable auto CE.                                                                                                                                                | default
 google_db_advisor.auto_ce_max_ce_memory_percent                        | -1      |      | -1      | 100        | sighup     | The maximum percent of DRAM allocated to columnar engine when CE is enabled by default.                                                                                        | default
 google_db_advisor.auto_ce_max_ce_ssd_percent                           | -1      |      | -1      | 100        | sighup     | The maximum percentage of SSD allocated to columnar engine when CE is enabled by default.                                                                                      | default
 google_db_advisor.auto_ce_memory_available_min_threshold               | -1      |      | -1      | 100        | sighup     | The minimum available memory percentage to enable CE by default.                                                                                                               | default
 google_db_advisor.auto_ce_ssd_available_min_threshold                  | -1      |      | -1      | 100        | sighup     | The minimum available SSD percentage to enable CE by default.                                                                                                                  | default
 google_db_advisor.enable_auto_advisor                                  | on      |      |         |            | sighup     | Sets whether to enable running database advisor automatically based on the schedule specified by google_db_advisor.auto_advisor_schedule.                                      | default
 google_db_advisor.enabled                                              | on      |      |         |            | sighup     | Enable google db advisor.                                                                                                                                                      | default
 google_db_advisor.max_index_width                                      | 2       |      | 1       | 2147483647 | user       | Index advisor will recommend indexes that contain at most the specified number of columns.                                                                                     | default
 google_db_advisor.max_num_indexable_columns                            | 1000    |      | 1       | 2147483647 | user       | The maximum number of indexable columns that index advisor will consider to recommend indexes.                                                                                 | default
 google_db_advisor.max_statement_length                                 | 102400  |      | 0       | 2147483647 | user       | The maximum length of a statement that is captured.                                                                                                                            | default
 google_db_advisor.max_storage_size_in_mb                               | 0       |      | 0       | 2147483647 | user       | Index advisor will recommend indexes with their total size less than the specified max storage size.                                                                           | default
 google_db_advisor.recommend_indexes_on_partitions                      | off     |      |         |            | user       | Sets whether to enable recommending indexes on individual table partitions.                                                                                                    | default
 google_db_advisor.recommendation_max_time_in_seconds                   | 600     |      | 0       | 2147483647 | user       | The maximum time in seconds to recommend indexes for a database.                                                                                                               | default
 google_db_advisor.top_k_slowest_statements                             | 100     |      | 1       | 2147483647 | user       | Index advisor will recommend indexes for the top-K slowest statements.                                                                                                         | default
 google_db_advisor.workload_advisory_max_file_size                      | 1048576 |      | 0       | 2147483647 | sighup     | The maximum file size in bytes for the workload advisory file.                                                                                                                 | default
 google_insights.allocate_memory                                        | on      |      |         |            | postmaster | Sets whether to allcoate memory for the extension.                                                                                                                             | default
 google_insights.allocate_memory_active_queries                         | off     |      |         |            | postmaster | Sets whether to allocate memory for active query data.                                                                                                                         | default
 google_insights.enabled                                                | on      |      |         |            | superuser  | Sets whether to enable the extension.                                                                                                                                          | configuration file
 google_insights.max_active_query_entry_read_attempt                    | 256     |      | 0       | 4096       | superuser  | Sets the maximum number of attempts to read active query backend entry.                                                                                                        | default
 google_insights.max_active_query_length                                | 127     |      | 63      | 4095       | postmaster | Sets the maximum size of active query string length.                                                                                                                           | default
 google_insights.max_aggregated_stats_entry                             | 5000    |      | 10      | 10000      | postmaster | Sets the maximum number of entries for aggregated stats recording.                                                                                                             | default
 google_insights.max_per_database_statements_counts                     | 100     |      | 10      | 500        | postmaster | Sets the maximum number of databases for which statements counts will be tracked                                                                                               | default
 google_insights.max_query_length                                       | 1024    |      | 256     | 4500       | postmaster | Sets the length of the query recorded                                                                                                                                          | default
 google_insights.max_query_stats_entry                                  | 5000    |      | 10      | 10000      | postmaster | Sets the maximum number of entries for top N query stats recording.                                                                                                            | default
 google_insights.max_tag_stats_entry                                    | 5000    |      | 10      | 10000      | postmaster | Sets the maximum number of entries for top N tag stats recording.                                                                                                              | default
 google_insights.num_query_plans_per_minute                             | 5       |      | 0       | 20         | superuser  | Sets the number of execution plans to sample per minute for all connections.                                                                                                   | configuration file
 google_insights.num_trace_context_query_plans_per_minute               | 5       |      | 0       | 100        | superuser  | Sets the number of execution plans for trace context to sample per minute for all connections.                                                                                 | default
 google_insights.skip_acquired_sample_lock                              | on      |      |         |            | superuser  | Sets whether to skip sample lock if its already acquired.                                                                                                                      | default
 google_insights.trace_buffer_size_in_kb                                | 1024    |      | 256     | 4096       | postmaster | Sets the size (in KB) of buffer in shared memory that stores query execution plans.                                                                                            | default
 google_insights.track                                                  | on      |      |         |            | superuser  | Sets whether to enable stats tracking, which can be set on the fly to disable the code path.                                                                                   | configuration file
 google_insights.track_active_queries                                   | off     |      |         |            | superuser  | Sets whether to enable the extension.                                                                                                                                          | default
 google_insights.track_additional_utility_commands                      | on      |      |         |            | superuser  | Sets whether to track additional utility commands.                                                                                                                             | default
 google_insights.track_client_address                                   | off     |      |         |            | superuser  | Sets whether to track client addresses in statistic tables. When they are tracked, the same statement executed by clients from different addresses produces different records. | configuration file
 google_insights.track_comment                                          | off     |      |         |            | superuser  | Sets whether to enable stats recording for tags table.                                                                                                                         | configuration file
 google_insights.track_internal_metrics                                 | on      |      |         |            | superuser  | Sets whether to track internal metrics.                                                                                                                                        | default
 google_insights.track_new_connection_stats                             | off     |      |         |            | superuser  | Sets whether to track new connection count.                                                                                                                                    | default
 google_insights.track_statements_executed_count                        | on      |      |         |            | superuser  | Sets whether to track statements executed count.                                                                                                                               | default
 google_job_scheduler.maintenance_cpu_percentage                        | 20      |      | 0       | 100        | sighup     | Maximum percentage of CPU cores to use for maintenance jobs.                                                                                                                   | default
 google_job_scheduler.max_parallel_workers_per_job                      | 2       |      | 0       | 262143     | user       | Maximum number of parallel processes per job.                                                                                                                                  | default
 google_ml_integration.enable_model_support                             | off     |      |         |            | sighup     | Enable Alloydb AI support for general models.                                                                                                                                  | default
 google_plan_management.enabled                                         | off     |      |         |            | postmaster | Enable google plan management.                                                                                                                                                 | default
 google_stats_collection_enabled                                        | off     |      |         |            | postmaster | Enable database kernel statistics collection.                                                                                                                                  | default

AlloyDB
 user_id | db_id | query_id | init_cost | new_cost | num_calls | total_time | recommended_indexes 
---------+-------+----------+-----------+----------+-----------+------------+---------------------







Statistics generated on: 2024-10-07 15:54:35.283303

More info on
this site

 Copyright: 2024 meob - License: GNU General Public License v3.0

 Sources: https://github.com/meob/db2html/