-
Shared buffers utilisation per database
Show statistics about percentage of shared buffer used per database.
-
Percentage of each databases loaded in shared buffers
Show statistics about percentage of each databases loaded in shared buffer.
-
Dirty shared buffers usagecount distribution
Show statistics about usagecount distribution in dirty shared buffer.
NO DATASET
-
Size of all database
Sizes of databases
-
Shared buffers usagecount distribution
Show statistics about usagecount distribution in shared buffer.
-
User Name Maps
Different operating system user / database user mappings might be needed for different connections. They are defined in file pg_ident.conf.
NO DATASET
-
PostgreSQL settings
Configuration directives and values defined in pg_settings.
Autovacuum autovacuum on autovacuum_analyze_scale_factor 0.1 autovacuum_analyze_threshold 50 autovacuum_freeze_max_age 200000000 autovacuum_max_workers 3 autovacuum_multixact_freeze_max_age 400000000 autovacuum_naptime 60 autovacuum_vacuum_cost_delay 20 autovacuum_vacuum_cost_limit -1 autovacuum_vacuum_scale_factor 0.2 autovacuum_vacuum_threshold 50 Client Connection Defaults / Locale and Formatting client_encoding UTF8 DateStyle ISO. MDY default_text_search_config pg_catalog.french extra_float_digits 0 IntervalStyle postgres lc_collate fr_FR.utf8 lc_ctype fr_FR.utf8 lc_messages en_US.UTF-8 lc_monetary fr_FR.UTF-8 lc_numeric fr_FR.UTF-8 lc_time fr_FR.UTF-8 server_encoding UTF8 TimeZone localtime timezone_abbreviations Default Client Connection Defaults / Other Defaults dynamic_library_path $libdir gin_fuzzy_search_limit 0 local_preload_libraries "" tcp_keepalives_count 0 tcp_keepalives_idle 0 tcp_keepalives_interval 0 Client Connection Defaults / Statement Behavior bytea_output hex check_function_bodies on default_tablespace "" default_transaction_deferrable off default_transaction_isolation read committed default_transaction_read_only off lock_timeout 0 search_path """$user"".public" session_replication_role origin statement_timeout 0 temp_tablespaces "" transaction_deferrable off transaction_isolation read committed transaction_read_only off vacuum_freeze_min_age 50000000 vacuum_freeze_table_age 150000000 vacuum_multixact_freeze_min_age 5000000 vacuum_multixact_freeze_table_age 150000000 xmlbinary base64 xmloption content Connections and Authentication / Connection Settings bonjour off bonjour_name "" listen_addresses localhost max_connections 100 port 5432 superuser_reserved_connections 3 unix_socket_directories /var/run/postgresql unix_socket_group "" unix_socket_permissions 0777 Connections and Authentication / Security and Authentication authentication_timeout 60 db_user_namespace off krb_caseins_users off krb_server_keyfile FILE:/etc/postgresql-common/krb5.keytab krb_srvname postgres password_encryption on ssl on ssl_ca_file "" ssl_cert_file /etc/ssl/certs/ssl-cert-snakeoil.pem ssl_ciphers DEFAULT:!LOW:!EXP:!MD5:@STRENGTH ssl_crl_file "" ssl_key_file /etc/ssl/private/ssl-cert-snakeoil.key ssl_renegotiation_limit 524288 Developer Options allow_system_table_mods off debug_assertions off ignore_checksum_failure off ignore_system_indexes off post_auth_delay 0 pre_auth_delay 0 trace_notify off trace_recovery_messages log trace_sort off zero_damaged_pages off Error Handling exit_on_error off restart_after_crash on File Locations config_file /etc/postgresql/9.3/main/postgresql.conf data_directory /var/lib/postgresql/9.3/main external_pid_file /var/run/postgresql/9.3-main.pid hba_file /etc/postgresql/9.3/main/pg_hba.conf ident_file /etc/postgresql/9.3/main/pg_ident.conf Lock Management deadlock_timeout 1000 max_locks_per_transaction 6400 max_pred_locks_per_transaction 64 Preset Options block_size 8192 integer_datetimes on max_function_args 100 max_identifier_length 63 max_index_keys 32 segment_size 131072 server_version 9.3.3 server_version_num 90303 wal_block_size 8192 wal_segment_size 2048 Query Tuning / Genetic Query Optimizer geqo on geqo_effort 5 geqo_generations 0 geqo_pool_size 0 geqo_seed 0 geqo_selection_bias 2 geqo_threshold 12 Query Tuning / Other Planner Options constraint_exclusion partition cursor_tuple_fraction 0.1 default_statistics_target 100 from_collapse_limit 8 join_collapse_limit 8 Query Tuning / Planner Cost Constants cpu_index_tuple_cost 0.005 cpu_operator_cost 0.0025 cpu_tuple_cost 0.01 effective_cache_size 262144 random_page_cost 3 seq_page_cost 1 Query Tuning / Planner Method Configuration enable_bitmapscan on enable_hashagg on enable_hashjoin on enable_indexonlyscan on enable_indexscan on enable_material on enable_mergejoin on enable_nestloop on enable_seqscan on enable_sort on enable_tidscan on Replication / Master Server synchronous_standby_names "" vacuum_defer_cleanup_age 0 Replication / Sending Servers max_wal_senders 5 wal_keep_segments 0 wal_sender_timeout 60000 Replication / Standby Servers hot_standby on hot_standby_feedback off max_standby_archive_delay 30000 max_standby_streaming_delay 30000 wal_receiver_status_interval 10 wal_receiver_timeout 60000 Reporting and Logging / What to Log application_name psql debug_pretty_print on debug_print_parse off debug_print_plan off debug_print_rewritten off log_autovacuum_min_duration -1 log_checkpoints off log_connections off log_disconnections off log_duration off log_error_verbosity default log_hostname off log_line_prefix %t [%p]: [%l-1] user=%u.db=%d.host=%h log_lock_waits off log_statement none log_temp_files -1 log_timezone localtime Reporting and Logging / When to Log client_min_messages notice log_min_duration_statement 1000 log_min_error_statement error log_min_messages warning Reporting and Logging / Where to Log event_source PostgreSQL log_destination stderr log_directory pg_log log_file_mode 0600 log_filename postgresql-%Y-%m-%d_%H%M%S.log log_rotation_age 1440 log_rotation_size 10240 log_truncate_on_rotation off logging_collector off syslog_facility local0 syslog_ident postgres Resource Usage / Asynchronous Behavior effective_io_concurrency 4 Resource Usage / Background Writer bgwriter_delay 200 bgwriter_lru_maxpages 100 bgwriter_lru_multiplier 2 Resource Usage / Cost-Based Vacuum Delay vacuum_cost_delay 0 vacuum_cost_limit 200 vacuum_cost_page_dirty 20 vacuum_cost_page_hit 1 vacuum_cost_page_miss 10 Resource Usage / Disk temp_file_limit -1 Resource Usage / Kernel Resources max_files_per_process 1000 shared_preload_libraries "" Resource Usage / Memory maintenance_work_mem 524288 max_prepared_transactions 0 max_stack_depth 2048 shared_buffers 65536 temp_buffers 1024 track_activity_query_size 1024 work_mem 4096 Statistics / Monitoring log_executor_stats off log_parser_stats off log_planner_stats off log_statement_stats off Statistics / Query and Index Statistics Collector stats_temp_directory pg_stat_tmp track_activities on track_counts on track_functions none track_io_timing on update_process_title on Version and Platform Compatibility / Other Platforms and Clients transform_null_equals off Version and Platform Compatibility / Previous PostgreSQL Versions array_nulls on backslash_quote safe_encoding default_with_oids off escape_string_warning on lo_compat_privileges off quote_all_identifiers off sql_inheritance on standard_conforming_strings on synchronize_seqscans on Write-Ahead Log / Archiving archive_command pbzip2 < %p > /tmp/%f && rsync -a /tmp/%f 12.34.56.78:/var/lib/postgresql/9.3/wals/main/%f && rm /tmp/%f archive_mode on archive_timeout 0 Write-Ahead Log / Checkpoints checkpoint_completion_target 0.9 checkpoint_segments 16 checkpoint_timeout 300 checkpoint_warning 30 Write-Ahead Log / Settings commit_delay 0 commit_siblings 5 fsync on full_page_writes on synchronous_commit on wal_buffers 2048 wal_level hot_standby wal_sync_method fdatasync wal_writer_delay 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 by 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 table. 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.
NO DATASET
Size of temporary data on all database
Amount of data written to temporary files created by queries per database.
Conflicts per type on all database
Per database statistics about query cancels occurring due to conflicts with recovery on standby servers.
NO DATASET
Xlog written
Number of Xlog data written per second
Replication lag with 212.85.154.137
Lag of replication between the master and the slave in KiloBytes
Size of all tablespace
Sizes of tablespaces
Size of test_tbsp (/var/lib/postgresql/9.2/tbsps) tablespace
Sizes of tablespaces
WAL files
Number of WAL file in the xlog directory
Pgbouncer settings
Configuration directives and values defined in file pgbouncer.ini.
pgbench1 = host=127.0.0.1 dbname=pgbench1 port=5432 logfile = /var/log/postgresql/pgbouncer.log pidfile = /var/run/postgresql/pgbouncer.pid listen_addr = 127.0.0.1 listen_port = 6432 unix_socket_dir = /var/run/postgresql auth_type = trust auth_file = /etc/pgbouncer/userlist.txt admin_users = postgres pool_mode = session server_reset_query = DISCARD ALL max_client_conn = 100 default_pool_size = 20PostgreSQL configuration
Configuration directives and values defined in file postgresql.conf.
data_directory = '/var/lib/postgresql/9.3/main' hba_file = '/etc/postgresql/9.3/main/pg_hba.conf' ident_file = '/etc/postgresql/9.3/main/pg_ident.conf' external_pid_file = '/var/run/postgresql/9.3-main.pid' port = 5432 max_connections = 100 unix_socket_directories = '/var/run/postgresql' ssl = true ssl_cert_file = '/etc/ssl/certs/ssl-cert-snakeoil.pem' ssl_key_file = '/etc/ssl/private/ssl-cert-snakeoil.key' shared_buffers = 512MB work_mem = 4MB maintenance_work_mem = 512MB effective_io_concurrency = 4 wal_level = hot_standby checkpoint_segments = 16 checkpoint_completion_target = 0.9 archive_mode = on archive_command = 'pbzip2 < %p > /tmp/%f && rsync -a /tmp/%f 12.34.56.78:/var/lib/postgresql/9.3/wals/main/%f && rm /tmp/%f' max_wal_senders = 5 hot_standby = on random_page_cost = 3.0 effective_cache_size = 2048MB log_min_duration_statement = 1000 log_line_prefix = '%t [%p]: [%l-1] user=%u,db=%d,host=%h ' log_timezone = 'localtime' track_io_timing = on datestyle = 'iso, mdy' timezone = 'localtime' lc_messages = 'en_US.UTF-8' lc_monetary = 'fr_FR.UTF-8' lc_numeric = 'fr_FR.UTF-8' lc_time = 'fr_FR.UTF-8' default_text_search_config = 'pg_catalog.french' max_locks_per_transaction = 6400