• Home
  • SysInfo
  • Cluster
    • Databases sizes
    • Tablespaces sizes
    • Connections
      • Connections
      • Connections by type
    • Deadlocks
    • Cache utilization
    • Shared buffers statistics
      • Shared buffers utilization
      • Database in shared buffers
      • Usagecount in shared buffers
      • Usagecount in dirty buffers
    • Background writer
      • Bgwriter buffers written
      • Bgwriter buffers allocated
      • Bgwriter counters
    • Temporary files
      • Temporary files
      • Temporary files size
    • Wal / Checkpoint
      • Wal files
      • Checkpoints counter
      • Checkpoints write time
      • Archiver stats
    • Queries Reads / Writes
      • Read tuples
      • Write ratio
      • Read vs Write queries
      • Commits vs Rollbacks
    • Transaction throughput
    • Prepared transactions
    • Replication statistics
      • Wal bytes written
      • Replication lag
      • Canceled queries
      • Conflicts
    • Configurations
      • PostgreSQL configuration
      • PostgreSQL settings
      • PostgreSQL non default settings
      • Database/Roles settings
      • PostgreSQL ALTER SYSTEM configuration
      • PostgreSQL recovery configuration
      • PostgreSQL authorization
      • User Name Maps
      • Pgbouncer settings
  • Databases
    • postgres
      • Database info
      • Partitionned Tables
      • Tables statistics
        • Index scan ratio
        • Vacuums/analyzes
        • insert/update/delete
        • Live vs dead tuples
        • Size and tuples
        • Tables I/O stats
      • Indexes statistics
        • Size and tuples
        • Number of indexes
      • Buffercache Statistics
      • Database size
      • Connections
        • Connections
        • Connections by type
      • Cache utilization
      • Locks
        • Deadlocks
        • Locks per types
        • Locks per modes
        • Locks granted or not
      • Temporary files
        • Temporary files
        • Temporary files size
      • Queries Reads / Writes
        • Read tuples
        • Write ratio
        • Read vs Write queries
        • Commits vs Rollbacks
      • Transaction thoughput
      • Prepared transactions
      • Canceled queries
      • Conflicts
  • System
    • Cpu
    • Memory
    • Dirty memory
    • Swap
    • Memory workload
    • Load
    • Task list
    • Run queue
    • Context switches
    • Tasks created per second
    • Blocks
    • Transfers per second
    • Pages
      • Pages in/out
      • Pages faults
      • Pages scan
    • Devices
      • xvda
        • Cpu utilization
        • Read/write bytes per second
        • Transfert per second
        • Average I/O wait time
    • Network
      • eth0
        • Network utilization
        • Network errors
      • lo
        • Network utilization
        • Network errors
      • TCP
        • TCP utilization
        • TCP errors
    • Disk space use
      • Device xvda1
    • PostgreSQL
      • CPU
      • Context switches
      • Memory
      • Percent Memory use
      • Pages faults
      • I/O delay
      • Kb I/O
  • About




    PostgreSQL configuration

    Configuration directives and values defined in file postgresql.conf.

    data_directory = '/var/lib/postgresql/9.5/main' hba_file = '/etc/postgresql/9.5/main/pg_hba.conf' ident_file = '/etc/postgresql/9.5/main/pg_ident.conf' external_pid_file = '/var/run/postgresql/9.5-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 = 128MB dynamic_shared_memory_type = posix log_line_prefix = '%t [%p-%l] %q%u@%d ' log_timezone = 'America/Mexico_City' stats_temp_directory = '/var/run/postgresql/9.5-main.pg_stat_tmp' datestyle = 'iso, mdy' timezone = 'America/Mexico_City' lc_messages = 'en_US.utf-8' lc_monetary = 'en_US.utf-8' lc_numeric = 'en_US.utf-8' lc_time = 'en_US.utf-8' default_text_search_config = 'pg_catalog.english'

Report generated by pgCluu 3.3.

Right click + "Save image as ..." to save the graph as PNG image