Created
February 25, 2020 03:44
-
-
Save opan/f7ee4f8c59b59af3d43c75f93e8fc3ea to your computer and use it in GitHub Desktop.
Sample output from pgmetrics tools in JSON format
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "meta": { | |
| "version": "1.7", | |
| "at": 1582601656, | |
| "collected_dbs": [ | |
| "postgres" | |
| ], | |
| "local": true | |
| }, | |
| "start_time": 1582527353, | |
| "system_identifier": "", | |
| "checkpoint_lsn": "", | |
| "prior_lsn": "", | |
| "redo_lsn": "", | |
| "timeline_id": 0, | |
| "next_xid": 0, | |
| "oldest_xid": 0, | |
| "oldest_active_xid": 0, | |
| "checkpoint_time": 0, | |
| "wal_flush_lsn": "", | |
| "wal_insert_lsn": "", | |
| "wal_lsn": "", | |
| "is_in_recovery": true, | |
| "is_wal_replay_paused": false, | |
| "last_wal_receive_lsn": "0/525496E8", | |
| "last_wal_replay_lsn": "0/525496E8", | |
| "last_xact_replay_timestamp": 1582601649, | |
| "last_xact_xid": 0, | |
| "last_xact_time": 0, | |
| "wal_archiving": { | |
| "archived_count": 78, | |
| "last_archived_wal": "000000010000000000000051", | |
| "last_archived_time": 1582527655, | |
| "failed_count": 0, | |
| "last_failed_wal": "", | |
| "last_failed_time": 0, | |
| "stats_reset": 1582527353 | |
| }, | |
| "wal_count": 78, | |
| "wal_ready_count": 0, | |
| "notification_queue_usage": 0, | |
| "bg_writer": { | |
| "checkpoints_timed": 69, | |
| "checkpoints_req": 9, | |
| "checkpoint_write_time": 123529, | |
| "checkpoint_sync_time": 425, | |
| "buffers_checkpoint": 1248, | |
| "buffers_clean": 21333, | |
| "maxwritten_clean": 211, | |
| "buffers_backend": 525258, | |
| "buffers_backend_fsync": 0, | |
| "buffers_alloc": 357140, | |
| "stats_reset": 1582527353 | |
| }, | |
| "backends": [ | |
| { | |
| "db_name": "postgres", | |
| "role_name": "postgres", | |
| "application_name": "pgmetrics", | |
| "pid": 18303, | |
| "client_addr": "", | |
| "backend_start": 1582601657, | |
| "xact_start": 1582601657, | |
| "query_start": 1582601657, | |
| "state_change": 1582601657, | |
| "wait_event_type": "", | |
| "wait_event": "", | |
| "state": "active", | |
| "backend_xid": 0, | |
| "backend_xmin": 1188, | |
| "query": "SELECT COALESCE(datname, ''), COALESCE(usename, ''),\n\t\t\tCOALESCE(application_name, ''), COALESCE(pid, 0),\n\t\t\tCOALESCE(client_hostname::text, client_addr::text, ''),\n\t\t\tCOALESCE(EXTRACT(EPOCH FROM backend_start)::bigint, 0),\n\t\t\tCOALESCE(EXTRACT(EPOCH FROM xact_start)::bigint, 0),\n\t\t\tCOALESCE(EXTRACT(EPOCH FROM query_start)::bigint, 0),\n\t\t\tCOALESCE(EXTRACT(EPOCH FROM state_change)::bigint, 0),\n\t\t\tCOALESCE(waiting, FALSE),\n\t\t\tCOALESCE(state, ''), COALESCE(backend_xid, ''),\n\t\t\tCOALESCE(backend_xmin, ''), COALESCE(query, '')\n\t\t FROM pg_stat_activity\n\t\t ORDER BY pid ASC" | |
| } | |
| ], | |
| "roles": [ | |
| { | |
| "oid": 10, | |
| "name": "postgres", | |
| "rolsuper": true, | |
| "rolinherit": true, | |
| "rolcreaterole": true, | |
| "rolcreatedb": true, | |
| "rolcanlogin": true, | |
| "rolreplication": true, | |
| "rolbypassrls": true, | |
| "rolconnlimit": -1, | |
| "rolvaliduntil": 0, | |
| "memberof": [] | |
| }, | |
| { | |
| "oid": 16384, | |
| "name": "default-user", | |
| "rolsuper": true, | |
| "rolinherit": true, | |
| "rolcreaterole": false, | |
| "rolcreatedb": false, | |
| "rolcanlogin": true, | |
| "rolreplication": false, | |
| "rolbypassrls": false, | |
| "rolconnlimit": -1, | |
| "rolvaliduntil": 0, | |
| "memberof": [] | |
| }, | |
| { | |
| "oid": 16385, | |
| "name": "rep", | |
| "rolsuper": false, | |
| "rolinherit": true, | |
| "rolcreaterole": false, | |
| "rolcreatedb": false, | |
| "rolcanlogin": true, | |
| "rolreplication": true, | |
| "rolbypassrls": false, | |
| "rolconnlimit": -1, | |
| "rolvaliduntil": 0, | |
| "memberof": [] | |
| } | |
| ], | |
| "databases": [ | |
| { | |
| "oid": 12411, | |
| "name": "postgres", | |
| "datdba": 10, | |
| "dattablespace": 1663, | |
| "datconnlimit": -1, | |
| "age_datfrozenxid": 537, | |
| "numbackends": 1, | |
| "xact_commit": 218, | |
| "xact_rollback": 13, | |
| "blks_read": 396, | |
| "blks_hit": 32781, | |
| "tup_returned": 84497, | |
| "tup_fetched": 19768, | |
| "tup_inserted": 0, | |
| "tup_updated": 0, | |
| "tup_deleted": 0, | |
| "conflicts": 0, | |
| "temp_files": 0, | |
| "temp_bytes": 0, | |
| "deadlocks": 0, | |
| "blk_read_time": 0, | |
| "blk_write_time": 0, | |
| "stats_reset": 1582527531, | |
| "size": 7151788 | |
| }, | |
| { | |
| "oid": 16386, | |
| "name": "transaction-history-service", | |
| "datdba": 16384, | |
| "dattablespace": 1663, | |
| "datconnlimit": -1, | |
| "age_datfrozenxid": 537, | |
| "numbackends": 0, | |
| "xact_commit": 2, | |
| "xact_rollback": 0, | |
| "blks_read": 151, | |
| "blks_hit": 1067, | |
| "tup_returned": 1132, | |
| "tup_fetched": 711, | |
| "tup_inserted": 0, | |
| "tup_updated": 0, | |
| "tup_deleted": 0, | |
| "conflicts": 0, | |
| "temp_files": 0, | |
| "temp_bytes": 0, | |
| "deadlocks": 0, | |
| "blk_read_time": 0, | |
| "blk_write_time": 0, | |
| "stats_reset": 1582527574, | |
| "size": 1575780524 | |
| } | |
| ], | |
| "tablespaces": [ | |
| { | |
| "oid": 1663, | |
| "name": "pg_default", | |
| "owner": "postgres", | |
| "location": "/var/lib/postgresql/9.5/main", | |
| "size": 1597129736, | |
| "disk_used": 5851611136, | |
| "disk_total": 65986711552, | |
| "inodes_used": 59044, | |
| "inodes_total": 4104192 | |
| }, | |
| { | |
| "oid": 1664, | |
| "name": "pg_global", | |
| "owner": "postgres", | |
| "location": "/var/lib/postgresql/9.5/main", | |
| "size": 474944, | |
| "disk_used": 5851611136, | |
| "disk_total": 65986711552, | |
| "inodes_used": 59044, | |
| "inodes_total": 4104192 | |
| } | |
| ], | |
| "extensions": [ | |
| { | |
| "name": "plpgsql", | |
| "db_name": "postgres", | |
| "default_version": "1.0", | |
| "installed_version": "1.0", | |
| "comment": "PL/pgSQL procedural language" | |
| } | |
| ], | |
| "system": { | |
| "cpu_model": "Intel(R) Core(TM) i7-6820HQ CPU @ 2.70GHz", | |
| "num_cores": 1, | |
| "loadavg": 0, | |
| "memused": 131457024, | |
| "memfree": 68751360, | |
| "membuffers": 12328960, | |
| "memcached": 827858944, | |
| "swapused": 11673600, | |
| "swapfree": 1015926784, | |
| "hostname": "slave-01" | |
| }, | |
| "settings": { | |
| "DateStyle": { | |
| "setting": "ISO, MDY" | |
| }, | |
| "IntervalStyle": { | |
| "setting": "postgres" | |
| }, | |
| "TimeZone": { | |
| "setting": "Asia/Jakarta", | |
| "bootval": "GMT", | |
| "source": "/etc/postgresql/9.5/main/postgresql.conf:28" | |
| }, | |
| "allow_system_table_mods": { | |
| "setting": "off" | |
| }, | |
| "application_name": { | |
| "setting": "pgmetrics", | |
| "source": "client" | |
| }, | |
| "archive_command": { | |
| "setting": "cp %p /var/lib/postgresql/9.5/main/archive/%f", | |
| "source": "/etc/postgresql/9.5/main/postgresql.conf:12" | |
| }, | |
| "archive_mode": { | |
| "setting": "always", | |
| "bootval": "off", | |
| "source": "/etc/postgresql/9.5/main/postgresql.conf:13" | |
| }, | |
| "archive_timeout": { | |
| "setting": "0" | |
| }, | |
| "array_nulls": { | |
| "setting": "on" | |
| }, | |
| "authentication_timeout": { | |
| "setting": "60" | |
| }, | |
| "autovacuum": { | |
| "setting": "on" | |
| }, | |
| "autovacuum_analyze_scale_factor": { | |
| "setting": "0.1" | |
| }, | |
| "autovacuum_analyze_threshold": { | |
| "setting": "50" | |
| }, | |
| "autovacuum_freeze_max_age": { | |
| "setting": "200000000" | |
| }, | |
| "autovacuum_max_workers": { | |
| "setting": "3" | |
| }, | |
| "autovacuum_multixact_freeze_max_age": { | |
| "setting": "400000000" | |
| }, | |
| "autovacuum_naptime": { | |
| "setting": "60" | |
| }, | |
| "autovacuum_vacuum_cost_delay": { | |
| "setting": "20" | |
| }, | |
| "autovacuum_vacuum_cost_limit": { | |
| "setting": "-1" | |
| }, | |
| "autovacuum_vacuum_scale_factor": { | |
| "setting": "0.2" | |
| }, | |
| "autovacuum_vacuum_threshold": { | |
| "setting": "50" | |
| }, | |
| "autovacuum_work_mem": { | |
| "setting": "-1" | |
| }, | |
| "backslash_quote": { | |
| "setting": "safe_encoding" | |
| }, | |
| "bgwriter_delay": { | |
| "setting": "200" | |
| }, | |
| "bgwriter_lru_maxpages": { | |
| "setting": "100" | |
| }, | |
| "bgwriter_lru_multiplier": { | |
| "setting": "2" | |
| }, | |
| "block_size": { | |
| "setting": "8192" | |
| }, | |
| "bonjour": { | |
| "setting": "off" | |
| }, | |
| "bonjour_name": { | |
| "setting": "" | |
| }, | |
| "bytea_output": { | |
| "setting": "hex" | |
| }, | |
| "check_function_bodies": { | |
| "setting": "on" | |
| }, | |
| "checkpoint_completion_target": { | |
| "setting": "0.5" | |
| }, | |
| "checkpoint_timeout": { | |
| "setting": "300" | |
| }, | |
| "checkpoint_warning": { | |
| "setting": "30" | |
| }, | |
| "client_encoding": { | |
| "setting": "UTF8", | |
| "bootval": "SQL_ASCII", | |
| "source": "client" | |
| }, | |
| "client_min_messages": { | |
| "setting": "notice" | |
| }, | |
| "cluster_name": { | |
| "setting": "" | |
| }, | |
| "commit_delay": { | |
| "setting": "0" | |
| }, | |
| "commit_siblings": { | |
| "setting": "5" | |
| }, | |
| "config_file": { | |
| "setting": "/etc/postgresql/9.5/main/postgresql.conf", | |
| "source": "override" | |
| }, | |
| "constraint_exclusion": { | |
| "setting": "partition" | |
| }, | |
| "cpu_index_tuple_cost": { | |
| "setting": "0.005" | |
| }, | |
| "cpu_operator_cost": { | |
| "setting": "0.0025" | |
| }, | |
| "cpu_tuple_cost": { | |
| "setting": "0.01" | |
| }, | |
| "cursor_tuple_fraction": { | |
| "setting": "0.1" | |
| }, | |
| "data_checksums": { | |
| "setting": "off" | |
| }, | |
| "data_directory": { | |
| "setting": "/var/lib/postgresql/9.5/main", | |
| "source": "override" | |
| }, | |
| "data_sync_retry": { | |
| "setting": "off" | |
| }, | |
| "db_user_namespace": { | |
| "setting": "off" | |
| }, | |
| "deadlock_timeout": { | |
| "setting": "1000" | |
| }, | |
| "debug_assertions": { | |
| "setting": "off" | |
| }, | |
| "debug_pretty_print": { | |
| "setting": "on" | |
| }, | |
| "debug_print_parse": { | |
| "setting": "off" | |
| }, | |
| "debug_print_plan": { | |
| "setting": "off" | |
| }, | |
| "debug_print_rewritten": { | |
| "setting": "off" | |
| }, | |
| "default_statistics_target": { | |
| "setting": "100" | |
| }, | |
| "default_tablespace": { | |
| "setting": "" | |
| }, | |
| "default_text_search_config": { | |
| "setting": "pg_catalog.simple" | |
| }, | |
| "default_transaction_deferrable": { | |
| "setting": "off" | |
| }, | |
| "default_transaction_isolation": { | |
| "setting": "read committed" | |
| }, | |
| "default_transaction_read_only": { | |
| "setting": "off" | |
| }, | |
| "default_with_oids": { | |
| "setting": "off" | |
| }, | |
| "dynamic_library_path": { | |
| "setting": "$libdir" | |
| }, | |
| "dynamic_shared_memory_type": { | |
| "setting": "posix" | |
| }, | |
| "effective_cache_size": { | |
| "setting": "524288" | |
| }, | |
| "effective_io_concurrency": { | |
| "setting": "1" | |
| }, | |
| "enable_bitmapscan": { | |
| "setting": "on" | |
| }, | |
| "enable_hashagg": { | |
| "setting": "on" | |
| }, | |
| "enable_hashjoin": { | |
| "setting": "on" | |
| }, | |
| "enable_indexonlyscan": { | |
| "setting": "on" | |
| }, | |
| "enable_indexscan": { | |
| "setting": "on" | |
| }, | |
| "enable_material": { | |
| "setting": "on" | |
| }, | |
| "enable_mergejoin": { | |
| "setting": "on" | |
| }, | |
| "enable_nestloop": { | |
| "setting": "on" | |
| }, | |
| "enable_seqscan": { | |
| "setting": "on" | |
| }, | |
| "enable_sort": { | |
| "setting": "on" | |
| }, | |
| "enable_tidscan": { | |
| "setting": "on" | |
| }, | |
| "escape_string_warning": { | |
| "setting": "on" | |
| }, | |
| "event_source": { | |
| "setting": "PostgreSQL" | |
| }, | |
| "exit_on_error": { | |
| "setting": "off" | |
| }, | |
| "external_pid_file": { | |
| "setting": "/var/run/postgresql/9.5-main.pid", | |
| "source": "/etc/postgresql/9.5/main/postgresql.conf:9" | |
| }, | |
| "extra_float_digits": { | |
| "setting": "0" | |
| }, | |
| "from_collapse_limit": { | |
| "setting": "8" | |
| }, | |
| "fsync": { | |
| "setting": "on" | |
| }, | |
| "full_page_writes": { | |
| "setting": "on" | |
| }, | |
| "geqo": { | |
| "setting": "on" | |
| }, | |
| "geqo_effort": { | |
| "setting": "5" | |
| }, | |
| "geqo_generations": { | |
| "setting": "0" | |
| }, | |
| "geqo_pool_size": { | |
| "setting": "0" | |
| }, | |
| "geqo_seed": { | |
| "setting": "0" | |
| }, | |
| "geqo_selection_bias": { | |
| "setting": "2" | |
| }, | |
| "geqo_threshold": { | |
| "setting": "12" | |
| }, | |
| "gin_fuzzy_search_limit": { | |
| "setting": "0" | |
| }, | |
| "gin_pending_list_limit": { | |
| "setting": "4096" | |
| }, | |
| "hba_file": { | |
| "setting": "/etc/postgresql/9.5/main/pg_hba.conf", | |
| "source": "override" | |
| }, | |
| "hot_standby": { | |
| "setting": "on", | |
| "bootval": "off", | |
| "source": "/etc/postgresql/9.5/main/postgresql.conf:16" | |
| }, | |
| "hot_standby_feedback": { | |
| "setting": "off" | |
| }, | |
| "huge_pages": { | |
| "setting": "try" | |
| }, | |
| "ident_file": { | |
| "setting": "/etc/postgresql/9.5/main/pg_ident.conf", | |
| "source": "override" | |
| }, | |
| "ignore_checksum_failure": { | |
| "setting": "off" | |
| }, | |
| "ignore_system_indexes": { | |
| "setting": "off" | |
| }, | |
| "integer_datetimes": { | |
| "setting": "on" | |
| }, | |
| "join_collapse_limit": { | |
| "setting": "8" | |
| }, | |
| "krb_caseins_users": { | |
| "setting": "off" | |
| }, | |
| "krb_server_keyfile": { | |
| "setting": "FILE:/etc/postgresql-common/krb5.keytab" | |
| }, | |
| "lc_collate": { | |
| "setting": "en_US.UTF-8", | |
| "bootval": "C", | |
| "source": "override" | |
| }, | |
| "lc_ctype": { | |
| "setting": "en_US.UTF-8", | |
| "bootval": "C", | |
| "source": "override" | |
| }, | |
| "lc_messages": { | |
| "setting": "" | |
| }, | |
| "lc_monetary": { | |
| "setting": "C" | |
| }, | |
| "lc_numeric": { | |
| "setting": "C" | |
| }, | |
| "lc_time": { | |
| "setting": "C" | |
| }, | |
| "listen_addresses": { | |
| "setting": "*", | |
| "bootval": "localhost", | |
| "source": "/etc/postgresql/9.5/main/postgresql.conf:17" | |
| }, | |
| "lo_compat_privileges": { | |
| "setting": "off" | |
| }, | |
| "local_preload_libraries": { | |
| "setting": "" | |
| }, | |
| "lock_timeout": { | |
| "setting": "50", | |
| "bootval": "0", | |
| "source": "client" | |
| }, | |
| "log_autovacuum_min_duration": { | |
| "setting": "-1" | |
| }, | |
| "log_checkpoints": { | |
| "setting": "on", | |
| "bootval": "off", | |
| "source": "/etc/postgresql/9.5/main/postgresql.conf:18" | |
| }, | |
| "log_connections": { | |
| "setting": "on", | |
| "bootval": "off", | |
| "source": "/etc/postgresql/9.5/main/postgresql.conf:19" | |
| }, | |
| "log_destination": { | |
| "setting": "stderr" | |
| }, | |
| "log_directory": { | |
| "setting": "pg_log" | |
| }, | |
| "log_disconnections": { | |
| "setting": "on", | |
| "bootval": "off", | |
| "source": "/etc/postgresql/9.5/main/postgresql.conf:20" | |
| }, | |
| "log_duration": { | |
| "setting": "off" | |
| }, | |
| "log_error_verbosity": { | |
| "setting": "default" | |
| }, | |
| "log_executor_stats": { | |
| "setting": "off" | |
| }, | |
| "log_file_mode": { | |
| "setting": "0600", | |
| "bootval": "384", | |
| "source": "default" | |
| }, | |
| "log_filename": { | |
| "setting": "postgresql-%Y-%m-%d_%H%M%S.log" | |
| }, | |
| "log_hostname": { | |
| "setting": "off" | |
| }, | |
| "log_line_prefix": { | |
| "setting": "%t [%p]: [%l-1] user=%u,db=%d,app=%a,client=%h ", | |
| "source": "/etc/postgresql/9.5/main/postgresql.conf:21" | |
| }, | |
| "log_lock_waits": { | |
| "setting": "on", | |
| "bootval": "off", | |
| "source": "/etc/postgresql/9.5/main/postgresql.conf:22" | |
| }, | |
| "log_min_duration_statement": { | |
| "setting": "70", | |
| "bootval": "-1", | |
| "source": "/etc/postgresql/9.5/main/postgresql.conf:23" | |
| }, | |
| "log_min_error_statement": { | |
| "setting": "error" | |
| }, | |
| "log_min_messages": { | |
| "setting": "warning" | |
| }, | |
| "log_parser_stats": { | |
| "setting": "off" | |
| }, | |
| "log_planner_stats": { | |
| "setting": "off" | |
| }, | |
| "log_replication_commands": { | |
| "setting": "off" | |
| }, | |
| "log_rotation_age": { | |
| "setting": "1440" | |
| }, | |
| "log_rotation_size": { | |
| "setting": "10240" | |
| }, | |
| "log_statement": { | |
| "setting": "none" | |
| }, | |
| "log_statement_stats": { | |
| "setting": "off" | |
| }, | |
| "log_temp_files": { | |
| "setting": "0", | |
| "bootval": "-1", | |
| "source": "/etc/postgresql/9.5/main/postgresql.conf:24" | |
| }, | |
| "log_timezone": { | |
| "setting": "Asia/Jakarta", | |
| "bootval": "GMT", | |
| "source": "/etc/postgresql/9.5/main/postgresql.conf:25" | |
| }, | |
| "log_truncate_on_rotation": { | |
| "setting": "off" | |
| }, | |
| "logging_collector": { | |
| "setting": "off" | |
| }, | |
| "maintenance_work_mem": { | |
| "setting": "65536" | |
| }, | |
| "max_connections": { | |
| "setting": "1000", | |
| "bootval": "100", | |
| "source": "/etc/postgresql/9.5/main/postgresql.conf:26" | |
| }, | |
| "max_files_per_process": { | |
| "setting": "1000" | |
| }, | |
| "max_function_args": { | |
| "setting": "100" | |
| }, | |
| "max_identifier_length": { | |
| "setting": "63" | |
| }, | |
| "max_index_keys": { | |
| "setting": "32" | |
| }, | |
| "max_locks_per_transaction": { | |
| "setting": "64" | |
| }, | |
| "max_pred_locks_per_transaction": { | |
| "setting": "64" | |
| }, | |
| "max_prepared_transactions": { | |
| "setting": "0" | |
| }, | |
| "max_replication_slots": { | |
| "setting": "0" | |
| }, | |
| "max_stack_depth": { | |
| "setting": "2048", | |
| "bootval": "100", | |
| "source": "environment variable" | |
| }, | |
| "max_standby_archive_delay": { | |
| "setting": "30000" | |
| }, | |
| "max_standby_streaming_delay": { | |
| "setting": "30000" | |
| }, | |
| "max_wal_senders": { | |
| "setting": "8", | |
| "bootval": "0", | |
| "source": "/etc/postgresql/9.5/main/postgresql.conf:27" | |
| }, | |
| "max_wal_size": { | |
| "setting": "64" | |
| }, | |
| "max_worker_processes": { | |
| "setting": "8" | |
| }, | |
| "min_wal_size": { | |
| "setting": "5" | |
| }, | |
| "operator_precedence_warning": { | |
| "setting": "off" | |
| }, | |
| "password_encryption": { | |
| "setting": "on" | |
| }, | |
| "port": { | |
| "setting": "5432" | |
| }, | |
| "post_auth_delay": { | |
| "setting": "0" | |
| }, | |
| "pre_auth_delay": { | |
| "setting": "0" | |
| }, | |
| "quote_all_identifiers": { | |
| "setting": "off" | |
| }, | |
| "random_page_cost": { | |
| "setting": "4" | |
| }, | |
| "restart_after_crash": { | |
| "setting": "on" | |
| }, | |
| "row_security": { | |
| "setting": "on" | |
| }, | |
| "search_path": { | |
| "setting": "\"$user\", public" | |
| }, | |
| "segment_size": { | |
| "setting": "131072" | |
| }, | |
| "seq_page_cost": { | |
| "setting": "1" | |
| }, | |
| "server_encoding": { | |
| "setting": "UTF8", | |
| "bootval": "SQL_ASCII", | |
| "source": "override" | |
| }, | |
| "server_version": { | |
| "setting": "9.5.21" | |
| }, | |
| "server_version_num": { | |
| "setting": "90521" | |
| }, | |
| "session_preload_libraries": { | |
| "setting": "" | |
| }, | |
| "session_replication_role": { | |
| "setting": "origin" | |
| }, | |
| "shared_buffers": { | |
| "setting": "1024" | |
| }, | |
| "shared_preload_libraries": { | |
| "setting": "" | |
| }, | |
| "sql_inheritance": { | |
| "setting": "on" | |
| }, | |
| "ssl": { | |
| "setting": "off" | |
| }, | |
| "ssl_ca_file": { | |
| "setting": "" | |
| }, | |
| "ssl_cert_file": { | |
| "setting": "server.crt" | |
| }, | |
| "ssl_ciphers": { | |
| "setting": "HIGH:MEDIUM:+3DES:!aNULL" | |
| }, | |
| "ssl_crl_file": { | |
| "setting": "" | |
| }, | |
| "ssl_ecdh_curve": { | |
| "setting": "prime256v1" | |
| }, | |
| "ssl_key_file": { | |
| "setting": "server.key" | |
| }, | |
| "ssl_prefer_server_ciphers": { | |
| "setting": "on" | |
| }, | |
| "standard_conforming_strings": { | |
| "setting": "on" | |
| }, | |
| "statement_timeout": { | |
| "setting": "5000", | |
| "bootval": "0", | |
| "source": "client" | |
| }, | |
| "stats_temp_directory": { | |
| "setting": "/var/run/postgresql/9.5-main.pg_stat_tmp", | |
| "bootval": "pg_stat_tmp", | |
| "source": "/etc/postgresql/9.5/main/postgresql.conf:10" | |
| }, | |
| "superuser_reserved_connections": { | |
| "setting": "3" | |
| }, | |
| "synchronize_seqscans": { | |
| "setting": "on" | |
| }, | |
| "synchronous_commit": { | |
| "setting": "on" | |
| }, | |
| "synchronous_standby_names": { | |
| "setting": "" | |
| }, | |
| "syslog_facility": { | |
| "setting": "local0" | |
| }, | |
| "syslog_ident": { | |
| "setting": "postgres" | |
| }, | |
| "tcp_keepalives_count": { | |
| "setting": "0" | |
| }, | |
| "tcp_keepalives_idle": { | |
| "setting": "0" | |
| }, | |
| "tcp_keepalives_interval": { | |
| "setting": "0" | |
| }, | |
| "temp_buffers": { | |
| "setting": "1024" | |
| }, | |
| "temp_file_limit": { | |
| "setting": "-1" | |
| }, | |
| "temp_tablespaces": { | |
| "setting": "" | |
| }, | |
| "timezone_abbreviations": { | |
| "setting": "Default", | |
| "source": "default" | |
| }, | |
| "trace_notify": { | |
| "setting": "off" | |
| }, | |
| "trace_recovery_messages": { | |
| "setting": "log" | |
| }, | |
| "trace_sort": { | |
| "setting": "off" | |
| }, | |
| "track_activities": { | |
| "setting": "on" | |
| }, | |
| "track_activity_query_size": { | |
| "setting": "1024" | |
| }, | |
| "track_commit_timestamp": { | |
| "setting": "off" | |
| }, | |
| "track_counts": { | |
| "setting": "on" | |
| }, | |
| "track_functions": { | |
| "setting": "none" | |
| }, | |
| "track_io_timing": { | |
| "setting": "off" | |
| }, | |
| "transaction_deferrable": { | |
| "setting": "off" | |
| }, | |
| "transaction_isolation": { | |
| "setting": "read committed", | |
| "bootval": "default", | |
| "source": "override" | |
| }, | |
| "transaction_read_only": { | |
| "setting": "on", | |
| "bootval": "off", | |
| "source": "override" | |
| }, | |
| "transform_null_equals": { | |
| "setting": "off" | |
| }, | |
| "unix_socket_directories": { | |
| "setting": "/var/run/postgresql" | |
| }, | |
| "unix_socket_group": { | |
| "setting": "" | |
| }, | |
| "unix_socket_permissions": { | |
| "setting": "0777", | |
| "bootval": "511", | |
| "source": "default" | |
| }, | |
| "update_process_title": { | |
| "setting": "on" | |
| }, | |
| "vacuum_cost_delay": { | |
| "setting": "0" | |
| }, | |
| "vacuum_cost_limit": { | |
| "setting": "200" | |
| }, | |
| "vacuum_cost_page_dirty": { | |
| "setting": "20" | |
| }, | |
| "vacuum_cost_page_hit": { | |
| "setting": "1" | |
| }, | |
| "vacuum_cost_page_miss": { | |
| "setting": "10" | |
| }, | |
| "vacuum_defer_cleanup_age": { | |
| "setting": "0" | |
| }, | |
| "vacuum_freeze_min_age": { | |
| "setting": "50000000" | |
| }, | |
| "vacuum_freeze_table_age": { | |
| "setting": "150000000" | |
| }, | |
| "vacuum_multixact_freeze_min_age": { | |
| "setting": "5000000" | |
| }, | |
| "vacuum_multixact_freeze_table_age": { | |
| "setting": "150000000" | |
| }, | |
| "wal_block_size": { | |
| "setting": "8192" | |
| }, | |
| "wal_buffers": { | |
| "setting": "32", | |
| "bootval": "-1", | |
| "source": "override" | |
| }, | |
| "wal_compression": { | |
| "setting": "off" | |
| }, | |
| "wal_keep_segments": { | |
| "setting": "50", | |
| "bootval": "0", | |
| "source": "/etc/postgresql/9.5/main/postgresql.conf:30" | |
| }, | |
| "wal_level": { | |
| "setting": "hot_standby", | |
| "bootval": "minimal", | |
| "source": "/etc/postgresql/9.5/main/postgresql.conf:31" | |
| }, | |
| "wal_log_hints": { | |
| "setting": "off" | |
| }, | |
| "wal_receiver_status_interval": { | |
| "setting": "10" | |
| }, | |
| "wal_receiver_timeout": { | |
| "setting": "60000" | |
| }, | |
| "wal_retrieve_retry_interval": { | |
| "setting": "5000" | |
| }, | |
| "wal_segment_size": { | |
| "setting": "2048" | |
| }, | |
| "wal_sender_timeout": { | |
| "setting": "60000" | |
| }, | |
| "wal_sync_method": { | |
| "setting": "fdatasync" | |
| }, | |
| "wal_writer_delay": { | |
| "setting": "200" | |
| }, | |
| "work_mem": { | |
| "setting": "4096" | |
| }, | |
| "xmlbinary": { | |
| "setting": "base64" | |
| }, | |
| "xmloption": { | |
| "setting": "content" | |
| }, | |
| "zero_damaged_pages": { | |
| "setting": "off" | |
| } | |
| }, | |
| "locks": [ | |
| { | |
| "locktype": "relation", | |
| "db_name": "postgres", | |
| "pid": 18303, | |
| "mode": "AccessShareLock", | |
| "granted": true, | |
| "relation_oid": 11673 | |
| }, | |
| { | |
| "locktype": "virtualxid", | |
| "pid": 18303, | |
| "mode": "ExclusiveLock", | |
| "granted": true | |
| }, | |
| { | |
| "locktype": "virtualxid", | |
| "pid": 16626, | |
| "mode": "ExclusiveLock", | |
| "granted": true | |
| }, | |
| { | |
| "locktype": "relation", | |
| "pid": 18303, | |
| "mode": "AccessShareLock", | |
| "granted": true, | |
| "relation_oid": 1262 | |
| }, | |
| { | |
| "locktype": "relation", | |
| "pid": 18303, | |
| "mode": "AccessShareLock", | |
| "granted": true, | |
| "relation_oid": 2672 | |
| }, | |
| { | |
| "locktype": "relation", | |
| "pid": 18303, | |
| "mode": "AccessShareLock", | |
| "granted": true, | |
| "relation_oid": 2671 | |
| } | |
| ], | |
| "highwal": 109 | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment