-
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 read Temp 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 45 0.014s 0.661s 630 0 0 COPY (SELECT date_trunc('seconds'. now()). category. name. setting. unit. context. source FROM pg_settings ORDER BY category.name) TO STDOUT CSV DELIMITER ';'; 45 0.012s 0.581s 10260 0 0 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 ';'; 45 0.011s 0.504s 2925 0 0 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 ';'; 45 0.007s 0.350s 315 0 0 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 ';'; 45 0.006s 0.293s 0 0 0 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 ';'; 45 0.006s 0.286s 315 0 0 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 ';'; 45 0.004s 0.207s 0 0 0 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 ';'; 45 0.004s 0.205s 360 0 0 COPY (SELECT date_trunc('seconds'. now()). * FROM pg_stat_xact_user_tables WHERE schemaname <> 'information_schema' ORDER BY 3. 4) TO STDOUT CSV DELIMITER ';'; 45 0.003s 0.155s 315 0 0 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 ';'; 45 0.002s 0.129s 360 0 0 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 ';'; 45 0.002s 0.113s 270 0 0 COPY (SELECT date_trunc('seconds'. now()). * FROM pg_stat_xact_user_functions WHERE schemaname <> 'information_schema' ORDER BY 3. 4) TO STDOUT CSV DELIMITER ';'; 45 0.002s 0.102s 0 0 0 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 ';'; 45 0.002s 0.091s 53 0 0 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 ';'; 45 0.001s 0.067s 0 0 0 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 ';'; 45 0.001s 0.062s 106 0 0 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 ';'; 45 0s 0.034s 106 0 0 SELECT n.nspname||?||p.proname FROM pg_proc p. pg_namespace n WHERE p.pronamespace=n.oid AND n.nspname NOT IN (?. ?); 10 0.003s 0.030s 40 0 0 SELECT extname FROM pg_extension; 10 0.001s 0.015s 10 0 0 SELECT count(tgname) FROM pg_trigger WHERE NOT tgisinternal; 10 0s 0.008s 10 0 0 SELECT nspname FROM pg_namespace WHERE nspname !~ ? AND nspname <> ? ORDER BY 1 10 0s 0.001s 10 0 0 -
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