• 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
      • Background writer buffers
      • Background writer counters
    • Temporary files
      • Temporary files
      • Temporary files size
    • Wal / Checkpoint
      • Wal files
      • Wal bytes written
      • Checkpoints counter
      • Checkpoints write time
      • Archiver stats
    • Queries Reads / Writes
      • Read tuples
      • Write ratio
      • Read vs Write queries
      • Commits vs Rollbacks
    • Replication statistics
      • Replication lag
      • Canceled queries
      • Conflicts
    • Configurations
      • PostgreSQL configuration
      • PostgreSQL settings
      • Database/Roles settings
      • PostgreSQL ALTER SYSTEM configuration
      • PostgreSQL recovery configuration
      • PostgreSQL authorization
      • User Name Maps
      • Pgbouncer settings
  • Databases
    • engine
      • Database info
      • Tables statistics
        • Size and tuples
      • Indexes statistics
        • Size and tuples
        • Unused Indexes
        • Redundant indexes
        • Missing indexes
      • Buffercache Statistics
      • Statements 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
      • Canceled queries
      • Conflicts
    • engine2
      • Database info
      • Tables statistics
      • Indexes statistics
      • Buffercache Statistics
      • Statements 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
      • Canceled queries
      • Conflicts
    • engine_dao_tests
      • Database info
      • Tables statistics
      • Indexes statistics
      • Buffercache Statistics
      • Statements 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
      • Canceled queries
      • Conflicts
    • postgres
      • Database info
      • Tables statistics
      • Indexes statistics
      • Buffercache Statistics
      • Statements 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
      • Canceled queries
      • Conflicts
  • System
    • Cpu
    • Memory
    • Swap
    • Load
    • Task list
    • Run queue
    • Context switches
    • Tasks created per second
    • Blocks
    • Transfers per second
    • Pages
    • Devices
      • sda
        • Cpu utilization
        • Read/write bytes per second
        • Transfert per second
        • Average service time
      • luks-9a431792-a6b7-43f9-9f68-b77a9e4784ba
        • Cpu utilization
        • Read/write bytes per second
        • Transfert per second
        • Average service time
      • fedora_dhcp131--31-root
        • Cpu utilization
        • Read/write bytes per second
        • Transfert per second
        • Average service time
      • fedora_dhcp131--31-swap
        • Cpu utilization
        • Read/write bytes per second
        • Transfert per second
        • Average service time
      • fedora_dhcp131--31-home
        • Cpu utilization
        • Read/write bytes per second
        • Transfert per second
        • Average service time
      • loop0
        • Cpu utilization
        • Read/write bytes per second
        • Transfert per second
        • Average service time
      • loop1
        • Cpu utilization
        • Read/write bytes per second
        • Transfert per second
        • Average service time
      • docker-253:1-632-pool
        • Cpu utilization
        • Read/write bytes per second
        • Transfert per second
        • Average service time
    • Network
      • wlp4s0
        • Network utilization
        • Network errors
      • virbr0-nic
        • Network utilization
        • Network errors
      • docker0
        • Network utilization
        • Network errors
      • bond0
        • Network utilization
        • Network errors
      • virbr0
        • Network utilization
        • Network errors
      • lo
        • Network utilization
        • Network errors
      • em1
        • Network utilization
        • Network errors
  • About




  • Size of all database

    Database sizes.





  • Database/Roles settings

    Configuration directives and values defined with ALTER DATABASE and ALTER ROLE.

    DatabaseRoleSettings
    engineAll{client_min_messages=error}
    engine2All{client_min_messages=error}
    engine_dao_testsAll{client_min_messages=error}




  • PostgreSQL settings

    Configuration directives and values defined in pg_settings.

    Autovacuum
    NameCurrentUnitReset valBoot val
    autovacuumon0onon
    autovacuum_analyze_scale_factor0.100.10.1
    autovacuum_analyze_threshold50""5050
    autovacuum_freeze_max_age200000000""200000000200000000
    autovacuum_max_workers3""33
    autovacuum_multixact_freeze_max_age400000000""400000000400000000
    autovacuum_naptime60s6060
    autovacuum_vacuum_cost_delay20ms2020
    autovacuum_vacuum_cost_limit-1""-1-1
    autovacuum_vacuum_scale_factor0.200.20.2
    autovacuum_vacuum_threshold50""5050
    Client Connection Defaults / Locale and Formatting
    NameCurrentUnitReset valBoot val
    client_encodingUTF80UTF8SQL_ASCII
    DateStyleISO. MDY0ISO. MDYISO. MDY
    default_text_search_configpg_catalog.english0pg_catalog.englishpg_catalog.simple
    extra_float_digits0""
    IntervalStylepostgres0postgrespostgres
    lc_collateen_US.UTF-80en_US.UTF-8C
    lc_ctypeen_US.UTF-80en_US.UTF-8C
    lc_messagesen_US.UTF-80en_US.UTF-8""
    lc_monetaryen_US.UTF-80en_US.UTF-8C
    lc_numericen_US.UTF-80en_US.UTF-8C
    lc_timeen_US.UTF-80en_US.UTF-8C
    server_encodingUTF80UTF8SQL_ASCII
    TimeZoneEurope/Prague0Europe/PragueGMT
    timezone_abbreviationsDefault0Default
    Client Connection Defaults / Other Defaults
    NameCurrentUnitReset valBoot val
    dynamic_library_path$libdir0$libdir$libdir
    gin_fuzzy_search_limit0""
    local_preload_libraries""0""""
    tcp_keepalives_count0""
    tcp_keepalives_idle0s
    tcp_keepalives_interval0s
    Client Connection Defaults / Statement Behavior
    NameCurrentUnitReset valBoot val
    bytea_outputhex0hexhex
    check_function_bodieson0onon
    default_tablespace""0""""
    default_transaction_deferrableoff0offoff
    default_transaction_isolationread committed0read committedread committed
    default_transaction_read_onlyoff0offoff
    lock_timeout0ms
    search_path"""$user"".public"0"""$user"".public""""$user"".public"
    session_replication_roleorigin0originorigin
    statement_timeout0ms
    temp_tablespaces""0""""
    transaction_deferrableoff0offoff
    transaction_isolationread committed0defaultdefault
    transaction_read_onlyoff0offoff
    vacuum_freeze_min_age50000000""5000000050000000
    vacuum_freeze_table_age150000000""150000000150000000
    vacuum_multixact_freeze_min_age5000000""50000005000000
    vacuum_multixact_freeze_table_age150000000""150000000150000000
    xmlbinarybase640base64base64
    xmloptioncontent0contentcontent
    Connections and Authentication / Connection Settings
    NameCurrentUnitReset valBoot val
    bonjouroff0offoff
    bonjour_name""0""""
    listen_addresseslocalhost0localhostlocalhost
    max_connections150""150100
    port5432""54325432
    superuser_reserved_connections3""33
    unix_socket_directories/var/run/postgresql. /tmp0/var/run/postgresql. /tmp/var/run/postgresql. /tmp
    unix_socket_group""0""""
    unix_socket_permissions0777""511511
    Connections and Authentication / Security and Authentication
    NameCurrentUnitReset valBoot val
    authentication_timeout60s6060
    db_user_namespaceoff0offoff
    krb_caseins_usersoff0offoff
    krb_server_keyfileFILE:/etc/krb5.keytab0FILE:/etc/krb5.keytabFILE:/etc/krb5.keytab
    krb_srvnamepostgres0postgrespostgres
    password_encryptionon0onon
    ssloff0offoff
    ssl_ca_file""0""""
    ssl_cert_fileserver.crt0server.crtserver.crt
    ssl_ciphersDEFAULT:!LOW:!EXP:!MD5:@STRENGTH0DEFAULT:!LOW:!EXP:!MD5:@STRENGTHDEFAULT:!LOW:!EXP:!MD5:@STRENGTH
    ssl_crl_file""0""""
    ssl_key_fileserver.key0server.keyserver.key
    ssl_renegotiation_limit524288kB524288524288
    Customized Options
    NameCurrentUnitReset valBoot val
    pg_stat_statements.max10000""100001000
    pg_stat_statements.saveon0onon
    pg_stat_statements.trackall0alltop
    pg_stat_statements.track_utilityon0onon
    Developer Options
    NameCurrentUnitReset valBoot val
    allow_system_table_modsoff0offoff
    debug_assertionsoff0offoff
    ignore_checksum_failureoff0offoff
    ignore_system_indexesoff0offoff
    post_auth_delay0s
    pre_auth_delay0s
    trace_notifyoff0offoff
    trace_recovery_messageslog0loglog
    trace_sortoff0offoff
    zero_damaged_pagesoff0offoff
    Error Handling
    NameCurrentUnitReset valBoot val
    exit_on_erroroff0offoff
    restart_after_crashon0onon
    File Locations
    NameCurrentUnitReset valBoot val
    config_file/var/lib/pgsql/data/postgresql.conf0/var/lib/pgsql/data/postgresql.conf
    data_directory/var/lib/pgsql/data0/var/lib/pgsql/data
    external_pid_file""0
    hba_file/var/lib/pgsql/data/pg_hba.conf0/var/lib/pgsql/data/pg_hba.conf
    ident_file/var/lib/pgsql/data/pg_ident.conf0/var/lib/pgsql/data/pg_ident.conf
    Lock Management
    NameCurrentUnitReset valBoot val
    deadlock_timeout1000ms10001000
    max_locks_per_transaction64""6464
    max_pred_locks_per_transaction64""6464
    Preset Options
    NameCurrentUnitReset valBoot val
    block_size8192""81928192
    data_checksumsoff0offoff
    integer_datetimeson0onon
    max_function_args100""100100
    max_identifier_length63""6363
    max_index_keys32""3232
    segment_size1310728kB131072131072
    server_version9.3.909.3.99.3.9
    server_version_num90309""9030990309
    wal_block_size8192""81928192
    wal_segment_size20488kB20482048
    Query Tuning / Genetic Query Optimizer
    NameCurrentUnitReset valBoot val
    geqoon0onon
    geqo_effort5""55
    geqo_generations0""
    geqo_pool_size0""
    geqo_seed00
    geqo_selection_bias2022
    geqo_threshold12""1212
    Query Tuning / Other Planner Options
    NameCurrentUnitReset valBoot val
    constraint_exclusionpartition0partitionpartition
    cursor_tuple_fraction0.100.10.1
    default_statistics_target100""100100
    from_collapse_limit8""88
    join_collapse_limit8""88
    Query Tuning / Planner Cost Constants
    NameCurrentUnitReset valBoot val
    cpu_index_tuple_cost0.00500.0050.005
    cpu_operator_cost0.002500.00250.0025
    cpu_tuple_cost0.0100.010.01
    effective_cache_size163848kB1638416384
    random_page_cost4044
    seq_page_cost1011
    Query Tuning / Planner Method Configuration
    NameCurrentUnitReset valBoot val
    enable_bitmapscanon0onon
    enable_hashaggon0onon
    enable_hashjoinon0onon
    enable_indexonlyscanon0onon
    enable_indexscanon0onon
    enable_materialon0onon
    enable_mergejoinon0onon
    enable_nestloopon0onon
    enable_seqscanon0onon
    enable_sorton0onon
    enable_tidscanon0onon
    Replication / Master Server
    NameCurrentUnitReset valBoot val
    synchronous_standby_names""0""""
    vacuum_defer_cleanup_age0""
    Replication / Sending Servers
    NameCurrentUnitReset valBoot val
    max_wal_senders0""
    wal_keep_segments0""
    wal_sender_timeout60000ms6000060000
    Replication / Standby Servers
    NameCurrentUnitReset valBoot val
    hot_standbyoff0offoff
    hot_standby_feedbackoff0offoff
    max_standby_archive_delay30000ms3000030000
    max_standby_streaming_delay30000ms3000030000
    wal_receiver_status_interval10s1010
    wal_receiver_timeout60000ms6000060000
    Reporting and Logging / What to Log
    NameCurrentUnitReset valBoot val
    application_namepgcluu0psql""
    debug_pretty_printon0onon
    debug_print_parseoff0offoff
    debug_print_planoff0offoff
    debug_print_rewrittenoff0offoff
    log_autovacuum_min_duration-1ms-1-1
    log_checkpointsoff0offoff
    log_connectionsoff0offoff
    log_disconnectionsoff0offoff
    log_durationoff0offoff
    log_error_verbositydefault0defaultdefault
    log_hostnameoff0offoff
    log_line_prefix""0""""
    log_lock_waitsoff0offoff
    log_statementnone0nonenone
    log_temp_files-1kB-1-1
    log_timezoneEurope/Prague0Europe/PragueGMT
    Reporting and Logging / When to Log
    NameCurrentUnitReset valBoot val
    client_min_messageserror0errornotice
    log_min_duration_statement-1ms-1-1
    log_min_error_statementerror0errorerror
    log_min_messageswarning0warningwarning
    Reporting and Logging / Where to Log
    NameCurrentUnitReset valBoot val
    event_sourcePostgreSQL0PostgreSQLPostgreSQL
    log_destinationstderr0stderrstderr
    log_directorypg_log0pg_logpg_log
    log_file_mode0600""384384
    log_filenamepostgresql-%a.log0postgresql-%a.logpostgresql-%Y-%m-%d_%H%M%S.log
    log_rotation_age1440min14401440
    log_rotation_size0kB10240
    log_truncate_on_rotationon0onoff
    logging_collectoron0onoff
    syslog_facilitylocal00local0local0
    syslog_identpostgres0postgrespostgres
    Resource Usage / Asynchronous Behavior
    NameCurrentUnitReset valBoot val
    effective_io_concurrency1""11
    Resource Usage / Background Writer
    NameCurrentUnitReset valBoot val
    bgwriter_delay200ms200200
    bgwriter_lru_maxpages100""100100
    bgwriter_lru_multiplier2022
    Resource Usage / Cost-Based Vacuum Delay
    NameCurrentUnitReset valBoot val
    vacuum_cost_delay0ms
    vacuum_cost_limit200""200200
    vacuum_cost_page_dirty20""2020
    vacuum_cost_page_hit1""11
    vacuum_cost_page_miss10""1010
    Resource Usage / Disk
    NameCurrentUnitReset valBoot val
    temp_file_limit-1kB-1-1
    Resource Usage / Kernel Resources
    NameCurrentUnitReset valBoot val
    max_files_per_process1000""10001000
    shared_preload_librariespg_stat_statements0pg_stat_statements""
    Resource Usage / Memory
    NameCurrentUnitReset valBoot val
    maintenance_work_mem16384kB1638416384
    max_prepared_transactions0""
    max_stack_depth2048kB2048100
    shared_buffers163848kB163841024
    temp_buffers10248kB10241024
    track_activity_query_size8192""81921024
    work_mem1024kB10241024
    Statistics / Monitoring
    NameCurrentUnitReset valBoot val
    log_executor_statsoff0offoff
    log_parser_statsoff0offoff
    log_planner_statsoff0offoff
    log_statement_statsoff0offoff
    Statistics / Query and Index Statistics Collector
    NameCurrentUnitReset valBoot val
    stats_temp_directorypg_stat_tmp0pg_stat_tmppg_stat_tmp
    track_activitieson0onon
    track_countson0onon
    track_functionsnone0nonenone
    track_io_timingoff0offoff
    update_process_titleon0onon
    Version and Platform Compatibility / Other Platforms and Clients
    NameCurrentUnitReset valBoot val
    transform_null_equalsoff0offoff
    Version and Platform Compatibility / Previous PostgreSQL Versions
    NameCurrentUnitReset valBoot val
    array_nullson0onon
    backslash_quotesafe_encoding0safe_encodingsafe_encoding
    default_with_oidsoff0offoff
    escape_string_warningon0onon
    lo_compat_privilegesoff0offoff
    quote_all_identifiersoff0offoff
    sql_inheritanceon0onon
    standard_conforming_stringson0onon
    synchronize_seqscanson0onon
    Write-Ahead Log / Archiving
    NameCurrentUnitReset valBoot val
    archive_command(disabled)0""""
    archive_modeoff0offoff
    archive_timeout0s
    Write-Ahead Log / Checkpoints
    NameCurrentUnitReset valBoot val
    checkpoint_completion_target0.500.50.5
    checkpoint_segments3""33
    checkpoint_timeout300s300300
    checkpoint_warning30s3030
    Write-Ahead Log / Settings
    NameCurrentUnitReset valBoot val
    commit_delay0""
    commit_siblings5""55
    fsyncon0onon
    full_page_writeson0onon
    synchronous_commiton0onon
    wal_buffers5128kB512-1
    wal_levelminimal0minimalminimal
    wal_sync_methodfdatasync0fdatasyncfdatasync
    wal_writer_delay200ms200200




  • 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.


© Gilles Darold 2012-2015

Report generated by pgCluu 2.4.