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




  • Size of dolibarr database

    Sizes of databases





  • Affected tuples per operation on dolibarr database

    Affected rows on databases grouped by statement family





  • Cache hit/miss ratio on dolibarr database

    Per database cache hit/miss ratio





  • Commits/Rollbacks per second on dolibarr database

    Number of commits / rollbacks per second and number of backends by database





  • Write ratio on dolibarr database

    Write ratio on databases excluding templates and postgres





  • Read tuples on dolibarr 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 dolibarr database

    Number of clients connected to a database





  • Number of deadlocks on dolibarr database

    Number of deadlocks detected in this database





  • Number of canceled queries on dolibarr database

    Number of queries canceled due to conflicts with recovery in this database. [Conflicts occur only on standby servers]





  • Number of temporary files on dolibarr database

    Number of temporary files created by queries per database.





  • Size of temporary data on dolibarr database

    Amount of data written to temporary files created by queries per database.





  • Conflicts per type on dolibarr database

    Per database statistics about query cancels occurring due to conflicts with recovery on standby servers.

    NO DATASET




  • Types of locks on dolibarr database

    Number of locks types in a database. Type of the lockable object: relation, extend, page, tuple, transactionid, virtualxid, object, userlock, or advisory





  • Modes of locks on dolibarr database

    Number of locks per lock mode held or desired by this process





  • Granted locks on dolibarr database

    Number of locks held (granted) or awaited (waiting)





  • Statements statistics on dolibarr database

    Top N statistics about slowest or most used queries

    Query Calls Avg. time Total time Rows Temp readTemp write
    COPY (SELECT date_trunc('seconds'. now()). current_database(). relname. 'CREATE INDEX idx_' || relname || '_' || array_to_string(column_name_list. '_') || ' ON ' || conrelid || ' (' || array_to_string(column_name_list. '.') || ')' AS ddl FROM (SELECT DISTINCT conrelid. array_agg(attname) AS column_name_list. array_agg(attnum) AS column_list FROM pg_attribute JOIN (SELECT conrelid::regclass. conname. unnest(conkey) AS column_index FROM (SELECT DISTINCT conrelid. conname. conkey FROM pg_constraint JOIN pg_class ON pg_class.oid = pg_constraint.conrelid JOIN pg_namespace ON pg_namespace.oid = pg_class.relnamespace WHERE nspname !~ '^pg_' AND nspname <> 'information_schema' ) fkey ) fkey ON fkey.conrelid = pg_attribute.attrelid AND fkey.column_index = pg_attribute.attnum 450.014s0.661s63000
    COPY (SELECT date_trunc('seconds'. now()). category. name. setting. unit. context. source FROM pg_settings ORDER BY category.name) TO STDOUT CSV DELIMITER ';';450.012s0.581s1026000
    COPY (SELECT date_trunc('seconds'. now()). current_database(). n.nspname. c.relname. c.relkind. c.reltuples. c.relpages. pg_relation_size(c.oid) FROM pg_class c. pg_namespace n WHERE n.oid=c.relnamespace AND n.nspname <> 'information_schema' AND n.nspname <> 'pg_catalog' ORDER BY n.nspname. c.relname) TO STDOUT CSV DELIMITER ';';450.011s0.504s292500
    COPY (SELECT date_trunc('seconds'. now()). current_database(). * FROM pg_statio_user_tables WHERE schemaname <> 'information_schema' ORDER BY schemaname. relname) TO STDOUT CSV DELIMITER ';';450.007s0.350s31500
    COPY (SELECT date_trunc('seconds'. now()). current_database(). schemaname. relname. indexrelname. pg_get_indexdef(pg_stat_user_indexes.indexrelid) FROM pg_stat_user_indexes INNER JOIN pg_index ON pg_index.indexrelid = pg_stat_user_indexes.indexrelid WHERE NOT indexrelname ILIKE 'fki%' AND NOT indexrelname ILIKE 'pk%' AND indisunique = FALSE AND idx_scan = 0 ORDER BY schemaname. relname. indexrelname) TO STDOUT CSV DELIMITER ';';450.006s0.293s000
    COPY (SELECT date_trunc('seconds'. now()). current_database(). relid. schemaname. relname. seq_scan. seq_tup_read. idx_scan. idx_tup_fetch. n_tup_ins. n_tup_upd. n_tup_del. n_tup_hot_upd. n_live_tup. n_dead_tup. date_trunc('seconds'. last_vacuum) AS last_vacuum. date_trunc('seconds'. last_autovacuum) AS last_autovacuum. date_trunc('seconds'.last_analyze) AS last_analyze. date_trunc('seconds'.last_autoanalyze) AS last_autoanalyze. vacuum_count. autovacuum_count. analyze_count. autoanalyze_count FROM pg_stat_user_tables WHERE schemaname <> 'information_schema' ORDER BY schemaname. relname) TO STDOUT CSV DELIMITER ';';450.006s0.286s31500
    COPY (SELECT date_trunc('seconds'. now()). current_database(). * FROM pg_stat_user_functions WHERE schemaname <> 'information_schema' ORDER BY schemaname. funcname) TO STDOUT CSV DELIMITER ';';450.004s0.207s000
    COPY (SELECT date_trunc('seconds'. now()). current_database(). * FROM pg_statio_user_indexes WHERE schemaname <> 'information_schema' ORDER BY schemaname. relname) TO STDOUT CSV DELIMITER ';';450.004s0.205s36000
    COPY (SELECT date_trunc('seconds'. now()). * FROM pg_stat_xact_user_tables WHERE schemaname <> 'information_schema' ORDER BY 3. 4) TO STDOUT CSV DELIMITER ';';450.003s0.155s31500
    COPY (SELECT date_trunc('seconds'. now()). current_database(). * FROM pg_stat_user_indexes WHERE schemaname <> 'information_schema' ORDER BY schemaname. relname) TO STDOUT CSV DELIMITER ';';450.002s0.129s36000
    COPY (SELECT date_trunc('seconds'. now()). current_database(). * FROM pg_statio_user_sequences WHERE schemaname <> 'information_schema' ORDER BY schemaname. relname) TO STDOUT CSV DELIMITER ';';450.002s0.113s27000
    COPY (SELECT date_trunc('seconds'. now()). * FROM pg_stat_xact_user_functions WHERE schemaname <> 'information_schema' ORDER BY 3. 4) TO STDOUT CSV DELIMITER ';';450.002s0.102s000
    COPY (SELECT date_trunc('seconds'. now()). current_database(). 'lock_granted'::text as label. granted. count(granted) as count FROM pg_locks GROUP BY granted) TO STDOUT CSV DELIMITER ';';450.002s0.091s5300
    COPY (SELECT date_trunc('seconds'. now()). current_database(). pg_get_indexdef(indexrelid) AS contained. pg_get_indexdef(index_backward) AS container FROM ( SELECT indexrelid. indrelid. array_to_string(indkey.'+') AS colindex. lag(array_to_string(indkey.'+')) OVER search_window AS colindexbackward. lag(indexrelid) OVER search_window AS index_backward FROM pg_index WINDOW search_window AS (PARTITION BY indrelid ORDER BY array_to_string(indkey.'+') DESC) ) AS tmp WHERE colindexbackward LIKE (colindex || '+%')) TO STDOUT CSV DELIMITER ';';450.001s0.067s000
    COPY (SELECT date_trunc('seconds'. now()). current_database(). 'lock_mode'::text as label. mode. count(mode) as count FROM pg_locks GROUP BY mode) TO STDOUT CSV DELIMITER ';';450.001s0.062s10600
    COPY (SELECT date_trunc('seconds'. now()). current_database(). 'lock_type'::text as label. locktype. count(locktype) as count FROM pg_locks GROUP BY locktype) TO STDOUT CSV DELIMITER ';';450s0.034s10600
    SELECT n.nspname||?||p.proname FROM pg_proc p. pg_namespace n WHERE p.pronamespace=n.oid AND n.nspname NOT IN (?. ?);100.003s0.030s4000
    SELECT extname FROM pg_extension;100.001s0.015s1000
    SELECT count(tgname) FROM pg_trigger WHERE NOT tgisinternal;100s0.008s1000
    SELECT nspname FROM pg_namespace WHERE nspname !~ ? AND nspname <> ? ORDER BY 1100s0.001s1000



  • Database dolibarr

    • 29.78 MB Total size
    • 1 Installed extensions (plpgsql)
    • 1 Schemas (public)
    • - Last manual vacuum
    • - Last manual analyze
    • 17 Stored procedures
    • 57 Triggers
    • 181 sequences
    • 0 composite types
    • 601 indexes
    • 209 tables
    • 124 toast tables
    • 0 views

© Gilles Darold 2012-2014

Report generated by pgCluu 2.0.