pgCluu
  • Home
  • SysInfo
  • Cluster
    • Databases sizes
    • Tablespaces sizes
    • Connections
      • Connections
      • Connections by type
    • Deadlocks
    • Cache utilization
    • Shared buffers statistics
      • Shared buffers utilisation
      • 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
      • 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
      • PostgreSQL authorization
      • User Name Maps
      • Pgbouncer settings
  • Databases
    • dolibarr
      • Database info
      • Tables statistics
        • Index scan ratio
        • Vacuums/analyzes
        • Insert/update/delete
        • Live vs dead tuples
        • Size and tuples
        • Tables I/O stats
      • Indexes statistics
        • Index read/fetch
        • Size and tuples
        • Indexes I/O stats
        • Unused Indexes
        • Redundant indexes
        • Missing indexes
      • Buffercache Statistics
        • Buffercache per relation
        • Buffer I/O per relation
      • 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
    • mantis
      • Database info
      • Tables statistics
        • Index scan ratio
        • Vacuums/analyzes
        • Insert/update/delete
        • Live vs dead tuples
        • Size and tuples
        • Tables I/O stats
      • Indexes statistics
        • Index read/fetch
        • Size and tuples
        • Indexes I/O stats
        • Unused Indexes
        • Missing indexes
      • Buffercache Statistics
        • Buffercache per relation
        • Buffer I/O per relation
      • 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
    • opm
      • Database info
      • Indexes statistics
      • Buffercache Statistics
        • Buffercache per relation
        • Buffer I/O per relation
      • 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
  • pgBouncer
    • dolibarr
      • Clients / servers connections
      • Average queries duration
      • Queries per second
  • System
    • Cpu
    • Memory
    • Swap
    • Load
    • Process
    • Run queue
    • Blocks
    • Pages
    • Devices
      • sda
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • sdb
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • pdc_bhcccjdji
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • pdc_bhcccjdji1
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • pdc_bhcccjdji2
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • pdc_bhcccjdji3
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • pdc_bhcccjdji4
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • pdc_bhcccjdji5
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • pdc_bhcccjdji6
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • pdc_bhcccjdji7
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • pdc_bhcccjdji8
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • cryptswap1
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
    • Network
      • lo
        • Network utilization
        • Network errors
      • eth0
        • Network utilization
        • Network errors
  • About




  • 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
    autovacuumon
    autovacuum_analyze_scale_factor0.1
    autovacuum_analyze_threshold50
    autovacuum_freeze_max_age200000000
    autovacuum_max_workers3
    autovacuum_multixact_freeze_max_age400000000
    autovacuum_naptime60
    autovacuum_vacuum_cost_delay20
    autovacuum_vacuum_cost_limit-1
    autovacuum_vacuum_scale_factor0.2
    autovacuum_vacuum_threshold50
    Client Connection Defaults / Locale and Formatting
    client_encodingUTF8
    DateStyleISO. MDY
    default_text_search_configpg_catalog.french
    extra_float_digits0
    IntervalStylepostgres
    lc_collatefr_FR.utf8
    lc_ctypefr_FR.utf8
    lc_messagesen_US.UTF-8
    lc_monetaryfr_FR.UTF-8
    lc_numericfr_FR.UTF-8
    lc_timefr_FR.UTF-8
    server_encodingUTF8
    TimeZonelocaltime
    timezone_abbreviationsDefault
    Client Connection Defaults / Other Defaults
    dynamic_library_path$libdir
    gin_fuzzy_search_limit0
    local_preload_libraries""
    tcp_keepalives_count0
    tcp_keepalives_idle0
    tcp_keepalives_interval0
    Client Connection Defaults / Statement Behavior
    bytea_outputhex
    check_function_bodieson
    default_tablespace""
    default_transaction_deferrableoff
    default_transaction_isolationread committed
    default_transaction_read_onlyoff
    lock_timeout0
    search_path"""$user"".public"
    session_replication_roleorigin
    statement_timeout0
    temp_tablespaces""
    transaction_deferrableoff
    transaction_isolationread committed
    transaction_read_onlyoff
    vacuum_freeze_min_age50000000
    vacuum_freeze_table_age150000000
    vacuum_multixact_freeze_min_age5000000
    vacuum_multixact_freeze_table_age150000000
    xmlbinarybase64
    xmloptioncontent
    Connections and Authentication / Connection Settings
    bonjouroff
    bonjour_name""
    listen_addresseslocalhost
    max_connections100
    port5432
    superuser_reserved_connections3
    unix_socket_directories/var/run/postgresql
    unix_socket_group""
    unix_socket_permissions0777
    Connections and Authentication / Security and Authentication
    authentication_timeout60
    db_user_namespaceoff
    krb_caseins_usersoff
    krb_server_keyfileFILE:/etc/postgresql-common/krb5.keytab
    krb_srvnamepostgres
    password_encryptionon
    sslon
    ssl_ca_file""
    ssl_cert_file/etc/ssl/certs/ssl-cert-snakeoil.pem
    ssl_ciphersDEFAULT:!LOW:!EXP:!MD5:@STRENGTH
    ssl_crl_file""
    ssl_key_file/etc/ssl/private/ssl-cert-snakeoil.key
    ssl_renegotiation_limit524288
    Developer Options
    allow_system_table_modsoff
    debug_assertionsoff
    ignore_checksum_failureoff
    ignore_system_indexesoff
    post_auth_delay0
    pre_auth_delay0
    trace_notifyoff
    trace_recovery_messageslog
    trace_sortoff
    zero_damaged_pagesoff
    Error Handling
    exit_on_erroroff
    restart_after_crashon
    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_timeout1000
    max_locks_per_transaction6400
    max_pred_locks_per_transaction64
    Preset Options
    block_size8192
    integer_datetimeson
    max_function_args100
    max_identifier_length63
    max_index_keys32
    segment_size131072
    server_version9.3.3
    server_version_num90303
    wal_block_size8192
    wal_segment_size2048
    Query Tuning / Genetic Query Optimizer
    geqoon
    geqo_effort5
    geqo_generations0
    geqo_pool_size0
    geqo_seed0
    geqo_selection_bias2
    geqo_threshold12
    Query Tuning / Other Planner Options
    constraint_exclusionpartition
    cursor_tuple_fraction0.1
    default_statistics_target100
    from_collapse_limit8
    join_collapse_limit8
    Query Tuning / Planner Cost Constants
    cpu_index_tuple_cost0.005
    cpu_operator_cost0.0025
    cpu_tuple_cost0.01
    effective_cache_size262144
    random_page_cost3
    seq_page_cost1
    Query Tuning / Planner Method Configuration
    enable_bitmapscanon
    enable_hashaggon
    enable_hashjoinon
    enable_indexonlyscanon
    enable_indexscanon
    enable_materialon
    enable_mergejoinon
    enable_nestloopon
    enable_seqscanon
    enable_sorton
    enable_tidscanon
    Replication / Master Server
    synchronous_standby_names""
    vacuum_defer_cleanup_age0
    Replication / Sending Servers
    max_wal_senders5
    wal_keep_segments0
    wal_sender_timeout60000
    Replication / Standby Servers
    hot_standbyon
    hot_standby_feedbackoff
    max_standby_archive_delay30000
    max_standby_streaming_delay30000
    wal_receiver_status_interval10
    wal_receiver_timeout60000
    Reporting and Logging / What to Log
    application_namepsql
    debug_pretty_printon
    debug_print_parseoff
    debug_print_planoff
    debug_print_rewrittenoff
    log_autovacuum_min_duration-1
    log_checkpointsoff
    log_connectionsoff
    log_disconnectionsoff
    log_durationoff
    log_error_verbositydefault
    log_hostnameoff
    log_line_prefix%t [%p]: [%l-1] user=%u.db=%d.host=%h
    log_lock_waitsoff
    log_statementnone
    log_temp_files-1
    log_timezonelocaltime
    Reporting and Logging / When to Log
    client_min_messagesnotice
    log_min_duration_statement1000
    log_min_error_statementerror
    log_min_messageswarning
    Reporting and Logging / Where to Log
    event_sourcePostgreSQL
    log_destinationstderr
    log_directorypg_log
    log_file_mode0600
    log_filenamepostgresql-%Y-%m-%d_%H%M%S.log
    log_rotation_age1440
    log_rotation_size10240
    log_truncate_on_rotationoff
    logging_collectoroff
    syslog_facilitylocal0
    syslog_identpostgres
    Resource Usage / Asynchronous Behavior
    effective_io_concurrency4
    Resource Usage / Background Writer
    bgwriter_delay200
    bgwriter_lru_maxpages100
    bgwriter_lru_multiplier2
    Resource Usage / Cost-Based Vacuum Delay
    vacuum_cost_delay0
    vacuum_cost_limit200
    vacuum_cost_page_dirty20
    vacuum_cost_page_hit1
    vacuum_cost_page_miss10
    Resource Usage / Disk
    temp_file_limit-1
    Resource Usage / Kernel Resources
    max_files_per_process1000
    shared_preload_libraries""
    Resource Usage / Memory
    maintenance_work_mem524288
    max_prepared_transactions0
    max_stack_depth2048
    shared_buffers65536
    temp_buffers1024
    track_activity_query_size1024
    work_mem4096
    Statistics / Monitoring
    log_executor_statsoff
    log_parser_statsoff
    log_planner_statsoff
    log_statement_statsoff
    Statistics / Query and Index Statistics Collector
    stats_temp_directorypg_stat_tmp
    track_activitieson
    track_countson
    track_functionsnone
    track_io_timingon
    update_process_titleon
    Version and Platform Compatibility / Other Platforms and Clients
    transform_null_equalsoff
    Version and Platform Compatibility / Previous PostgreSQL Versions
    array_nullson
    backslash_quotesafe_encoding
    default_with_oidsoff
    escape_string_warningon
    lo_compat_privilegesoff
    quote_all_identifiersoff
    sql_inheritanceon
    standard_conforming_stringson
    synchronize_seqscanson
    Write-Ahead Log / Archiving
    archive_commandpbzip2 < %p > /tmp/%f && rsync -a /tmp/%f 12.34.56.78:/var/lib/postgresql/9.3/wals/main/%f && rm /tmp/%f
    archive_modeon
    archive_timeout0
    Write-Ahead Log / Checkpoints
    checkpoint_completion_target0.9
    checkpoint_segments16
    checkpoint_timeout300
    checkpoint_warning30
    Write-Ahead Log / Settings
    commit_delay0
    commit_siblings5
    fsyncon
    full_page_writeson
    synchronous_commiton
    wal_buffers2048
    wal_levelhot_standby
    wal_sync_methodfdatasync
    wal_writer_delay200




  • 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 = 20




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

© Gilles Darold 2012-2014

Report generated by pgCluu 2.0.