-
Size of all database
Database sizes.
-
Database/Roles settings
Configuration directives and values defined with ALTER DATABASE and ALTER ROLE.
Database Role Settings engine All {client_min_messages=error} engine2 All {client_min_messages=error} engine_dao_tests All {client_min_messages=error} -
PostgreSQL settings
Configuration directives and values defined in pg_settings.
Autovacuum Name Current Unit Reset val Boot val autovacuum on 0 on on autovacuum_analyze_scale_factor 0.1 0 0.1 0.1 autovacuum_analyze_threshold 50 "" 50 50 autovacuum_freeze_max_age 200000000 "" 200000000 200000000 autovacuum_max_workers 3 "" 3 3 autovacuum_multixact_freeze_max_age 400000000 "" 400000000 400000000 autovacuum_naptime 60 s 60 60 autovacuum_vacuum_cost_delay 20 ms 20 20 autovacuum_vacuum_cost_limit -1 "" -1 -1 autovacuum_vacuum_scale_factor 0.2 0 0.2 0.2 autovacuum_vacuum_threshold 50 "" 50 50 Client Connection Defaults / Locale and Formatting Name Current Unit Reset val Boot val client_encoding UTF8 0 UTF8 SQL_ASCII DateStyle ISO. MDY 0 ISO. MDY ISO. MDY default_text_search_config pg_catalog.english 0 pg_catalog.english pg_catalog.simple extra_float_digits 0 "" IntervalStyle postgres 0 postgres postgres lc_collate en_US.UTF-8 0 en_US.UTF-8 C lc_ctype en_US.UTF-8 0 en_US.UTF-8 C lc_messages en_US.UTF-8 0 en_US.UTF-8 "" lc_monetary en_US.UTF-8 0 en_US.UTF-8 C lc_numeric en_US.UTF-8 0 en_US.UTF-8 C lc_time en_US.UTF-8 0 en_US.UTF-8 C server_encoding UTF8 0 UTF8 SQL_ASCII TimeZone Europe/Prague 0 Europe/Prague GMT timezone_abbreviations Default 0 Default Client Connection Defaults / Other Defaults Name Current Unit Reset val Boot val dynamic_library_path $libdir 0 $libdir $libdir gin_fuzzy_search_limit 0 "" local_preload_libraries "" 0 "" "" tcp_keepalives_count 0 "" tcp_keepalives_idle 0 s tcp_keepalives_interval 0 s Client Connection Defaults / Statement Behavior Name Current Unit Reset val Boot val bytea_output hex 0 hex hex check_function_bodies on 0 on on default_tablespace "" 0 "" "" default_transaction_deferrable off 0 off off default_transaction_isolation read committed 0 read committed read committed default_transaction_read_only off 0 off off lock_timeout 0 ms search_path """$user"".public" 0 """$user"".public" """$user"".public" session_replication_role origin 0 origin origin statement_timeout 0 ms temp_tablespaces "" 0 "" "" transaction_deferrable off 0 off off transaction_isolation read committed 0 default default transaction_read_only off 0 off off vacuum_freeze_min_age 50000000 "" 50000000 50000000 vacuum_freeze_table_age 150000000 "" 150000000 150000000 vacuum_multixact_freeze_min_age 5000000 "" 5000000 5000000 vacuum_multixact_freeze_table_age 150000000 "" 150000000 150000000 xmlbinary base64 0 base64 base64 xmloption content 0 content content Connections and Authentication / Connection Settings Name Current Unit Reset val Boot val bonjour off 0 off off bonjour_name "" 0 "" "" listen_addresses localhost 0 localhost localhost max_connections 150 "" 150 100 port 5432 "" 5432 5432 superuser_reserved_connections 3 "" 3 3 unix_socket_directories /var/run/postgresql. /tmp 0 /var/run/postgresql. /tmp /var/run/postgresql. /tmp unix_socket_group "" 0 "" "" unix_socket_permissions 0777 "" 511 511 Connections and Authentication / Security and Authentication Name Current Unit Reset val Boot val authentication_timeout 60 s 60 60 db_user_namespace off 0 off off krb_caseins_users off 0 off off krb_server_keyfile FILE:/etc/krb5.keytab 0 FILE:/etc/krb5.keytab FILE:/etc/krb5.keytab krb_srvname postgres 0 postgres postgres password_encryption on 0 on on ssl off 0 off off ssl_ca_file "" 0 "" "" ssl_cert_file server.crt 0 server.crt server.crt ssl_ciphers DEFAULT:!LOW:!EXP:!MD5:@STRENGTH 0 DEFAULT:!LOW:!EXP:!MD5:@STRENGTH DEFAULT:!LOW:!EXP:!MD5:@STRENGTH ssl_crl_file "" 0 "" "" ssl_key_file server.key 0 server.key server.key ssl_renegotiation_limit 524288 kB 524288 524288 Developer Options Name Current Unit Reset val Boot val allow_system_table_mods off 0 off off debug_assertions off 0 off off ignore_checksum_failure off 0 off off ignore_system_indexes off 0 off off post_auth_delay 0 s pre_auth_delay 0 s trace_notify off 0 off off trace_recovery_messages log 0 log log trace_sort off 0 off off zero_damaged_pages off 0 off off Error Handling Name Current Unit Reset val Boot val exit_on_error off 0 off off restart_after_crash on 0 on on File Locations Name Current Unit Reset val Boot val config_file /var/lib/pgsql/data/postgresql.conf 0 /var/lib/pgsql/data/postgresql.conf data_directory /var/lib/pgsql/data 0 /var/lib/pgsql/data external_pid_file "" 0 hba_file /var/lib/pgsql/data/pg_hba.conf 0 /var/lib/pgsql/data/pg_hba.conf ident_file /var/lib/pgsql/data/pg_ident.conf 0 /var/lib/pgsql/data/pg_ident.conf Lock Management Name Current Unit Reset val Boot val deadlock_timeout 1000 ms 1000 1000 max_locks_per_transaction 64 "" 64 64 max_pred_locks_per_transaction 64 "" 64 64 Preset Options Name Current Unit Reset val Boot val block_size 8192 "" 8192 8192 data_checksums off 0 off off integer_datetimes on 0 on on max_function_args 100 "" 100 100 max_identifier_length 63 "" 63 63 max_index_keys 32 "" 32 32 segment_size 131072 8kB 131072 131072 server_version 9.3.9 0 9.3.9 9.3.9 server_version_num 90309 "" 90309 90309 wal_block_size 8192 "" 8192 8192 wal_segment_size 2048 8kB 2048 2048 Query Tuning / Genetic Query Optimizer Name Current Unit Reset val Boot val geqo on 0 on on geqo_effort 5 "" 5 5 geqo_generations 0 "" geqo_pool_size 0 "" geqo_seed 0 0 geqo_selection_bias 2 0 2 2 geqo_threshold 12 "" 12 12 Query Tuning / Other Planner Options Name Current Unit Reset val Boot val constraint_exclusion partition 0 partition partition cursor_tuple_fraction 0.1 0 0.1 0.1 default_statistics_target 100 "" 100 100 from_collapse_limit 8 "" 8 8 join_collapse_limit 8 "" 8 8 Query Tuning / Planner Cost Constants Name Current Unit Reset val Boot val cpu_index_tuple_cost 0.005 0 0.005 0.005 cpu_operator_cost 0.0025 0 0.0025 0.0025 cpu_tuple_cost 0.01 0 0.01 0.01 effective_cache_size 16384 8kB 16384 16384 random_page_cost 4 0 4 4 seq_page_cost 1 0 1 1 Query Tuning / Planner Method Configuration Name Current Unit Reset val Boot val enable_bitmapscan on 0 on on enable_hashagg on 0 on on enable_hashjoin on 0 on on enable_indexonlyscan on 0 on on enable_indexscan on 0 on on enable_material on 0 on on enable_mergejoin on 0 on on enable_nestloop on 0 on on enable_seqscan on 0 on on enable_sort on 0 on on enable_tidscan on 0 on on Replication / Master Server Name Current Unit Reset val Boot val synchronous_standby_names "" 0 "" "" vacuum_defer_cleanup_age 0 "" Replication / Sending Servers Name Current Unit Reset val Boot val max_wal_senders 0 "" wal_keep_segments 0 "" wal_sender_timeout 60000 ms 60000 60000 Replication / Standby Servers Name Current Unit Reset val Boot val hot_standby off 0 off off hot_standby_feedback off 0 off off max_standby_archive_delay 30000 ms 30000 30000 max_standby_streaming_delay 30000 ms 30000 30000 wal_receiver_status_interval 10 s 10 10 wal_receiver_timeout 60000 ms 60000 60000 Reporting and Logging / What to Log Name Current Unit Reset val Boot val application_name pgcluu 0 psql "" debug_pretty_print on 0 on on debug_print_parse off 0 off off debug_print_plan off 0 off off debug_print_rewritten off 0 off off log_autovacuum_min_duration -1 ms -1 -1 log_checkpoints off 0 off off log_connections off 0 off off log_disconnections off 0 off off log_duration off 0 off off log_error_verbosity default 0 default default log_hostname off 0 off off log_line_prefix "" 0 "" "" log_lock_waits off 0 off off log_statement none 0 none none log_temp_files -1 kB -1 -1 log_timezone Europe/Prague 0 Europe/Prague GMT Reporting and Logging / When to Log Name Current Unit Reset val Boot val client_min_messages error 0 error notice log_min_duration_statement -1 ms -1 -1 log_min_error_statement error 0 error error log_min_messages warning 0 warning warning Reporting and Logging / Where to Log Name Current Unit Reset val Boot val event_source PostgreSQL 0 PostgreSQL PostgreSQL log_destination stderr 0 stderr stderr log_directory pg_log 0 pg_log pg_log log_file_mode 0600 "" 384 384 log_filename postgresql-%a.log 0 postgresql-%a.log postgresql-%Y-%m-%d_%H%M%S.log log_rotation_age 1440 min 1440 1440 log_rotation_size 0 kB 10240 log_truncate_on_rotation on 0 on off logging_collector on 0 on off syslog_facility local0 0 local0 local0 syslog_ident postgres 0 postgres postgres Resource Usage / Asynchronous Behavior Name Current Unit Reset val Boot val effective_io_concurrency 1 "" 1 1 Resource Usage / Background Writer Name Current Unit Reset val Boot val bgwriter_delay 200 ms 200 200 bgwriter_lru_maxpages 100 "" 100 100 bgwriter_lru_multiplier 2 0 2 2 Resource Usage / Cost-Based Vacuum Delay Name Current Unit Reset val Boot val vacuum_cost_delay 0 ms vacuum_cost_limit 200 "" 200 200 vacuum_cost_page_dirty 20 "" 20 20 vacuum_cost_page_hit 1 "" 1 1 vacuum_cost_page_miss 10 "" 10 10 Resource Usage / Disk Name Current Unit Reset val Boot val temp_file_limit -1 kB -1 -1 Resource Usage / Kernel Resources Name Current Unit Reset val Boot val max_files_per_process 1000 "" 1000 1000 shared_preload_libraries "" 0 "" "" Resource Usage / Memory Name Current Unit Reset val Boot val maintenance_work_mem 16384 kB 16384 16384 max_prepared_transactions 0 "" max_stack_depth 2048 kB 2048 100 shared_buffers 16384 8kB 16384 1024 temp_buffers 1024 8kB 1024 1024 track_activity_query_size 1024 "" 1024 1024 work_mem 1024 kB 1024 1024 Statistics / Monitoring Name Current Unit Reset val Boot val log_executor_stats off 0 off off log_parser_stats off 0 off off log_planner_stats off 0 off off log_statement_stats off 0 off off Statistics / Query and Index Statistics Collector Name Current Unit Reset val Boot val stats_temp_directory pg_stat_tmp 0 pg_stat_tmp pg_stat_tmp track_activities on 0 on on track_counts on 0 on on track_functions none 0 none none track_io_timing off 0 off off update_process_title on 0 on on Version and Platform Compatibility / Other Platforms and Clients Name Current Unit Reset val Boot val transform_null_equals off 0 off off Version and Platform Compatibility / Previous PostgreSQL Versions Name Current Unit Reset val Boot val array_nulls on 0 on on backslash_quote safe_encoding 0 safe_encoding safe_encoding default_with_oids off 0 off off escape_string_warning on 0 on on lo_compat_privileges off 0 off off quote_all_identifiers off 0 off off sql_inheritance on 0 on on standard_conforming_strings on 0 on on synchronize_seqscans on 0 on on Write-Ahead Log / Archiving Name Current Unit Reset val Boot val archive_command (disabled) 0 "" "" archive_mode off 0 off off archive_timeout 0 s Write-Ahead Log / Checkpoints Name Current Unit Reset val Boot val checkpoint_completion_target 0.5 0 0.5 0.5 checkpoint_segments 3 "" 3 3 checkpoint_timeout 300 s 300 300 checkpoint_warning 30 s 30 30 Write-Ahead Log / Settings Name Current Unit Reset val Boot val commit_delay 0 "" commit_siblings 5 "" 5 5 fsync on 0 on on full_page_writes on 0 on on synchronous_commit on 0 on on wal_buffers 512 8kB 512 -1 wal_level minimal 0 minimal minimal wal_sync_method fdatasync 0 fdatasync fdatasync wal_writer_delay 200 ms 200 200 -
checkpoints counter stats
Background writer statistics on checkpoints. Checkpoints timed is checkpoints issued because of checkpoint_timeout and checkpoints request is checkpoint issued by request.
-
background writer clean stats
Background writer cache cleaning statistics by checkpoints, lru and backends.
-
background writer count stats
Background writer counter stats. Max written clean reports the number of times the background writer stopped a cleaning scan because it had written too many buffers. Buffers backend fsync reports the number of times a backend had to execute its own fsync call (normally the background writer handles those even when the backend does its own write).
-
checkpoints write stats
Background writer statistics on checkpoints. Checkpoint write time reports the total amount of time that has been spent in the portion of checkpoint processing where files are written to disk. Checkpoint sync time reports the total amount of time that has been spent in the portion of checkpoint processing where files are synchronized to disk.
-
Connections by type on all database
Connections by type including idle ones.
-
Affected tuples per operation on all database
Affected rows on databases grouped by statement family.
-
Cache hit/miss ratio on all database
Per database cache hit/miss ratio.
-
Commits/Rollbacks per second on all database
Number of commits / rollbacks per second and number of backends per database.
-
Write ratio on all database
Write ratio on databases excluding templates and postgres.
-
Read tuples on all database
Show entries returned from the index and live rows fetched from the tables. The latter will be less if any dead or not-yet-committed rows are fetched using the index.
-
Connections on all database
Number of clients connected to a database.
-
Number of deadlocks on all database
Number of deadlocks detected in this database.
-
Number of canceled queries on all database
Number of queries canceled due to conflicts with recovery in this database. [Conflicts occur only on standby servers]
-
Number of temporary files on all database
Number of temporary files created by queries per database.
-
Size of temporary data on all database
Amount of data written to temporary files created by queries per database.
-
Size of all tablespace
Tablespace size and location.
Size of pg_default (/var/lib/pgsql/data/base) tablespace
Tablespace size and location.
Size of pg_global (/var/lib/pgsql/data/global) tablespace
Tablespace size and location.
-
WAL files
Number of WAL file in the xlog directory.