Cloud SQL for PostgreSQL - pgbench

Table of contents:

Report generated on: 2024-10-08 08:37:41.605093+00 on database: pgbench by user: postgres using: pg2html.sql v.1.0.28b
Software by Meo

Summary
Item Value
Database : pgbench
Version : PostgreSQL 15.8
DB Size: 1547 MB
Work area (MB) : 131
Wal Archiving : always
Memory buffers (MB) : 2674
Started : 2024-10-08 06:28:11.135055+00
Defined Tables : 73
Defined Users/Roles : 7 / 18
Defined Schemata : 2
Databases : 3
Sessions : 58
Sessions (active) : 1
Host IP : 34.17.95.215/32
Port (used): 5432
Port (configured): 5432

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

Version check
Version Supported Recent major release (up to N-2) Recent minor release (up to N-1) Notes
PostgreSQL 15.8 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 cloudsqlsuperuser 7779119 7597 kB
cloudsqladmin 16384 cloudsqladmin 8033071 7845 kB
pgbench 16532 postgres 1590498095 1517 MB
TOTAL (MB) 5 1546 1547 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 cloudsqladmin 4 0 0 0 65 0 0 0 0 0 69 0 4 0 0
pg_catalog cloudsqladmin 64 122 0 0 75 0 0 0 0 0 261 0 64 0 0
pg_toast cloudsqladmin 0 40 0 0 0 0 0 0 40 0 80 0 0 0 0
public postgres 5 4 0 0 3 0 0 0 0 0 12 0 5 0 0
TOTALTOTAL 73 166 0 0 143 0 0 0 40 0 422 0 73 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 cloudsqladmin 11 0 11
pg_catalog cloudsqladmin 3233 0 3233
TOTALTOTAL 3244 0 3244

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 cloudsqladmin 1547 MB
pg_global cloudsqladmin 555 kB

Tablespace Space Usage
Tablespace Table# Tables rows Tables KBytes Indexes KBytes TOAST KBytes Total KBytes
pg_global 11 21 40 296 0 336
62 10,022,469 1,314,584 222,184 544 1,537,312

Space Usage
SchemaOwner Table# Tables rows Tables KBytes Indexes KBytes TOAST KBytes Total KBytes
information_schema cloudsqladmin 4 759 88 0 0 88
pg_catalog cloudsqladmin 64 20,631 2,888 2,720 0 5,608
pg_toast cloudsqladmin 0 0 0 320 544 864
public postgres 5 10,001,100 1,311,648 219,440 0 1,531,088
TOTALTOTAL 73 10,022,488 1,314,624 222,480 544 1,537,648

Internals
Tables# Rows Relpages*8 Total Size Main Fork Free Space Map Visibility Map Initialization Fork
73 10,022,488 1,314,624 1,553,584 1,328,656 1,328 376 0

Vacuum and Analyze
# Tables Last autoVACUUM Last VACUUM Last autoANALYZE Last ANALYZE
5 2024-10-08 08:09:42.152041+00 2024-10-08 08:37:35.567551+00 2024-10-08 08:09:42.222617+00 2024-10-08 06:40:28.100752+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 144622 - 2024-10-08 06:40:27.622117+00 2024-10-08 06:40:28.082072+00
public.pgbench_tellers 1000 0 - 2024-10-08 08:09:42.152041+00 2024-10-08 08:37:35.567551+00 2024-10-08 08:09:42.153482+00 2024-10-08 06:40:27.599064+00
pg_catalog.pg_attribute 113 88 -
public.pgbench_branches 100 0 - 2024-10-08 08:09:42.147111+00 2024-10-08 08:37:35.556117+00 2024-10-08 08:09:42.150735+00 2024-10-08 06:40:27.57974+00
pg_catalog.pg_shdepend 81 7 - 2024-10-08 06:27:22.718699+00 2024-10-08 06:28:26.22243+00 2024-10-08 06:27:22.682553+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_branches 100 98304 96 kB 90112 88 kB 92 %
public.pgbench_tellers 100 73728 72 kB 24576 24 kB 33 %
information_schema.sql_features 100 65536 64 kB 8192 8192 bytes 12 %
pg_catalog.pg_description 100 360448 352 kB 8192 8192 bytes 2 %
Bloated tables (estimated percentage)
Table Fillfactor Table Size HR Size Bloat HR Bloat Bloat%
public.pgbench_branches 100 98304 96 kB 90112 88 kB 92 %
public.pgbench_tellers 100 73728 72 kB 24576 24 kB 33 %
information_schema.sql_features 100 65536 64 kB 8192 8192 bytes 12 %
pg_catalog.pg_description 100 360448 352 kB 8192 8192 bytes 2 %
public.pgbench_accounts 100 1342955520 1281 MB 19070976 18 MB 1 %

Database max age
Database Max XID age % Wraparound
cloudsqladmin 162295 0.01
postgres 162295 0.01
template1 162295 0.01
template0 162295 0.01
pgbench 162295 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
cloudsqladmin true true true -1
cloudsqlagent true true false -1
cloudsqlimportexport true true false -1
cloudsqlobservability true true false -1
cloudsqlreplica true true false -1
cloudsqlsuperuser true true false -1
postgres true true false -1
cloudsqliamgroup false true false -1
cloudsqliamgroupserviceaccount false true false -1
cloudsqliamgroupuser false true false -1
cloudsqliamserviceaccount false true false -1
cloudsqliamuser false true false -1
cloudsqllogical 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_write_all_data false true false -1
pg_write_server_files false true false -1
TOTAL Users 7
TOTAL Roles 18

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  cloudsqladmin  cloudsqladmin

Database  postgres  cloudsqlsuperuser

Schema  information_schema  cloudsqladmin

Schema  pg_catalog  cloudsqladmin

Schema  pg_toast  cloudsqladmin

Schema  public  pg_database_owner




Granted Roles


Grantee Admin Option Granted Roles

 cloudsqlagent  f  cloudsqlsuperuser

 cloudsqlimportexport  f  cloudsqlsuperuser

 cloudsqllogical  f  cloudsqlsuperuser

 cloudsqlobservability  f  pg_monitor

 cloudsqlreplica  f  pg_monitor

 cloudsqlsuperuser  f  pg_monitor, pg_signal_backend

 cloudsqlsuperuser  t  pg_checkpoint

 pg_monitor  f  pg_read_all_settings, pg_read_all_stats, pg_stat_scan_tables




Grants on Objects


Grantee Schema Count Privileges

 PUBLIC  public  2  SELECT

Per-User Sessions
User Database Count Active Idle TX
postgres pgbench 65 8 56
5 0 0
cloudsqladmin cloudsqladmin 2 0 0
cloudsqladmin postgres 1 0 0
cloudsqladmin 1 0 0
TOTAL ( 2 distinct users)74 1 63
Per-Host Sessions
Host Database Count Active Idle TX
93.39.69.269 pgbench 65 6 32
6 0 0
127.0.0.1 cloudsqladmin 2 0 0
postgres 1 0 0
TOTAL ( 2 distinct clients)74 5 52
Per-APP Sessions
APP Database Count Active Idle TX
pgbench pgbench 64 4 52
6 0 0
cloudsqlagent cloudsqladmin 2 0 0
pg_cron scheduler postgres 1 0 0
psql pgbench 1 1 0
TOTAL ( 5 distinct applications)74 4 48

Sessions
Pid Database User Address Session start State Query start Duration Backend Application Query
4811 pgbench postgres 93.39.69.269 2024-10-08 08:37:39 active 2024-10-08 08:37:44.621968+00 00:00:00.091636 client backend pgbench UPDATE pgbench_branches SET bbalance = bbalance + 3330 WHERE bid = 21;
4851 pgbench postgres 93.39.69.269 2024-10-08 08:37:42 active 2024-10-08 08:37:44.654402+00 00:00:00.059202 client backend pgbench UPDATE pgbench_branches SET bbalance = bbalance + -2594 WHERE bid = 66;
4795 pgbench postgres 93.39.69.269 2024-10-08 08:37:38 active 2024-10-08 08:37:44.713974+00 -00:00:00.00037 client backend pgbench END;
4781 pgbench postgres 93.39.69.269 2024-10-08 08:37:37 active 2024-10-08 08:37:44.714584+00 -00:00:00.00098 client backend pgbench UPDATE pgbench_accounts SET abalance = abalance + -3884 WHERE aid = 3340333;
4738 cloudsqladmin cloudsqladmin 127.0.0.1 2024-10-08 08:37:27 idle 2024-10-08 08:37:42.407825+00 00:00:02.305779 client backend cloudsqlagent SELECT CAST(ROUND(EXTRACT(EPOCH FROM (current_timestamp - pg_catalog.pg_postmaster_start_time()))) AS BIGINT), pg_catalog.pg_postmaster_start_time(), current_timestamp
28 cloudsqladmin cloudsqladmin 127.0.0.1 2024-10-08 06:28:11 idle 2024-10-08 08:37:44.479317+00 00:00:00.234287 client backend cloudsqlagent ;
4870 pgbench postgres 93.39.69.269 2024-10-08 08:37:43 idle 2024-10-08 08:37:44.585247+00 00:00:00.128357 client backend pgbench END;
4825 pgbench postgres 93.39.69.269 2024-10-08 08:37:40 idle 2024-10-08 08:37:44.618694+00 00:00:00.09491 client backend pgbench END;
4819 pgbench postgres 93.39.69.269 2024-10-08 08:37:40 idle 2024-10-08 08:37:44.621547+00 00:00:00.092057 client backend pgbench END;
4807 pgbench postgres 93.39.69.269 2024-10-08 08:37:39 idle 2024-10-08 08:37:44.642048+00 00:00:00.071556 client backend pgbench END;
4761 pgbench postgres 93.39.69.269 2024-10-08 08:37:36 idle 2024-10-08 08:37:44.642936+00 00:00:00.070668 client backend pgbench END;
4866 pgbench postgres 93.39.69.269 2024-10-08 08:37:43 idle 2024-10-08 08:37:44.642941+00 00:00:00.070663 client backend pgbench END;
4872 pgbench postgres 93.39.69.269 2024-10-08 08:37:43 idle 2024-10-08 08:37:44.648496+00 00:00:00.065108 client backend pgbench END;
4775 pgbench postgres 93.39.69.269 2024-10-08 08:37:37 idle 2024-10-08 08:37:44.648622+00 00:00:00.064982 client backend pgbench END;
4847 pgbench postgres 93.39.69.269 2024-10-08 08:37:41 idle 2024-10-08 08:37:44.649948+00 00:00:00.063656 client backend pgbench END;
4773 pgbench postgres 93.39.69.269 2024-10-08 08:37:37 idle 2024-10-08 08:37:44.711347+00 00:00:00.002257 client backend pgbench END;
4876 pgbench postgres 93.39.69.269 2024-10-08 08:37:44 idle in transaction 2024-10-08 08:37:44.405609+00 00:00:00.307995 client backend pgbench BEGIN;
4777 pgbench postgres 93.39.69.269 2024-10-08 08:37:37 idle in transaction 2024-10-08 08:37:44.585553+00 00:00:00.128051 client backend pgbench SELECT abalance FROM pgbench_accounts WHERE aid = 1074546;
4833 pgbench postgres 93.39.69.269 2024-10-08 08:37:41 idle in transaction 2024-10-08 08:37:44.585848+00 00:00:00.127756 client backend pgbench UPDATE pgbench_branches SET bbalance = bbalance + 2199 WHERE bid = 21;
4785 pgbench postgres 93.39.69.269 2024-10-08 08:37:37 idle in transaction 2024-10-08 08:37:44.586067+00 00:00:00.127537 client backend pgbench UPDATE pgbench_tellers SET tbalance = tbalance + -2577 WHERE tid = 967;
4771 pgbench postgres 93.39.69.269 2024-10-08 08:37:36 idle in transaction 2024-10-08 08:37:44.586808+00 00:00:00.126796 client backend pgbench UPDATE pgbench_branches SET bbalance = bbalance + -3747 WHERE bid = 67;
4831 pgbench postgres 93.39.69.269 2024-10-08 08:37:40 idle in transaction 2024-10-08 08:37:44.587033+00 00:00:00.126571 client backend pgbench INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (612, 46, 7888021, 2249, CURRENT_TIMESTAMP);
4767 pgbench postgres 93.39.69.269 2024-10-08 08:37:36 idle in transaction 2024-10-08 08:37:44.587061+00 00:00:00.126543 client backend pgbench UPDATE pgbench_branches SET bbalance = bbalance + 4663 WHERE bid = 1;
4809 pgbench postgres 93.39.69.269 2024-10-08 08:37:39 idle in transaction 2024-10-08 08:37:44.587244+00 00:00:00.12636 client backend pgbench SELECT abalance FROM pgbench_accounts WHERE aid = 9310345;
4839 pgbench postgres 93.39.69.269 2024-10-08 08:37:41 idle in transaction 2024-10-08 08:37:44.589139+00 00:00:00.124465 client backend pgbench BEGIN;
4813 pgbench postgres 93.39.69.269 2024-10-08 08:37:39 idle in transaction 2024-10-08 08:37:44.589259+00 00:00:00.124345 client backend pgbench UPDATE pgbench_branches SET bbalance = bbalance + -631 WHERE bid = 26;
4779 pgbench postgres 93.39.69.269 2024-10-08 08:37:37 idle in transaction 2024-10-08 08:37:44.617104+00 00:00:00.0965 client backend pgbench SELECT abalance FROM pgbench_accounts WHERE aid = 3063835;
4827 pgbench postgres 93.39.69.269 2024-10-08 08:37:40 idle in transaction 2024-10-08 08:37:44.617473+00 00:00:00.096131 client backend pgbench INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (772, 30, 5117448, 4600, CURRENT_TIMESTAMP);
4757 pgbench postgres 93.39.69.269 2024-10-08 08:37:36 idle in transaction 2024-10-08 08:37:44.618238+00 00:00:00.095366 client backend pgbench UPDATE pgbench_accounts SET abalance = abalance + -1438 WHERE aid = 3884217;
4853 pgbench postgres 93.39.69.269 2024-10-08 08:37:42 idle in transaction 2024-10-08 08:37:44.618575+00 00:00:00.095029 client backend pgbench BEGIN;
4864 pgbench postgres 93.39.69.269 2024-10-08 08:37:43 idle in transaction 2024-10-08 08:37:44.621925+00 00:00:00.091679 client backend pgbench BEGIN;
4862 pgbench postgres 93.39.69.269 2024-10-08 08:37:42 idle in transaction 2024-10-08 08:37:44.622233+00 00:00:00.091371 client backend pgbench INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (355, 53, 6482599, 344, CURRENT_TIMESTAMP);
4799 pgbench postgres 93.39.69.269 2024-10-08 08:37:38 idle in transaction 2024-10-08 08:37:44.622664+00 00:00:00.09094 client backend pgbench SELECT abalance FROM pgbench_accounts WHERE aid = 3496859;
4845 pgbench postgres 93.39.69.269 2024-10-08 08:37:41 idle in transaction 2024-10-08 08:37:44.623066+00 00:00:00.090538 client backend pgbench INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (658, 66, 9596587, -3283, CURRENT_TIMESTAMP);
4815 pgbench postgres 93.39.69.269 2024-10-08 08:37:39 idle in transaction 2024-10-08 08:37:44.645021+00 00:00:00.068583 client backend pgbench SELECT abalance FROM pgbench_accounts WHERE aid = 3629273;
4801 pgbench postgres 93.39.69.269 2024-10-08 08:37:38 idle in transaction 2024-10-08 08:37:44.646413+00 00:00:00.067191 client backend pgbench UPDATE pgbench_accounts SET abalance = abalance + -663 WHERE aid = 2230803;
4753 pgbench postgres 93.39.69.269 2024-10-08 08:37:35 idle in transaction 2024-10-08 08:37:44.649234+00 00:00:00.06437 client backend pgbench UPDATE pgbench_branches SET bbalance = bbalance + 3870 WHERE bid = 57;
4858 pgbench postgres 93.39.69.269 2024-10-08 08:37:42 idle in transaction 2024-10-08 08:37:44.649624+00 00:00:00.06398 client backend pgbench BEGIN;
4829 pgbench postgres 93.39.69.269 2024-10-08 08:37:40 idle in transaction 2024-10-08 08:37:44.649716+00 00:00:00.063888 client backend pgbench BEGIN;
4755 pgbench postgres 93.39.69.269 2024-10-08 08:37:36 idle in transaction 2024-10-08 08:37:44.650468+00 00:00:00.063136 client backend pgbench SELECT abalance FROM pgbench_accounts WHERE aid = 4977506;
4837 pgbench postgres 93.39.69.269 2024-10-08 08:37:41 idle in transaction 2024-10-08 08:37:44.652705+00 00:00:00.060899 client backend pgbench UPDATE pgbench_branches SET bbalance = bbalance + -1001 WHERE bid = 54;
4749 pgbench postgres 93.39.69.269 2024-10-08 08:37:35 idle in transaction 2024-10-08 08:37:44.707486+00 00:00:00.006118 client backend pgbench BEGIN;
4793 pgbench postgres 93.39.69.269 2024-10-08 08:37:38 idle in transaction 2024-10-08 08:37:44.70756+00 00:00:00.006044 client backend pgbench UPDATE pgbench_accounts SET abalance = abalance + 246 WHERE aid = 8291936;
4763 pgbench postgres 93.39.69.269 2024-10-08 08:37:36 idle in transaction 2024-10-08 08:37:44.708103+00 00:00:00.005501 client backend pgbench BEGIN;
4769 pgbench postgres 93.39.69.269 2024-10-08 08:37:36 idle in transaction 2024-10-08 08:37:44.708263+00 00:00:00.005341 client backend pgbench UPDATE pgbench_tellers SET tbalance = tbalance + -419 WHERE tid = 503;
4797 pgbench postgres 93.39.69.269 2024-10-08 08:37:38 idle in transaction 2024-10-08 08:37:44.708509+00 00:00:00.005095 client backend pgbench UPDATE pgbench_branches SET bbalance = bbalance + 3722 WHERE bid = 71;
4817 pgbench postgres 93.39.69.269 2024-10-08 08:37:40 idle in transaction 2024-10-08 08:37:44.708791+00 00:00:00.004813 client backend pgbench SELECT abalance FROM pgbench_accounts WHERE aid = 9742134;
4860 pgbench postgres 93.39.69.269 2024-10-08 08:37:42 idle in transaction 2024-10-08 08:37:44.708799+00 00:00:00.004805 client backend pgbench SELECT abalance FROM pgbench_accounts WHERE aid = 550431;
4841 pgbench postgres 93.39.69.269 2024-10-08 08:37:41 idle in transaction 2024-10-08 08:37:44.710446+00 00:00:00.003158 client backend pgbench UPDATE pgbench_tellers SET tbalance = tbalance + -1406 WHERE tid = 752;
4751 pgbench postgres 93.39.69.269 2024-10-08 08:37:35 idle in transaction 2024-10-08 08:37:44.711169+00 00:00:00.002435 client backend pgbench BEGIN;
4849 pgbench postgres 93.39.69.269 2024-10-08 08:37:42 idle in transaction 2024-10-08 08:37:44.711757+00 00:00:00.001847 client backend pgbench UPDATE pgbench_branches SET bbalance = bbalance + 4822 WHERE bid = 55;
4765 pgbench postgres 93.39.69.269 2024-10-08 08:37:36 idle in transaction 2024-10-08 08:37:44.711973+00 00:00:00.001631 client backend pgbench UPDATE pgbench_branches SET bbalance = bbalance + -3863 WHERE bid = 94;
4789 pgbench postgres 93.39.69.269 2024-10-08 08:37:37 idle in transaction 2024-10-08 08:37:44.711998+00 00:00:00.001606 client backend pgbench INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (328, 49, 5585429, 540, CURRENT_TIMESTAMP);
4823 pgbench postgres 93.39.69.269 2024-10-08 08:37:40 idle in transaction 2024-10-08 08:37:44.712215+00 00:00:00.001389 client backend pgbench SELECT abalance FROM pgbench_accounts WHERE aid = 2248801;
4787 pgbench postgres 93.39.69.269 2024-10-08 08:37:37 idle in transaction 2024-10-08 08:37:44.712255+00 00:00:00.001349 client backend pgbench SELECT abalance FROM pgbench_accounts WHERE aid = 8805074;
4856 pgbench postgres 93.39.69.269 2024-10-08 08:37:42 idle in transaction 2024-10-08 08:37:44.712445+00 00:00:00.001159 client backend pgbench INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (587, 39, 9126759, -3442, CURRENT_TIMESTAMP);
4803 pgbench postgres 93.39.69.269 2024-10-08 08:37:38 idle in transaction 2024-10-08 08:37:44.712539+00 00:00:00.001065 client backend pgbench SELECT abalance FROM pgbench_accounts WHERE aid = 8359622;
4805 pgbench postgres 93.39.69.269 2024-10-08 08:37:39 idle in transaction 2024-10-08 08:37:44.712691+00 00:00:00.000913 client backend pgbench UPDATE pgbench_branches SET bbalance = bbalance + -1678 WHERE bid = 86;
4759 pgbench postgres 93.39.69.269 2024-10-08 08:37:36 idle in transaction 2024-10-08 08:37:44.712725+00 00:00:00.000879 client backend pgbench UPDATE pgbench_branches SET bbalance = bbalance + -366 WHERE bid = 5;
4791 pgbench postgres 93.39.69.269 2024-10-08 08:37:38 idle in transaction 2024-10-08 08:37:44.712924+00 00:00:00.00068 client backend pgbench BEGIN;
4821 pgbench postgres 93.39.69.269 2024-10-08 08:37:40 idle in transaction 2024-10-08 08:37:44.712966+00 00:00:00.000638 client backend pgbench UPDATE pgbench_tellers SET tbalance = tbalance + -3815 WHERE tid = 123;
4835 pgbench postgres 93.39.69.269 2024-10-08 08:37:41 idle in transaction 2024-10-08 08:37:44.713098+00 00:00:00.000506 client backend pgbench UPDATE pgbench_accounts SET abalance = abalance + -2432 WHERE aid = 8054277;
4843 pgbench postgres 93.39.69.269 2024-10-08 08:37:41 idle in transaction 2024-10-08 08:37:44.713527+00 00:00:00.000077 client backend pgbench UPDATE pgbench_branches SET bbalance = bbalance + 2411 WHERE bid = 95;
4874 pgbench postgres 93.39.69.269 2024-10-08 08:37:44 idle in transaction 2024-10-08 08:37:44.713668+00 -00:00:00.000064 client backend pgbench UPDATE pgbench_tellers SET tbalance = tbalance + -1238 WHERE tid = 478;
4868 pgbench postgres 93.39.69.269 2024-10-08 08:37:43 idle in transaction 2024-10-08 08:37:44.714147+00 -00:00:00.000543 client backend pgbench INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (524, 8, 2807503, -2711, CURRENT_TIMESTAMP);
4783 pgbench postgres 93.39.69.269 2024-10-08 08:37:37 idle in transaction 2024-10-08 08:37:44.714515+00 -00:00:00.000911 client backend pgbench BEGIN;
19 2024-10-08 06:28:11 checkpointer
20 2024-10-08 06:28:11 background writer
23 2024-10-08 06:28:11 walwriter
24 2024-10-08 06:28:11 autovacuum launcher
25 2024-10-08 06:28:11 archiver
26 postgres cloudsqladmin 2024-10-08 06:28:11 pg_cron launcher pg_cron scheduler
27 cloudsqladmin 2024-10-08 06:28:11 logical replication launcher

Waiting Locks
Pid Type Database Relation Mode Granted Wait start
4785 transactionid ShareLock f 2024-10-08 08:37:44.80244+00
4823 tuple pgbench pgbench_branches ExclusiveLock f 2024-10-08 08:37:44.802467+00

Blocking Locks
Blocked Pid Blocked User Blocking Pid Blocking User Blocked Statement Blocking Session Current Statement
4847 postgres 4771 postgres UPDATE pgbench_branches SET bbalance = bbalance + 2094 WHERE bid = 35; INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (508, 35, 9304658, 2878, CURRENT_TIMESTAMP);
4823 postgres 4785 postgres UPDATE pgbench_branches SET bbalance = bbalance + -1500 WHERE bid = 66; UPDATE pgbench_branches SET bbalance = bbalance + -2577 WHERE bid = 66;
4789 postgres 4847 postgres UPDATE pgbench_branches SET bbalance = bbalance + 3102 WHERE bid = 35; UPDATE pgbench_branches SET bbalance = bbalance + 2094 WHERE bid = 35;
4787 postgres 4801 postgres UPDATE pgbench_branches SET bbalance = bbalance + 3428 WHERE bid = 85; UPDATE pgbench_branches SET bbalance = bbalance + -663 WHERE bid = 85;

Locks
Pid Type Database Relation Mode Granted
4749 transactionid ShareLock f
4769 transactionid ShareLock f
4777 transactionid ShareLock f
4817 transactionid ShareLock f
4837 transactionid ShareLock f
1022 relation pgbench pg_class_tblspc_relfilenode_index AccessShareLock t
1022 relation pg_database_datname_index AccessShareLock t
1022 relation pgbench pg_class AccessShareLock t
1022 relation pgbench pg_class_relname_nsp_index AccessShareLock t
1022 relation pgbench pg_class_oid_index AccessShareLock t
1022 relation pg_database AccessShareLock t
1022 virtualxid ExclusiveLock t
1022 relation pg_database_oid_index AccessShareLock t
1022 relation pgbench pg_locks AccessShareLock t
4749 relation pgbench pgbench_accounts RowExclusiveLock t
4749 virtualxid ExclusiveLock t
4749 relation pgbench pgbench_accounts_pkey RowExclusiveLock t
4749 relation pgbench pgbench_accounts_pkey AccessShareLock t
4749 relation pgbench pgbench_accounts AccessShareLock t
4749 transactionid ExclusiveLock t
4749 relation pgbench pgbench_tellers RowExclusiveLock t
4749 relation pgbench pgbench_tellers_pkey RowExclusiveLock t
4749 tuple pgbench pgbench_tellers ExclusiveLock t
4751 virtualxid ExclusiveLock t
4751 relation pgbench pgbench_accounts RowExclusiveLock t
4751 relation pgbench pgbench_accounts AccessShareLock t
4751 relation pgbench pgbench_accounts_pkey RowExclusiveLock t
4751 relation pgbench pgbench_accounts_pkey AccessShareLock t
4751 transactionid ExclusiveLock t
4753 relation pgbench pgbench_accounts RowExclusiveLock t
4753 virtualxid ExclusiveLock t
4753 relation pgbench pgbench_history RowExclusiveLock t
4753 relation pgbench pgbench_branches_pkey RowExclusiveLock t
4753 relation pgbench pgbench_accounts_pkey RowExclusiveLock t
4753 relation pgbench pgbench_accounts AccessShareLock t
4753 transactionid ExclusiveLock t
4753 relation pgbench pgbench_accounts_pkey AccessShareLock t
4753 relation pgbench pgbench_branches RowExclusiveLock t
4753 relation pgbench pgbench_tellers_pkey RowExclusiveLock t
4753 relation pgbench pgbench_tellers RowExclusiveLock t
4755 relation pgbench pgbench_accounts_pkey AccessShareLock t
4755 relation pgbench pgbench_accounts_pkey RowExclusiveLock t
4755 transactionid ExclusiveLock t
4755 relation pgbench pgbench_accounts RowExclusiveLock t
4755 virtualxid ExclusiveLock t
4755 relation pgbench pgbench_accounts AccessShareLock t
4757 relation pgbench pgbench_accounts AccessShareLock t
4757 relation pgbench pgbench_accounts RowExclusiveLock t
4757 transactionid ExclusiveLock t
4757 relation pgbench pgbench_accounts_pkey RowExclusiveLock t
...
TOTAL transactionid 2 ShareLock f
TOTAL relation pgbench 83 AccessShareLock t
TOTAL relation pgbench 209 RowExclusiveLock t
TOTAL tuple pgbench 1 ExclusiveLock t
TOTAL relation 3 AccessShareLock t
TOTAL transactionid 49 ExclusiveLock t
TOTAL virtualxid 57 ExclusiveLock t

Memory
Element Value Description
shared_buffers 2650 MB 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 16 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
cloudsqladmin 2 26470 3.38 1 742 780902 99.91 744264 500292 521 1650 0 2024-10-08 06:27:23.955736+00
postgres 1 1058 0.14 0 292 147288 99.80 310996 91686 0 13 0 2024-10-08 06:27:23.995866+00
pgbench 65 163070 22.59 23 486795 4243414 89.71 20546107 685733 10162428 483105 141 2024-10-08 06:37:27.549425+00
TOTAL ( 3 )68 190598 24 487829 5171604 21601367 1277711 10162949 484768 141 2024-10-08 06:27:23.955736+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
25 4 211163 0 0 329508 138615 2384 0 2024-10-08 06:27:15.809995+00

Checkpointer/BGWriter KPI
Timed CP Ratio% Minutes between CP Clean by CP Ratio% Clean by BGW Ratio% BGW Halt Ratio%
86.21 4.50 39.06 0.00 0

Cache statistics
Object Type#Read #Hit Hit Ratio%
Table 459421 2360210 83.70
Index 27365 1639577 98.33

Instance restart: 2024-10-08 06:28:11.135055+00
Statement statistics reset: 2024-10-08 06:27:46.731715+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 161208 0.004 0.668 619140 161208 100.00 13 T
UPDATE pgbench_tellers SET tbalance = tbalance + $1 WHERE tid = $2 postgres 161223 0.001 0.571 136145 161223 100.00 13 T
copy pgbench_accounts from stdin with (freeze on) postgres 1 114.918 114.918 114918 10000000 99.94 1029 T
select count(*) from emp7 emp1, emp7 emp2, emp7 emp3, emp7 emp4, emp7 emp5, emp7 emp6, emp7 emp_7 where emp_7.deptno=$1 postgres 3 12.660 26.422 37980 3 100.00 0 T
UPDATE pgbench_accounts SET abalance = abalance + $1 WHERE aid = $2 postgres 161233 0.000 0.049 23774 161233 91.94 1652 T
alter table pgbench_accounts add primary key (aid) postgres 1 8.494 8.494 8494 0 1.34 194 T
SELECT abalance FROM pgbench_accounts WHERE aid = $1 postgres 161228 0.000 0.010 3513 161228 100.00 0 T
INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES ($1, $2, $3, $4, CURRENT_TIMESTAMP) postgres 161201 0.000 0.011 3066 161201 99.99 13 T
SELECT setting, current_timestamp FROM pg_catalog.pg_settings WHERE name = $1 cloudsqladmin 1356 0.002 0.013 2198 1356 0 T
SELECT d.datname, pg_catalog.pg_database_size(d.datname), current_timestamp FROM pg_catalog.pg_database d ORDER BY d.datname LIMIT $1 cloudsqladmin 260 0.006 0.022 1567 1281 100.00 0 T
BEGIN postgres 161246 0.000 0.018 1118 0 0 T
END postgres 161193 0.000 0.015 1097 0 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) cloudsqladmin 260 0.003 0.027 849 260 0 T
vacuum analyze pgbench_accounts postgres 1 0.467 0.467 467 0 1.58 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) cloudsqladmin 130 0.002 0.016 269 130 0 T
SELECT default_version, installed_version FROM pg_catalog.pg_available_extensions WHERE name = $1 cloudsqladmin 29 0.008 0.062 234 29 93.10 0 T
SELECT pg_catalog.pg_backup_start($1, $2) cloudsqladmin 2 0.112 0.196 223 2 0 T
SELECT COALESCE(SUM(pg_stat_get_live_tuples(c.oid)), $1) AS n_live_tup, COALESCE(SUM(pg_stat_get_dead_tuples(c.oid)), $2) AS n_dead_tup, current_timestamp FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind = ANY (ARRAY[$3::"char", $4::"char", $5::"char", $6::"char"]) AND (n.nspname <> ALL (ARRAY[$7::name, $8::name])) AND n.nspname !~ $9::text cloudsqladmin 260 0.001 0.011 184 260 99.90 0 T
select setting from pg_catalog.pg_settings where name=$1 cloudsqladmin 130 0.001 0.004 143 130 0 T
SELECT EXISTS (SELECT $1 FROM pg_available_extensions WHERE name=$2 and installed_version is not null) as pg_stat_statements, EXISTS (SELECT $3 FROM pg_available_extensions WHERE name=$4 and installed_version is not null) as pg_buffercache, EXISTS (SELECT $5 FROM pg_available_extensions WHERE name=$6 and installed_version is not null) as pgstattuple, EXISTS (SELECT $7 FROM pg_available_extensions WHERE name=$8 and installed_version is not null) as pg_freespacemap, EXISTS (SELECT $9 FROM pg_available_extensions WHERE name=$10 and installed_version is not null) as sslinfo, EXISTS (SELECT $11 FROM pg_stat_ssl WHERE ssl limit $12) as ssl_active, EXISTS (SELECT $13 FROM pg_available_extensions WHERE name=$14 and installed_version is not null) as pgaudit, EXISTS (SELECT $15 FROM pg_available_extensions WHERE name=$16 and installed_version is not null) as pgrowlocks, EXISTS (SELECT $17 FROM pg_available_extensions WHERE name=$18 and installed_version is not null) as postgis, EXISTS (SELECT $19 FROM pg_available_extensions WHERE name=$20 and installed_version is not null) as pgvector, EXISTS (SELECT $21 FROM pg_available_extensions WHERE name=$22 and installed_version is not null) as pgml, EXISTS (SELECT $23 FROM pg_settings WHERE name=$24 and setting::int > $25 ) as xa_active, EXISTS (SELECT $26 FROM pg_available_extensions WHERE name=$27 and installed_version is not null) as anon, EXISTS (SELECT $28 FROM pg_tables WHERE tablename=$29 and schemaname=$30) as pgstatspack, EXISTS (SELECT $31 FROM pg_available_extensions WHERE name=$32) as edb, EXISTS (SELECT $33 FROM pg_available_extensions WHERE name=$34) as amazon_rds, EXISTS (SELECT $35 FROM pg_available_extensions WHERE name=$36 and installed_version is not null) as rds_tools, EXISTS (SELECT $37 FROM pg_available_extensions WHERE name=$38) as aurora, EXISTS (SELECT $39 FROM pg_available_extensions WHERE name=$40 and installed_version is not null) as aurora_stat, EXISTS (SELECT $41 FROM pg_available_extensions WHERE name=$42 and installed_version is not null) as qpm, EXISTS (SELECT $43 FROM pg_settings WHERE name=$44) as cloud_sql, EXISTS (SELECT $45 FROM pg_available_extensions WHERE name=$46) as alloydb, EXISTS (SELECT $47 FROM pg_settings WHERE name=$48 and setting=$49) as alloy_col, EXISTS (SELECT $50 FROM pg_available_extensions WHERE name=$51) as yugabyte postgres 1 0.137 0.137 137 1 100.00 0 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 114.918 114.918 114918 10000000 99.94 1029
select count(*) from emp7 emp1, emp7 emp2, emp7 emp3, emp7 emp4, emp7 emp5, emp7 emp6, emp7 emp_7 where emp_7.deptno=$1 postgres 3 12.660 26.422 37980 3 100.00 0
alter table pgbench_accounts add primary key (aid) postgres 1 8.494 8.494 8494 0 1.34 194
vacuum analyze pgbench_accounts postgres 1 0.467 0.467 467 0 1.58 0
SELECT EXISTS (SELECT $1 FROM pg_available_extensions WHERE name=$2 and installed_version is not null) as pg_stat_statements, EXISTS (SELECT $3 FROM pg_available_extensions WHERE name=$4 and installed_version is not null) as pg_buffercache, EXISTS (SELECT $5 FROM pg_available_extensions WHERE name=$6 and installed_version is not null) as pgstattuple, EXISTS (SELECT $7 FROM pg_available_extensions WHERE name=$8 and installed_version is not null) as pg_freespacemap, EXISTS (SELECT $9 FROM pg_available_extensions WHERE name=$10 and installed_version is not null) as sslinfo, EXISTS (SELECT $11 FROM pg_stat_ssl WHERE ssl limit $12) as ssl_active, EXISTS (SELECT $13 FROM pg_available_extensions WHERE name=$14 and installed_version is not null) as pgaudit, EXISTS (SELECT $15 FROM pg_available_extensions WHERE name=$16 and installed_version is not null) as pgrowlocks, EXISTS (SELECT $17 FROM pg_available_extensions WHERE name=$18 and installed_version is not null) as postgis, EXISTS (SELECT $19 FROM pg_available_extensions WHERE name=$20 and installed_version is not null) as pgvector, EXISTS (SELECT $21 FROM pg_available_extensions WHERE name=$22 and installed_version is not null) as pgml, EXISTS (SELECT $23 FROM pg_settings WHERE name=$24 and setting::int > $25 ) as xa_active, EXISTS (SELECT $26 FROM pg_available_extensions WHERE name=$27 and installed_version is not null) as anon, EXISTS (SELECT $28 FROM pg_tables WHERE tablename=$29 and schemaname=$30) as pgstatspack, EXISTS (SELECT $31 FROM pg_available_extensions WHERE name=$32) as edb, EXISTS (SELECT $33 FROM pg_available_extensions WHERE name=$34) as amazon_rds, EXISTS (SELECT $35 FROM pg_available_extensions WHERE name=$36 and installed_version is not null) as rds_tools, EXISTS (SELECT $37 FROM pg_available_extensions WHERE name=$38) as aurora, EXISTS (SELECT $39 FROM pg_available_extensions WHERE name=$40 and installed_version is not null) as aurora_stat, EXISTS (SELECT $41 FROM pg_available_extensions WHERE name=$42 and installed_version is not null) as qpm, EXISTS (SELECT $43 FROM pg_settings WHERE name=$44) as cloud_sql, EXISTS (SELECT $45 FROM pg_available_extensions WHERE name=$46) as alloydb, EXISTS (SELECT $47 FROM pg_settings WHERE name=$48 and setting=$49) as alloy_col, EXISTS (SELECT $50 FROM pg_available_extensions WHERE name=$51) as yugabyte postgres 1 0.137 0.137 137 1 100.00 0
SELECT pg_catalog.pg_backup_start($1, $2) cloudsqladmin 2 0.112 0.196 223 2 0
SELECT labelfile FROM pg_catalog.pg_backup_stop($1) cloudsqladmin 2 0.039 0.041 78 2 0
create database pgbench postgres 1 0.031 0.031 31 0 16.57 4
CREATE EXTENSION IF NOT EXISTS "cloudsql_stat" SCHEMA "public" cloudsqladmin 1 0.023 0.023 23 0 97.38 0
SELECT $1||schemaname||$2||tblname, $3||fillfactor, $4||bs*tblpages AS real_size, $5||pg_size_pretty(bs*tblpages) as HR_size, $6, CASE WHEN tblpages - est_tblpages_ff > $7 THEN (tblpages-est_tblpages_ff)*bs ELSE $8 END AS bloat_size, $9, CASE WHEN tblpages - est_tblpages_ff > $10 THEN pg_size_pretty( ((tblpages-est_tblpages_ff)*bs)::bigint) ELSE $11 END AS hr_bloat_size, $12, CASE WHEN tblpages > $13 AND tblpages - est_tblpages_ff > $14 THEN round($15*(tblpages - est_tblpages_ff)/tblpages::float) ELSE $16 END, $17 FROM ( SELECT ceil( reltuples / ( (bs-page_hdr)*fillfactor/(tpl_size*$18) ) ) + ceil( toasttuples / $19 ) AS est_tblpages_ff, tblpages, fillfactor, bs, tblid, schemaname, tblname, heappages, toastpages, is_na FROM ( SELECT ( $20 + tpl_hdr_size + tpl_data_size + ($21*ma) - CASE WHEN tpl_hdr_size%ma = $22 THEN ma ELSE tpl_hdr_size%ma END - CASE WHEN ceil(tpl_data_size)::int%ma = $23 THEN ma ELSE ceil(tpl_data_size)::int%ma END ) AS tpl_size, bs - page_hdr AS size_per_block, (heappages + toastpages) AS tblpages, heappages, toastpages, reltuples, toasttuples, bs, page_hdr, tblid, schemaname, tblname, fillfactor, is_na FROM ( SELECT tbl.oid AS tblid, ns.nspname AS schemaname, tbl.relname AS tblname, tbl.reltuples, tbl.relpages AS heappages, coalesce(toast.relpages, $24) AS toastpages, coalesce(toast.reltuples, $25) AS toasttuples, coalesce(substring( array_to_string(tbl.reloptions, $26) FROM $27)::smallint, $28) AS fillfactor, current_setting($29)::numeric AS bs, CASE WHEN version()~$30 OR version()~$31 THEN $32 ELSE $33 END AS ma, $34 AS page_hdr, $35 + CASE WHEN MAX(coalesce(s.null_frac, $36)) > $37 THEN ( $38 + count(s.attname) ) / $39 ELSE $40::int END + CASE WHEN bool_or(att.attname = $41 and att.attnum < $42) THEN $43 ELSE $44 END AS tpl_hdr_size, sum( ($45-coalesce(s.null_frac, $46)) * coalesce(s.avg_width, $47) ) AS tpl_data_size, bool_or(att.atttypid = $48::regtype) OR sum(CASE WHEN att.attnum > $49 THEN $50 ELSE $51 END) <> count(s.attname) AS is_na FROM pg_attribute AS att JOIN pg_class AS tbl ON att.attrelid = tbl.oid JOIN pg_namespace AS ns ON ns.oid = tbl.relnamespace LEFT JOIN pg_stats AS s ON s.schemaname=ns.nspname AND s.tablename = tbl.relname AND s.inherited=$52 AND s.attname=att.attname LEFT JOIN pg_class AS toast ON tbl.reltoastrelid = toast.oid WHERE NOT att.attisdropped AND tbl.relkind in ($53, $54) GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 ORDER BY 2, 3 ) AS s ) AS s2 ) AS s3 where not is_na and tblpages-est_tblpages_ff>$55 ORDER BY 6 desc limit $56 postgres 2 0.020 0.028 40 10 100.00 0

Database Calls DBcpu IOcpu Stmt/sec.
cloudsqladmin 16268 0.00086 0.00000 2.086
pgbench 1131864 0.12200 0.00208 145.112
postgres 522 0.00002 0.00000 0.067
TOTAL 1148713 0.12288 0.00208

Table Statistics (reset: 2024-10-08 06:37:27.549425+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 322572 2 322572 10000000 161286 58049 0 99 35
public pgbench_branches 100 9471900 66573 94719 66574 100 161286 161123 0 41 99
public pgbench_tellers 1000 1000 161286 1 161286 1000 161286 160594 0 99 99
public pgbench_history 748 0 0 0 0 161286 0 0 0 -1 -1
public emp7 14 294 0 22 0 14 0 0 0 0 -1

Tables Caching
SchemaTable Heap Reads Index Reads TOAST Reads Heap Hit Ratio% Index Hit Ratio% TOAST Hit Ratio%
public pgbench_accounts 458337 27357 0 68 97 -1
public pgbench_history 1176 0 0 99 -1 -1
public pgbench_branches 16 2 0 99 99 -1
public pgbench_tellers 13 5 0 99 99 -1
public emp7 1 2 0 97 88 -1 

Tables without Unique Indexes

public.pgbench_history


Tables without Primary Key

public.emp7
public.pgbench_history


Index Usage - Details




Defined indexes

SchemaTypeCount  Primary   Unique   Avg #keys   Max #keys 

 public  btree  4  3  4  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  323302  323302

 public  pgbench_tellers  pgbench_tellers_pkey  40960  161651  161651

 public  pgbench_branches  pgbench_branches_pkey  16384  66939  66938



All indexes

SchemaRelation IndexDDL

 public  emp7  pkemp7  CREATE UNIQUE INDEX pkemp7 ON public.emp7 USING btree (empno)

 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 100 0 1073741823 sighup Background writer maximum number of LRU pages to flush per round. 100 default
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 3180 MB 1 2147483647 8kB user Sets the planner's assumption about the total size of the data caches. 407089 configuration file
fsync on sighup Forces synchronization of updates to disk. on default
max_connections 400 1 262143 postmaster Sets the maximum number of concurrent connections. 400 configuration file
max_wal_size 2048 TB 2 2147483647 MB sighup Sets the WAL size that triggers a checkpoint. 2147483647 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 2650 MB 16 1073741823 8kB postmaster Sets the number of shared memory buffers used by the server. 339200 configuration file
synchronous_commit on user Sets the current transaction's synchronization level. on default
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 16 MB -1 262143 8kB postmaster Sets the number of disk-page buffers in shared memory for WAL. 2048 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 default

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,357,602,816 1509 MB
pgbench_accounts_pkey Index postgres public 10,000,000 224,641,024 224,641,024
pg_proc Table cloudsqladmin pg_catalog 3,244 786,432 786,432 1192 kB
pg_toast_2618 TOAST Table cloudsqladmin pg_toast 287 524,288 532,480
pg_attribute Table cloudsqladmin pg_catalog 3,054 458,752 491,520 728 kB
pg_description Table cloudsqladmin pg_catalog 5,133 360,448 360,448 616 kB
pg_proc_proname_args_nsp_index Index cloudsqladmin pg_catalog 3,244 253,952 253,952
pg_description_o_c_o_index Index cloudsqladmin pg_catalog 5,133 229,376 229,376
pg_collation Table cloudsqladmin pg_catalog 1,390 204,800 204,800 384 kB
pg_statistic Table cloudsqladmin pg_catalog 404 155,648 204,800 336 kB
pg_attribute_relid_attnam_index Index cloudsqladmin pg_catalog 3,054 122,880 131,072
pg_type Table cloudsqladmin pg_catalog 611 122,880 122,880 240 kB
pg_depend Table cloudsqladmin pg_catalog 1,831 114,688 122,880 304 kB
pg_operator Table cloudsqladmin pg_catalog 799 114,688 114,688 232 kB
pg_class Table cloudsqladmin pg_catalog 410 114,688 114,688 232 kB
pg_rewrite Table cloudsqladmin pg_catalog 142 114,688 122,880 752 kB
pg_collation_name_enc_nsp_index Index cloudsqladmin pg_catalog 1,390 98,304 98,304
pgbench_branches Table postgres public 100 98,304 98,304 144 kB
pg_proc_oid_index Index cloudsqladmin pg_catalog 3,244 90,112 90,112
pg_attribute_relid_attnum_index Index cloudsqladmin pg_catalog 3,054 90,112 90,112
pg_depend_depender_index Index cloudsqladmin pg_catalog 1,831 81,920 90,112
pgbench_tellers Table postgres public 1,000 73,728 73,728 144 kB
pg_depend_reference_index Index cloudsqladmin pg_catalog 1,831 65,536 65,536
sql_features Table cloudsqladmin information_schema 714 65,536 65,536 104 kB
pg_amop Table cloudsqladmin pg_catalog 945 57,344 57,344 224 kB
pg_collation_oid_index Index cloudsqladmin pg_catalog 1,390 49,152 49,152
pg_amop_fam_strat_index Index cloudsqladmin pg_catalog 945 49,152 49,152
pg_amop_opr_fam_index Index cloudsqladmin pg_catalog 945 49,152 49,152
pg_operator_oprname_l_r_n_index Index cloudsqladmin pg_catalog 799 49,152 49,152
pgbench_tellers_pkey Index postgres public 1,000 40,960 40,960
pg_amop_oid_index Index cloudsqladmin pg_catalog 945 40,960 40,960
pg_operator_oid_index Index cloudsqladmin pg_catalog 799 40,960 40,960

Largest TOASTs
TOAST Owner Table Chunks Bytes
pg_toast_2618 cloudsqladmin pg_catalog.pg_rewrite 287 532,480
pg_toast_2619 cloudsqladmin pg_catalog.pg_statistic 13 24,576
pg_toast_1255 cloudsqladmin 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
cloudsqladmin Aggregate func. internal 148 2220
cloudsqladmin Function c 89 1273
cloudsqladmin Function internal 2931 44454
cloudsqladmin Function sql 61 502
cloudsqladmin 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 always
archive_timeout 300
Write xlog location 0/CD3C1420
Insert xlog location 0/CD3CF9B8

Archiver Statistics
Archived Count Last Archived WAL Last Archived Time Failed Count Last Failed WAL Last Failed Time Statistics Reset Archiving WALS ps

Replication
In Recovery Mode false
Parameter Value
archive_command /utils/replication_log_processor -disable_log_to_disk -action=archive -file_name=%f -local_file_path=%p -async_archive -remote_storage
archive_mode always
hot_standby on
hot_standby_feedback off
ignore_invalid_pages off
max_slot_wal_keep_size -1
max_standby_archive_delay 30000
max_standby_streaming_delay 30000
max_wal_senders 10
max_wal_size 2147483647
primary_conninfo
primary_slot_name
recovery_target_timeline latest
synchronous_commit on
synchronous_standby_names
vacuum_defer_cleanup_age 0
wal_keep_size 0
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.

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
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.4.0 Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
address_standardizer_data_us 3.4.0 Address Standardizer US dataset example
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.2 Google extension for ML integration
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
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_ivm 1.9 incremental view maintenance on PostgreSQL
pg_partman 5.0.1 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.4 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 4.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.4.0 PostGIS geometry and geography spatial types and functions
postgis_raster 3.4.0 PostGIS raster types and functions
postgis_sfcgal 3.4.0 PostGIS SFCGAL functions
postgis_tiger_geocoder 3.4.0 PostGIS tiger geocoder and reverse geocoder
postgis_topology 3.4.0 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.4 vector data type and ivfflat and hnsw access methods

NLS Settings
Parameter Value Description
lc_collate en_US.UTF8 Shows the collation order locale.
lc_ctype en_US.UTF8 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 cloudsqladmin en_US.UTF8
5 postgres en_US.UTF8
1 template1 en_US.UTF8
4 template0 en_US.UTF8
16532 pgbench en_US.UTF8 

Columns with non default collation


Schema Table Column Collate

Configured Parameters
Parameter Value Description Source Setting
archive_command /utils/replication_log_processor -disable_log_to_disk -action=archive -file_name=%f -local_file_path=%p -async_archive -remote_storage Sets the shell command that will be called to archive a WAL file. configuration file /utils/replication_log_processor -disable_log_to_disk -action=archive -file_name=%f -local_file_path=%p -async_archive -remote_storage
archive_mode always Allows archiving of WAL files using archive_command. configuration file always
archive_timeout 300 s Sets the amount of time to wait before forcing a switch to the next WAL file. configuration file 300
checkpoint_completion_target 0.9 Time spent flushing dirty buffers during checkpoint, as fraction of checkpoint interval. configuration file 0.9
cloudsql.enable_google_vacuum_mgmt off Enables Cloud SQL Vacuum management capability. configuration file off
cloudsql.enable_oom_session_cancel off Enables Cloud SQL OOM management capability. configuration file off
cloudsql.enable_pgaudit on Enables pgAudit extension for audit logging. configuration file on
cloudsql.enable_pg_cron on Enables pg_cron extension to run periodic jobs. configuration file on
cloudsql.enable_pg_hint_plan on Enables pg_hint_plan extension to control execution plans. configuration file on
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 3180 MB Sets the planner's assumption about the total size of the data caches. configuration file 407089
google_insights.enabled on Sets whether to enable the extension. configuration file on
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
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 400 Sets the maximum number of concurrent connections. configuration file 400
max_replication_slots 10 Sets the maximum number of simultaneously defined replication slots. configuration file 10
max_wal_senders 10 Sets the maximum number of simultaneously running WAL sender processes. configuration file 10
max_wal_size 2048 TB Sets the WAL size that triggers a checkpoint. configuration file 2147483647
pg_stat_statements.track all Selects which statements are tracked by pg_stat_statements. configuration file all
port 5432 Sets the TCP port the server listens on. command line 5432
shared_buffers 2650 MB Sets the number of shared memory buffers used by the server. configuration file 339200
shared_preload_libraries google_dbheartbeat,google_insights,iamgroup_management,pg_cron,pg_hint_plan,pg_stat_statements,pgaudit,password_validation Lists shared libraries to preload into server. configuration file google_dbheartbeat,google_insights,iamgroup_management,pg_cron,pg_hint_plan,pg_stat_statements,pgaudit,password_validation
ssl on Enables SSL connections. configuration file on
ssl_ca_file root.crt Location of the SSL certificate authority file. configuration file root.crt
ssl_prefer_server_ciphers on Give priority to server ciphersuite order. configuration file on
temp_file_limit 998 MB Limits the total size of all temporary files used by each process. configuration file 1021877
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
unix_socket_directories /pgsql Sets the directories where Unix-domain sockets will be created. command line /pgsql
wal_level replica Sets the level of information written to the WAL. configuration file replica

PostgreSQL Parameters (all)
Parameter Value Min Max Description Category Context Unit Source Setting
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
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 /utils/replication_log_processor -disable_log_to_disk -action=archive -file_name=%f -local_file_path=%p -async_archive -remote_storage Sets the shell command that will be called to archive a WAL file. Write-Ahead Log / Archiving sighup configuration file /utils/replication_log_processor -disable_log_to_disk -action=archive -file_name=%f -local_file_path=%p -async_archive -remote_storage
archive_library Sets the library that will be called to archive a WAL file. Write-Ahead Log / Archiving sighup default
archive_mode always Allows archiving of WAL files using archive_command. Write-Ahead Log / Archiving postmaster configuration file always
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 200 ms 10 10000 Background writer sleep time between rounds. Resource Usage / Background Writer sighup ms default 200
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 100 0 1073741823 Background writer maximum number of LRU pages to flush per round. Resource Usage / Background Writer sighup default 100
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
cloudsql.allow_passwordless_local_connections off Enables Cloud SQL passwordless local connections. Customized Options superuser default off
cloudsql.audit_log_line_prefix %m [%p]: [%l-1] db=%d,user=%u Controls information prefixed to each audit log line. Customized Options sighup default %m [%p]: [%l-1] db=%d,user=%u
cloudsql.available_connections 0 0 100 The number of available connections reserved for Cloud SQL. Customized Options internal default 0
cloudsql.available_worker_processes 0 0 100 The number of available worker processes reserved for Cloud SQL. Customized Options internal default 0
cloudsql.cast_usage_allowed_for_superuser off Allows superuser to use user-defined casts. Customized Options superuser default off
cloudsql.connections 0 0 100 Sets the number of connections reserved for Cloud SQL. Customized Options postmaster default 0
cloudsql.disable_password_validation_monitoring off Sets whether to disable password validation monitoring. Customized Options superuser default off
cloudsql.enable_active_query off Enables Cloud SQL Active Query capability. Customized Options superuser default off
cloudsql.enable_anon off Enables postgresql_anonymizer extension to mask or replace PII or sensitive data from a database. Customized Options postmaster default off
cloudsql.enable_auto_explain off Enables auto_explain extension for logging execution plans. Customized Options postmaster default off
cloudsql.enable_google_ml_integration off Enables Google ML integration. Customized Options user default off
cloudsql.enable_google_vacuum_mgmt off Enables Cloud SQL Vacuum management capability. Customized Options superuser configuration file off
cloudsql.enable_index_advisor off Enables Cloud SQL Index Advisor capability. Customized Options sighup default off
cloudsql.enable_instance_password_validation off Sets whether to enable Cloud SQL password validation. Customized Options superuser default off
cloudsql.enable_maintenance_mode off Enables 0.5M emergency transaction IDs for maintenance operations Customized Options cloudsqlsuperuser default off
cloudsql.enable_oom_session_cancel off Enables Cloud SQL OOM management capability. Customized Options superuser configuration file off
cloudsql.enable_password_validation_admin_access off Sets whether to enable cloudsqladmin access to shmem hash table forfailed login attempts. Customized Options superuser default off
cloudsql.enable_pgaudit on Enables pgAudit extension for audit logging. Customized Options postmaster configuration file on
cloudsql.enable_pg_bigm off Enables pg_bigm extension to provide full text search capability. Customized Options postmaster default off
cloudsql.enable_pg_cron on Enables pg_cron extension to run periodic jobs. Customized Options postmaster configuration file on
cloudsql.enable_pg_hint_plan on Enables pg_hint_plan extension to control execution plans. Customized Options postmaster configuration file on
cloudsql.enable_pglogical off Enables pglogical extension for logical replication. Customized Options postmaster default off
cloudsql.enable_pg_squeeze off Enables pg_squeeze extension that removes unused space from a table and optionally sorts tuples according to particular index. Customized Options postmaster default off
cloudsql.enable_pg_wait_sampling off Enables pg_wait_sampling extension to collect sampling-based statistics of wait events. Customized Options postmaster default off
cloudsql.enable_stacktrace off Captures stacktrace logs into log files. Customized Options superuser default off
cloudsql.enable_user_password_validation on Sets whether to enable Cloud SQL user password validation. Customized Options superuser default on
cloudsql.enforce_certs_for_trusted_clients off Enforces certificate requirement for trusted clients. Customized Options superuser default off
cloudsql.extension_maintenance off Enables maintenance of extensions. Customized Options superuser default off
cloudsql.fs_access off Allows file system access Customized Options sighup default off
cloudsql.iam_authentication off Enables Cloud SQL IAM authentication. Customized Options superuser default off
cloudsql.iamgroup_authentication on Sets whether to enable IAM group authentication for CloudSQL. Customized Options superuser default on
cloudsql.logical_decoding off Ensures enough information is written to the WAL to support PostgreSQL logical decoding features. Customized Options postmaster default off
cloudsql.max_concurrent_wal_insertions 8 1 1000 Sets the maximum number of concurrent WAL insertions. Customized Options postmaster default 8
cloudsql.max_failed_attempts_user 10 0 10000 Number of users can set failed login attempts policy. Customized Options postmaster default 10
cloudsql.max_free_memory -1024 bytes -1 2147483647 Sets the maximum free memory to be kept by the process after each command execution. Customized Options superuser kB default -1
cloudsql.max_inflight_users_queue_size 3000 0 10000 Number of users that can be enqueued for privilege updates. Customized Options postmaster default 3000
cloudsql.password_expiration_notify_days 30 0 10000 Number of days before password expired that user will get notification. Customized Options superuser default 30
cloudsql.pgaudit_chunksize 92160 0 1048576 Specifies chunk size for pgaudit log. Customized Options superuser default 92160
cloudsql.pg_authid_select_role Role to allow SELECT of the pg_authid table. Customized Options superuser default
cloudsql.pg_shadow_select_role Role to allow SELECT of the pg_shadow view. Customized Options superuser default
cloudsql.worker_processes 0 0 100 Sets the number of worker processes reserved for Cloud SQL. Customized Options postmaster default 0
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 /pgsql/data/postgresql.conf Sets the server's main configuration file. File Locations postmaster override /pgsql/data/postgresql.conf
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
cron.database_name postgres Database in which pg_cron metadata is kept. Customized Options postmaster default postgres
cron.enable_superuser_jobs off Allow jobs to be scheduled as superuser Customized Options superuser default off
cron.host localhost Hostname to connect to postgres. Customized Options postmaster default localhost
cron.launch_active_jobs on Launch jobs that are defined as active. Customized Options sighup default on
cron.log_min_messages warning log_min_messages for the launcher bgworker. Customized Options sighup default warning
cron.log_run on Log all jobs runs into the job_run_details table Customized Options postmaster default on
cron.log_statement on Log all cron statements prior to execution. Customized Options postmaster default on
cron.max_running_jobs 5 0 7 Maximum number of jobs that can run concurrently. Customized Options postmaster default 5
cron.timezone GMT Specify timezone used for cron schedule. Customized Options postmaster default GMT
cron.use_background_workers on Use background workers instead of client sessions. Customized Options postmaster default on
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 on Shows whether data checksums are turned on for this cluster. Preset Options internal default on
data_directory /pgsql/data Sets the server's data directory. File Locations postmaster override /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_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
dynamic_library_path $libdir Sets the path for dynamically loadable modules. Client Connection Defaults / Other Defaults superuser default $libdir
dynamic_shared_memory_type posix Selects the dynamic shared memory implementation used. Resource Usage / Memory postmaster configuration file posix
effective_cache_size 3180 MB 1 2147483647 Sets the planner's assumption about the total size of the data caches. Query Tuning / Planner Cost Constants user 8kB configuration file 407089
effective_io_concurrency 1 0 1000 Number of simultaneous requests that can be handled efficiently by the disk subsystem. Resource Usage / Asynchronous Behavior user default 1
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_gathermerge on Enables the planner's use of gather merge plans. Query Tuning / Planner Method Configuration user 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_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_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_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
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 on Writes full pages to WAL when first modified after a checkpoint. Write-Ahead Log / Settings sighup default on
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_db_advisor.enabled on Enables google db advisor. Customized Options postmaster default on
google_dbheartbeat.enabled off Whether to enable Google Database Heartbeat extension. Customized Options sighup default off
google_dbheartbeat.paused off Whether to pause Google Database Heartbeat extension. Customized Options sighup default off
google_dbheartbeat.sleep_time_millis 1000 10 86400000 Sleep time in milliseconds between heartbeats. Customized Options sighup default 1000
google_insights.allocate_memory on Sets whether to allcoate memory for the extension. Customized Options postmaster default on
google_insights.allocate_memory_active_queries on Sets whether to allocate memory for active query data. Customized Options postmaster default on
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 default 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_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 on Sets whether to track new connection count. Customized Options superuser default on
google_insights.track_statements_executed_count on Sets whether to track statements executed count. Customized Options superuser default on
google_job_scheduler.enabled on Enables google job scheduler. Customized Options postmaster default on
google_ml_integration.allow_http_endpoints off Allow model endpoints with HTTP protocol. Customized Options internal default off
google_ml_integration.enable_model_support off Enables support for named 1P and 3P models in Google ML integration. Customized Options user 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 /pgsql/data/pg_hba.conf Sets the server's "hba" configuration file. File Locations postmaster override /pgsql/data/pg_hba.conf
hot_standby on Allows connections and queries during recovery. Replication / Standby Servers postmaster configuration file on
hot_standby_feedback off Allows feedback from a hot standby to the primary that will avoid query conflicts. Replication / Standby Servers sighup default off
huge_pages try Use of huge pages on Linux or Windows. Resource Usage / Memory postmaster default try
huge_page_size 0 bytes 0 2147483647 The size of huge page that should be requested. Resource Usage / Memory postmaster kB default 0
ident_file /pgsql/data/pg_ident.conf Sets the server's "ident" configuration file. File Locations postmaster override /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
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 en_US.UTF8 Shows the collation order locale. Preset Options internal default en_US.UTF8
lc_ctype en_US.UTF8 Shows the character classification and case conversion locale. Preset Options internal default en_US.UTF8
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 *
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
lo_compat_privileges off Enables backward compatibility mode for privilege checks on large objects. Version and Platform Compatibility / Previous PostgreSQL Versions superuser default off
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
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
log_hostname off Logs the host name in the connection logs. Reporting and Logging / What to Log sighup 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
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
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 400 1 262143 Sets the maximum number of concurrent connections. Connections and Authentication / Connection Settings postmaster configuration file 400
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 default 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 default 8
max_parallel_workers_per_gather 2 0 1024 Sets the maximum number of parallel processes per executor node. Resource Usage / Asynchronous Behavior user default 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 default 0
max_replication_slots 10 0 262143 Sets the maximum number of simultaneously defined replication slots. Replication / Sending Servers postmaster configuration file 10
max_slot_wal_keep_size -1024 kB -1 2147483647 Sets the maximum WAL size that can be reserved by replication slots. Replication / Sending Servers sighup MB default -1
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 10 0 262143 Sets the maximum number of simultaneously running WAL sender processes. Replication / Sending Servers postmaster configuration file 10
max_wal_size 2048 TB 2 2147483647 Sets the WAL size that triggers a checkpoint. Write-Ahead Log / Checkpoints sighup MB configuration file 2147483647
max_worker_processes 8 0 262143 Maximum number of concurrent worker processes. Resource Usage / Asynchronous Behavior postmaster default 8
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
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
pgaudit.log none Specifies which classes of statements will be logged by session audit logging. Multiple classes can be provided using a comma-separated list and classes can be subtracted by prefacing the class with a - sign. Customized Options cloudsqlsuperuser default none
pgaudit.log_catalog on Specifies that session logging should be enabled in the case where all relations in a statement are in pg_catalog. Disabling this setting will reduce noise in the log from tools like psql and PgAdmin that query the catalog heavily. Customized Options cloudsqlsuperuser default on
pgaudit.log_client off Specifies whether audit messages should be visible to the client. This setting should generally be left disabled but may be useful for debugging or other purposes. Customized Options cloudsqlsuperuser default off
pgaudit.log_level log Specifies the log level that will be used for log entries. This setting is used for regression testing and may also be useful to end users for testing or other purposes. It is not intended to be used in a production environment as it may leak which statements are being logged to the user. Customized Options cloudsqlsuperuser default log
pgaudit.log_parameter off Specifies that audit logging should include the parameters that were passed with the statement. When parameters are present they will be be included in CSV format after the statement text. Customized Options cloudsqlsuperuser default off
pgaudit.log_relation off Specifies whether session audit logging should create a separate log entry for each relation referenced in a SELECT or DML statement. This is a useful shortcut for exhaustive logging without using object audit logging. Customized Options cloudsqlsuperuser default off
pgaudit.log_rows off Specifies whether logging will include the rows retrieved or affected by a statement. Customized Options superuser default off
pgaudit.log_statement on Specifies whether logging will include the statement text and parameters. Depending on requirements, the full statement text might not be required in the audit log. Customized Options superuser default on
pgaudit.log_statement_once off Specifies whether logging will include the statement text and parameters with the first log entry for a statement/substatement combination or with every entry. Disabling this setting will result in less verbose logging but may make it more difficult to determine the statement that generated a log entry, though the statement/substatement pair along with the process id should suffice to identify the statement text logged with a previous entry. Customized Options cloudsqlsuperuser default off
pgaudit.role Specifies the master role to use for object audit logging. Multiple audit roles can be defined by granting them to the master role. This allows multiple groups to be in charge of different aspects of audit logging. Customized Options cloudsqlsuperuser default
pg_hint_plan.debug_print off Logs results of hint parsing. Customized Options user default off
pg_hint_plan.enable_hint on Force planner to use plans specified in the hint comment preceding to the query. Customized Options user default on
pg_hint_plan.enable_hint_table off Let pg_hint_plan look up the hint table. Customized Options user default off
pg_hint_plan.hints_anywhere off Read hints from anywhere in a query. Customized Options user default off
pg_hint_plan.message_level log Message level of debug messages. Customized Options user default log
pg_hint_plan.parse_messages info Message level of parse errors. Customized Options user default info
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 all Selects which statements are tracked by pg_stat_statements. Customized Options superuser configuration file all
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
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 try Prefetch referenced blocks during recovery. Write-Ahead Log / Recovery sighup default try
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 default 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
restart_after_crash on Reinitialize server after backend crash. Error Handling sighup default on
restore_command Sets the shell command that will be called to retrieve an archived WAL file. Write-Ahead Log / Archive Recovery sighup default
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
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 131072 131072 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.8 Shows the server version. Preset Options internal default 15.8
server_version_num 150008 150008 150008 Shows the server version as an integer. Preset Options internal default 150008
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 2650 MB 16 1073741823 Sets the number of shared memory buffers used by the server. Resource Usage / Memory postmaster 8kB configuration file 339200
shared_memory_size 2763 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 2763
shared_memory_size_in_huge_pages 1382 -1 2147483647 Shows the number of huge pages needed for the main shared memory area. Preset Options internal default 1382
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 google_dbheartbeat,google_insights,iamgroup_management,pg_cron,pg_hint_plan,pg_stat_statements,pgaudit,password_validation Lists shared libraries to preload into server. Client Connection Defaults / Shared Library Preloading postmaster configuration file google_dbheartbeat,google_insights,iamgroup_management,pg_cron,pg_hint_plan,pg_stat_statements,pgaudit,password_validation
ssl on Enables SSL connections. Connections and Authentication / SSL sighup configuration file on
ssl_ca_file root.crt Location of the SSL certificate authority file. Connections and Authentication / SSL sighup configuration file root.crt
ssl_cert_file server.crt Location of the SSL server certificate file. Connections and Authentication / SSL sighup default server.crt
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 server.key Location of the SSL server private key file. Connections and Authentication / SSL sighup default server.key
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 configuration file 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 3 0 262143 Sets the number of connection slots reserved for superusers. Connections and Authentication / Connection Settings postmaster default 3
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 default 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 60 s 0 2147483647 Time between issuing TCP keepalives. Connections and Authentication / Connection Settings user s default 60
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 998 MB -1 2147483647 Limits the total size of all temporary files used by each process. Resource Usage / Disk superuser kB configuration file 1021877
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_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 /pgsql Sets the directories where Unix-domain sockets will be created. Connections and Authentication / Connection Settings postmaster command line /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 1600000000 0 2100000000 Age at which VACUUM should trigger failsafe to avoid a wraparound outage. Client Connection Defaults / Statement Behavior user default 1600000000
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 1600000000 0 2100000000 Multixact age at which VACUUM should trigger failsafe to avoid a wraparound outage. Client Connection Defaults / Statement Behavior user default 1600000000
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 16 MB -1 262143 Sets the number of disk-page buffers in shared memory for WAL. Write-Ahead Log / Settings postmaster 8kB default 2048
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 on Writes zeroes to new WAL files before first use. Write-Ahead Log / Settings superuser default on
wal_keep_size 0 bytes 0 2147483647 Sets the size of WAL files held for standby servers. Replication / Sending Servers sighup MB default 0
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
work_mem 4096 kB 64 2147483647 Sets the maximum memory to be used for query workspaces. Resource Usage / Memory user kB default 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 
-----------+----------------
         1 | 0 bytes

      name      | size |      modification      
----------------+------+------------------------
 postgres.audit |    0 | 2024-10-08 06:28:11+00






WAL files (first 5 and latest 20)


 wal_files | wal_total_size 
-----------+----------------
        53 | 832 MB

                   name                   |   size   |      modification      
------------------------------------------+----------+------------------------
 0000000100000000000000CF                 | 16777216 | 2024-10-08 07:38:53+00
 0000000100000000000000D1                 | 16777216 | 2024-10-08 07:39:23+00
 0000000100000000000000CE                 | 16777216 | 2024-10-08 07:39:57+00
 0000000100000000000000D0                 | 16777216 | 2024-10-08 07:40:42+00
 0000000100000000000000DA                 | 16777216 | 2024-10-08 08:06:07+00
 ...                                      |          | 
 0000000100000000000000F4                 | 16777216 | 2024-10-08 08:08:00+00
 0000000100000000000000EF                 | 16777216 | 2024-10-08 08:08:05+00
 0000000100000000000000D6                 | 16777216 | 2024-10-08 08:08:10+00
 0000000100000000000000EE                 | 16777216 | 2024-10-08 08:08:15+00
 0000000100000000000000E3                 | 16777216 | 2024-10-08 08:08:20+00
 0000000100000000000000F2                 | 16777216 | 2024-10-08 08:08:25+00
 0000000100000000000000E2                 | 16777216 | 2024-10-08 08:08:31+00
 0000000100000000000000DC                 | 16777216 | 2024-10-08 08:08:36+00
 0000000100000000000000EB                 | 16777216 | 2024-10-08 08:08:41+00
 0000000100000000000000F8                 | 16777216 | 2024-10-08 08:08:47+00
 0000000100000000000000FA                 | 16777216 | 2024-10-08 08:08:51+00
 0000000100000000000000FB                 | 16777216 | 2024-10-08 08:08:55+00
 0000000100000000000000F9                 | 16777216 | 2024-10-08 08:08:59+00
 0000000100000000000000FD                 | 16777216 | 2024-10-08 08:13:58+00
 0000000100000000000000C7.000000D8.backup |      342 | 2024-10-08 08:15:13+00
 0000000100000000000000FC                 | 16777216 | 2024-10-08 08:15:13+00
 0000000100000000000000FE                 | 16777216 | 2024-10-08 08:20:13+00
 0000000100000000000000CB                 | 16777216 | 2024-10-08 08:35:14+00
 0000000100000000000000CC                 | 16777216 | 2024-10-08 08:37:48+00
 0000000100000000000000CD                 | 16777216 | 2024-10-08 08:37:51+00







Optional informations




Buffer cache content detailed information


             relname             | relkind | buffers | buffered | buffers_pct | relation_pct | usage_avg 
---------------------------------+---------+---------+----------+-------------+--------------+-----------
 pgbench_accounts                | r       |  105807 | 827 MB   |        31.2 |         63.8 |      2.99
 pgbench_accounts_pkey           | i       |   27361 | 214 MB   |         8.1 |         99.8 |      4.97
 pg_toast_2618                   | t       |      69 | 552 kB   |         0.0 |        106.2 |      1.90
 pg_description                  | r       |      48 | 384 kB   |         0.0 |        109.1 |      1.13
 pgbench_history                 | r       |      45 | 360 kB   |         0.0 |        107.1 |      4.96
 pg_collation                    | r       |      29 | 232 kB   |         0.0 |        116.0 |      1.21
 pg_statistic                    | r       |      29 | 232 kB   |         0.0 |        116.0 |      4.83
 pg_description_o_c_o_index      | i       |      28 | 224 kB   |         0.0 |        100.0 |      1.32
 pg_rewrite                      | r       |      19 | 152 kB   |         0.0 |        126.7 |      3.95
 pg_depend                       | r       |      19 | 152 kB   |         0.0 |        126.7 |      2.26
 pg_operator                     | r       |      18 | 144 kB   |         0.0 |        128.6 |      4.11
 pgbench_branches                | r       |      16 | 128 kB   |         0.0 |        133.3 |      5.00
 pgbench_tellers                 | r       |      13 | 104 kB   |         0.0 |         25.0 |      5.00
 sql_features                    | r       |      12 | 96 kB    |         0.0 |        150.0 |      1.00
 pg_collation_name_enc_nsp_index | i       |      12 | 96 kB    |         0.0 |        100.0 |      1.08
 pg_amop                         | r       |      11 | 88 kB    |         0.0 |        157.1 |      3.55
 pg_depend_depender_index        | i       |      11 | 88 kB    |         0.0 |        100.0 |      2.82
 pg_amproc                       | r       |       9 | 72 kB    |         0.0 |        180.0 |      2.56
 pg_index                        | r       |       8 | 64 kB    |         0.0 |        200.0 |      4.38
 pg_depend_reference_index       | i       |       8 | 64 kB    |         0.0 |        100.0 |      2.75
 pg_ts_config_map                | r       |       7 | 56 kB    |         0.0 |        233.3 |      1.00
 pg_toast_2619                   | t       |       7 | 56 kB    |         0.0 |        233.3 |      1.43
 pg_opclass                      | r       |       7 | 56 kB    |         0.0 |        233.3 |      2.14
 pg_constraint                   | r       |       7 | 56 kB    |         0.0 |        233.3 |      3.71
 pg_init_privs                   | r       |       7 | 56 kB    |         0.0 |        233.3 |      2.14
 pg_opfamily                     | r       |       6 | 48 kB    |         0.0 |        300.0 |      1.00
 pg_aggregate                    | r       |       6 | 48 kB    |         0.0 |        300.0 |      2.33
 pg_operator_oprname_l_r_n_index | i       |       6 | 48 kB    |         0.0 |        100.0 |      4.50
 pg_collation_oid_index          | i       |       6 | 48 kB    |         0.0 |        100.0 |      2.50
 pg_conversion                   | r       |       6 | 48 kB    |         0.0 |        300.0 |      1.00

 buffer_cache_size 
-------------------
 2650 MB

 minimal_cache_size_est 
------------------------
 585 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]    | 58                   | 0.011966666 |         0
      2 | public.pgbench_accounts | bid      |         4 | [1:100]    | 61                   | 0.011366666 |         0
      3 | public.pgbench_accounts | bid      |         4 | [1:100]    | 92                   | 0.0112      |         0
      4 | public.pgbench_accounts | bid      |         4 | [1:100]    | 36                   | 0.011166667 |         0
      5 | public.pgbench_accounts | bid      |         4 | [1:100]    | 88                   | 0.011133334 |         0
      6 | public.pgbench_accounts | bid      |         4 | [1:100]    | 49                   | 0.0111      |         0
      7 | public.pgbench_accounts | bid      |         4 | [1:100]    | 5                    | 0.010933333 |         0
      8 | public.pgbench_accounts | bid      |         4 | [1:100]    | 77                   | 0.010866666 |         0
      9 | public.pgbench_accounts | bid      |         4 | [1:100]    | 99                   | 0.0108      |         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 
------+-------------------+-----------+-----------
   28 | f                 |           | f
 1022 | f                 |           | f
 4749 | f                 |           | f
 4738 | f                 |           | f
 4751 | f                 |           | f
 4753 | f                 |           | f
 4755 | f                 |           | f
 4757 | f                 |           | f
 4759 | f                 |           | f
 4761 | f                 |           | f
 4763 | f                 |           | f
 4765 | f                 |           | f
 4767 | f                 |           | f
 4769 | f                 |           | f
 4771 | f                 |           | f
 4773 | f                 |           | f
 4775 | f                 |           | f
 4777 | f                 |           | f
 4779 | f                 |           | f
 4781 | f                 |           | f
 4783 | f                 |           | f
 4785 | f                 |           | f
 4787 | f                 |           | f
 4789 | f                 |           | f
 4791 | f                 |           | f
 4793 | f                 |           | f
 4795 | f                 |           | f
 4797 | f                 |           | f
 4799 | f                 |           | f
 4801 | f                 |           | f
 4803 | f                 |           | f
 4805 | f                 |           | f
 4807 | f                 |           | f
 4809 | f                 |           | f
 4811 | f                 |           | f
 4813 | f                 |           | f
 4815 | f                 |           | f
 4817 | f                 |           | f
 4819 | f                 |           | f
 4821 | f                 |           | f
 4823 | f                 |           | f
 4825 | f                 |           | f
 4827 | f                 |           | f
 4829 | f                 |           | f
 4831 | f                 |           | f
 4833 | f                 |           | f
 4835 | f                 |           | f
 4837 | f                 |           | f
 4839 | f                 |           | f
 4841 | f                 |           | f
 4843 | f                 |           | f
 4845 | f                 |           | f
 4847 | f                 |           | f
 4849 | f                 |           | f
 4851 | f                 |           | f
 4853 | f                 |           | f
 4856 | f                 |           | f
 4858 | f                 |           | f
 4860 | f                 |           | f
 4862 | f                 |           | f
 4864 | f                 |           | f
 4866 | f                 |           | f
 4868 | f                 |           | f
 4870 | f                 |           | f
 4872 | f                 |           | f
 4874 | f                 |           | f
 4876 | 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 |       8 |         0 | 2024-10-08 06:27:15.809995+00
 MultiXactMember |           1 |        0 |         0 |            1 |           0 |       8 |         0 | 2024-10-08 06:27:15.809995+00
 MultiXactOffset |           1 |        1 |         4 |            5 |           0 |       8 |         0 | 2024-10-08 06:27:15.809995+00
 Notify          |           0 |        0 |         0 |            0 |           0 |       0 |         0 | 2024-10-08 06:27:15.809995+00
 Serial          |           0 |        0 |         0 |            0 |           0 |       0 |         0 | 2024-10-08 06:27:15.809995+00
 Subtrans        |          88 |        0 |         0 |            6 |           0 |       8 |         8 | 2024-10-08 06:27:15.809995+00
 Xact            |           7 |   914323 |         4 |            7 |           0 |       8 |         0 | 2024-10-08 06:27:15.809995+00
 other           |           0 |        0 |         0 |            0 |           0 |       0 |         0 | 2024-10-08 06:27:15.809995+00

                      name                       |    off     |    size    | allocated_size 
-------------------------------------------------+------------+------------+----------------
 Buffer Blocks                                   |   43330176 | 2778726400 |     2778726400
 -anonymous-                                     |            |   44556544 |       44556544
 Buffer Descriptors                              |   21621376 |   21708800 |       21708800
 XLOG Ctl                                        |      94464 |   16803400 |       16803456
                                                 | 2889671168 |    8592896 |        8592896
 Checkpointer Data                               | 2866390528 |    8140864 |        8140928
 Checkpoint BufferIds                            | 2827483776 |    6784000 |        6784000
 Buffer IO Condition Variables                   | 2822056576 |    5427200 |        5427200
 CommitTs                                        |   19014912 |    2135392 |        2135424
 Xact                                            |   16898560 |    2116320 |        2116352
 google_insights_trace_buffer                    | 2886496512 |    1048576 |        1048576
 Backend Activity Buffer                         | 2865691904 |     438272 |         438272
 Subtrans                                        |   21150464 |     267008 |         267008
 Shared Memory Stats                             | 2874625664 |     263312 |         263424
 Backend Status Array                            | 2865448704 |     188320 |         188416
 Backend SSL Status Buffer                       | 2866130176 |     138672 |         138752
 MultiXactMember                                 |   21484288 |     133568 |         133632
 Serial                                          | 2864796544 |     133568 |         133632
 KnownAssignedXids                               | 2865311360 |     109720 |         109824
 shmInvalBuffer                                  | 2866273664 |      79064 |          79104
 Notify                                          | 2874558848 |      66816 |          66816
 MultiXactOffset                                 |   21417472 |      66816 |          66816
 google_insights_aq_text_buffer                  | 2874956416 |      54438 |          54528
 ProcSignal                                      | 2866356224 |      34248 |          34304
 google_insights_per_backend_statements_counts   | 2887545984 |      30384 |          30464
 KnownAssignedXidsValid                          | 2865421184 |      27430 |          27520
 Backend Application Name Buffer                 | 2865637120 |      27392 |          27392
 Backend Client Host Name Buffer                 | 2865664512 |      27392 |          27392
 Shared Buffer Lookup Table                      | 2834267776 |      17232 |          17280
 google_insights_aq_backend_entries              | 2874942848 |      13504 |          13568
 Async Queue Control                             | 2874550272 |       8492 |           8576
 AutoVacuum Data                                 | 2874531456 |       5368 |           5376
 BTree Vacuum State                              | 2874544384 |       5076 |           5120
 Background Worker Data                          | 2866269056 |       4496 |           4608
 Fast Path Strong Relation Lock Data             | 2856884608 |       4100 |           4224
 PMSignalState                                   | 2866352768 |       3416 |           3456
 Shared MultiXact State                          |   21617920 |       3428 |           3456
 Cloud SQL IAM group first time login error reas | 2874911616 |       2896 |           2944
 PREDICATELOCK hash                              | 2858452352 |       2896 |           2944
 pg_stat_statements hash                         | 2887722624 |       2896 |           2944
 Password Validation Failed Login Status Hashtab | 2874937216 |       2896 |           2944
 Cloud SQL IAM login error reason counts         | 2874889728 |       2896 |           2944
 google_insights_tag_stats_hash_table            | 2883548032 |       2896 |           2944
 Cloud SQL IAM group login error reason counts   | 2874904320 |       2896 |           2944
 Password validation validation error reason cou | 2874923136 |       2896 |           2944
 Password validation login error reason counts   | 2874930432 |       2896 |           2944
 SERIALIZABLEXID hash                            | 2863579904 |       2896 |           2944
 LOCK hash                                       | 2852053632 |       2896 |           2944
 google_insights_aggregated_stats_hash_table     | 2875010944 |       2896 |           2944
 PostgreSQL IAM user mTLS verification status co | 2874897024 |       2896 |           2944
 IAM Group Inflight Users Hashtable              | 2887590784 |       2896 |           2944
 google_insights_query_stats_hash_table          | 2876639488 |       2896 |           2944
 google_insights_aggregate_per_database_statemen | 2887576448 |       2896 |           2944
 PREDICATELOCKTARGET hash                        | 2856888832 |       2896 |           2944
 PROCLOCK hash                                   | 2854456832 |       2896 |           2944
 ReplicationSlot Ctl                             | 2874536832 |       2640 |           2688
 Wal Receiver Ctl                                | 2874541312 |       2264 |           2304
 Proc Array                                      | 2865309568 |       1728 |           1792
 Wal Sender Ctl                                  | 2874540160 |       1040 |           1152
 Sync Scan Locations List                        | 2874549504 |        656 |            768
 PostgreSQL IAM user mTLS verification status me | 2874896384 |        568 |            640
 Cloud SQL IAM group first time login metrics    | 2874910976 |        568 |            640
 Password validation validation metrics          | 2874922496 |        568 |            640
 Cloud SQL IAM group login metrics               | 2874903680 |        568 |            640
 Cloud SQL IAM login metrics                     | 2874889088 |        568 |            640
 ReplicationOriginState                          | 2874539520 |        568 |            640
 Password validation login metrics               | 2874929792 |        568 |            640
 Logical Replication Launcher Data               | 2874543744 |        456 |            512
 google_insights_internal_metrics                | 2887545216 |        312 |            384
 Control File                                    |   16897920 |        296 |            384
 google_insights_extension_latency_counts        | 2887590400 |        136 |            256
 FinishedSerializableTransactions                | 2864796416 |         16 |            128
 Prepared Transaction Table                      | 2866268928 |         16 |            128
 google_insights_total_statements_counts         | 2887590272 |         64 |            128
 Cloud SQL Reservations                          | 2874922368 |         20 |            128
 google_insights_query_plan_sampler              | 2887545088 |         48 |            128
 google_insights_query_plan_internal_metrics     | 2887545600 |         56 |            128
 IAM Group Inflight Users                        | 2887590656 |         16 |            128
 google_insights_query_statistics                | 2887545728 |         16 |            128
 Password Validation Failed Login Status         | 2874937088 |         32 |            128
 XLOG Recovery Ctl                               |   16898432 |        104 |            128
 Google Database Heartbeat Data                  | 2874942720 |         48 |            128
 pg_stat_statements                              | 2887722496 |         64 |            128
 google_insights_statements_counts_start_time    | 2887545856 |          8 |            128
 CommitTs shared                                 |   21150336 |         32 |            128
 OldSnapshotControlData                          | 2874544256 |         68 |            128
 XLogPrefetchStats                               |   16898304 |         72 |            128
 Buffer Strategy Status                          | 2852053504 |         28 |            128
 PredXactList                                    | 2862870784 |         88 |            128
 SerialControlData                               | 2864930176 |         12 |            128
 Proc Header                                     | 2864930304 |        104 |            128
 Archiver Data                                   | 2874543616 |          8 |            128
 RWConflictPool                                  | 2863783424 |         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 
-------------+---------+------------+------------------+-----------+----------+----------------+---------------+-------------------------------+----------
     1572034 |  251144 | 3119207369 |            13182 |    163621 |   149589 |              0 |             0 | 2024-10-08 06:27:15.809995+00 | 1366 MB

        name        |        ident         |       parent       | level | total_bytes | total_nblocks | free_bytes | free_chunks | used_bytes 
--------------------+----------------------+--------------------+-------+-------------+---------------+------------+-------------+------------
 CacheMemoryContext |                      | TopMemoryContext   |     1 |     4227128 |            11 |    1300440 |           7 |    2926688
 relation rules     | columns              | CacheMemoryContext |     2 |      238016 |            38 |       9216 |           3 |     228800
 TopMemoryContext   |                      |                    |     0 |      192592 |             8 |      27480 |          41 |     165112
 Timezones          |                      | TopMemoryContext   |     1 |      104120 |             2 |       2616 |           0 |     101504
 relation rules     | pg_stats_ext_exprs   | CacheMemoryContext |     2 |       98304 |            15 |       6408 |           3 |      91896
 relation rules     | pg_statio_all_tables | CacheMemoryContext |     2 |       90112 |            14 |       5064 |           2 |      85048
 relation rules     | pg_stats_ext         | CacheMemoryContext |     2 |       90112 |            14 |       5976 |           0 |      84136
 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

 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-08 06:27:46.731715+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                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |      context      |       source       |                                                                                   short_desc                                                                                   
----------------------------------------------------------+------+-------------------+--------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 cloudsql.allow_passwordless_local_connections            | off  | superuser         | default            | Enables Cloud SQL passwordless local connections.
 cloudsql.audit_log_line_prefix                           | %m [%p]: [%l-1] db=%d,user=%u                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | sighup            | default            | Controls information prefixed to each audit log line.
 cloudsql.available_connections                           | 0    | internal          | default            | The number of available connections reserved for Cloud SQL.
 cloudsql.available_worker_processes                      | 0    | internal          | default            | The number of available worker processes reserved for Cloud SQL.
 cloudsql.cast_usage_allowed_for_superuser                | off  | superuser         | default            | Allows superuser to use user-defined casts.
 cloudsql.connections                                     | 0    | postmaster        | default            | Sets the number of connections reserved for Cloud SQL.
 cloudsql.disable_password_validation_monitoring          | off  | superuser         | default            | Sets whether to disable password validation monitoring.
 cloudsql.enable_active_query                             | off  | superuser         | default            | Enables Cloud SQL Active Query capability.
 cloudsql.enable_anon                                     | off  | postmaster        | default            | Enables postgresql_anonymizer extension to mask or replace PII or sensitive data from a database.
 cloudsql.enable_auto_explain                             | off  | postmaster        | default            | Enables auto_explain extension for logging execution plans.
 cloudsql.enable_google_ml_integration                    | off  | user              | default            | Enables Google ML integration.
 cloudsql.enable_google_vacuum_mgmt                       | off  | superuser         | configuration file | Enables Cloud SQL Vacuum management capability.
 cloudsql.enable_index_advisor                            | off  | sighup            | default            | Enables Cloud SQL Index Advisor capability.
 cloudsql.enable_instance_password_validation             | off  | superuser         | default            | Sets whether to enable Cloud SQL password validation.
 cloudsql.enable_maintenance_mode                         | off  | cloudsqlsuperuser | default            | Enables 0.5M emergency transaction IDs for maintenance operations
 cloudsql.enable_oom_session_cancel                       | off  | superuser         | configuration file | Enables Cloud SQL OOM management capability.
 cloudsql.enable_password_validation_admin_access         | off  | superuser         | default            | Sets whether to enable cloudsqladmin access to shmem hash table forfailed login attempts.
 cloudsql.enable_pgaudit                                  | on   | postmaster        | configuration file | Enables pgAudit extension for audit logging.
 cloudsql.enable_pg_bigm                                  | off  | postmaster        | default            | Enables pg_bigm extension to provide full text search capability.
 cloudsql.enable_pg_cron                                  | on   | postmaster        | configuration file | Enables pg_cron extension to run periodic jobs.
 cloudsql.enable_pg_hint_plan                             | on   | postmaster        | configuration file | Enables pg_hint_plan extension to control execution plans.
 cloudsql.enable_pglogical                                | off  | postmaster        | default            | Enables pglogical extension for logical replication.
 cloudsql.enable_pg_squeeze                               | off  | postmaster        | default            | Enables pg_squeeze extension that removes unused space from a table and optionally sorts tuples according to particular index.
 cloudsql.enable_pg_wait_sampling                         | off  | postmaster        | default            | Enables pg_wait_sampling extension to collect sampling-based statistics of wait events.
 cloudsql.enable_stacktrace                               | off  | superuser         | default            | Captures stacktrace logs into log files.
 cloudsql.enable_user_password_validation                 | on   | superuser         | default            | Sets whether to enable Cloud SQL user password validation.
 cloudsql.enforce_certs_for_trusted_clients               | off  | superuser         | default            | Enforces certificate requirement for trusted clients.
 cloudsql.extension_maintenance                           | off  | superuser         | default            | Enables maintenance of extensions.
 cloudsql.fs_access                                       | off  | sighup            | default            | Allows file system access
 cloudsql.iam_authentication                              | off  | superuser         | default            | Enables Cloud SQL IAM authentication.
 cloudsql.iamgroup_authentication                         | on   | superuser         | default            | Sets whether to enable IAM group authentication for CloudSQL.
 cloudsql.logical_decoding                                | off  | postmaster        | default            | Ensures enough information is written to the WAL to support PostgreSQL logical decoding features.
 cloudsql.max_concurrent_wal_insertions                   | 8    | postmaster        | default            | Sets the maximum number of concurrent WAL insertions.
 cloudsql.max_failed_attempts_user                        | 10   | postmaster        | default            | Number of users can set failed login attempts policy.
 cloudsql.max_free_memory                                 | -1   | superuser         | default            | Sets the maximum free memory to be kept by the process after each command execution.
 cloudsql.max_inflight_users_queue_size                   | 3000 | postmaster        | default            | Number of users that can be enqueued for privilege updates.
 cloudsql.password_expiration_notify_days                 | 30   | superuser         | default            | Number of days before password expired that user will get notification.
 cloudsql.pgaudit_chunksize                               | 92160| superuser         | default            | Specifies chunk size for pgaudit log.
 cloudsql.pg_authid_select_role                           |      | superuser         | default            | Role to allow SELECT of the pg_authid table.
 cloudsql.pg_shadow_select_role                           |      | superuser         | default            | Role to allow SELECT of the pg_shadow view.
 cloudsql.worker_processes                                | 0    | postmaster        | default            | Sets the number of worker processes reserved for Cloud SQL.
 google_db_advisor.enabled                                | on   | postmaster        | default            | Enables google db advisor.
 google_dbheartbeat.enabled                               | off  | sighup            | default            | Whether to enable Google Database Heartbeat extension.
 google_dbheartbeat.paused                                | off  | sighup            | default            | Whether to pause Google Database Heartbeat extension.
 google_dbheartbeat.sleep_time_millis                     | 1000 | sighup            | default            | Sleep time in milliseconds between heartbeats.
 google_insights.allocate_memory                          | on   | postmaster        | default            | Sets whether to allcoate memory for the extension.
 google_insights.allocate_memory_active_queries           | on   | postmaster        | default            | Sets whether to allocate memory for active query data.
 google_insights.enabled                                  | on   | superuser         | configuration file | Sets whether to enable the extension.
 google_insights.max_active_query_entry_read_attempt      | 256  | superuser         | default            | Sets the maximum number of attempts to read active query backend entry.
 google_insights.max_active_query_length                  | 127  | postmaster        | default            | Sets the maximum size of active query string length.
 google_insights.max_aggregated_stats_entry               | 5000 | postmaster        | default            | Sets the maximum number of entries for aggregated stats recording.
 google_insights.max_per_database_statements_counts       | 100  | postmaster        | default            | Sets the maximum number of databases for which statements counts will be tracked
 google_insights.max_query_length                         | 1024 | postmaster        | default            | Sets the length of the query recorded
 google_insights.max_query_stats_entry                    | 5000 | postmaster        | default            | Sets the maximum number of entries for top N query stats recording.
 google_insights.max_tag_stats_entry                      | 5000 | postmaster        | default            | Sets the maximum number of entries for top N tag stats recording.
 google_insights.num_query_plans_per_minute               | 5    | superuser         | default            | Sets the number of execution plans to sample per minute for all connections.
 google_insights.num_trace_context_query_plans_per_minute | 5    | superuser         | default            | Sets the number of execution plans for trace context to sample per minute for all connections.
 google_insights.skip_acquired_sample_lock                | on   | superuser         | default            | Sets whether to skip sample lock if its already acquired.
 google_insights.trace_buffer_size_in_kb                  | 1024 | postmaster        | default            | Sets the size (in KB) of buffer in shared memory that stores query execution plans.
 google_insights.track                                    | on   | superuser         | configuration file | Sets whether to enable stats tracking, which can be set on the fly to disable the code path.
 google_insights.track_additional_utility_commands        | on   | superuser         | default            | Sets whether to track additional utility commands.
 google_insights.track_client_address                     | off  | superuser         | configuration file | 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.
 google_insights.track_comment                            | off  | superuser         | configuration file | Sets whether to enable stats recording for tags table.
 google_insights.track_internal_metrics                   | on   | superuser         | default            | Sets whether to track internal metrics.
 google_insights.track_new_connection_stats               | on   | superuser         | default            | Sets whether to track new connection count.
 google_insights.track_statements_executed_count          | on   | superuser         | default            | Sets whether to track statements executed count.
 google_job_scheduler.enabled                             | on   | postmaster        | default            | Enables google job scheduler.
 google_ml_integration.allow_http_endpoints               | off  | internal          | default            | Allow model endpoints with HTTP protocol.
 google_ml_integration.enable_model_support               | off  | user              | default            | Enables support for named 1P and 3P models in Google ML integration.






Statistics generated on: 2024-10-08 08:37:56.236352

More info on
this site

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

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