Crate pg_extras

Source

Re-exports§

pub use queries::all_locks::AllLocks;
pub use queries::bloat::Bloat;
pub use queries::blocking::Blocking;
pub use queries::buffercache_stats::BuffercacheStats;
pub use queries::buffercache_usage::BuffercacheUsage;
pub use queries::cache_hit::CacheHit;
pub use queries::calls::Calls;
pub use queries::connections::Connections;
pub use queries::db_settings::DbSettings;
pub use queries::duplicate_indexes::DuplicateIndexes;
pub use queries::extensions::Extensions;
pub use queries::index_cache_hit::IndexCacheHit;
pub use queries::index_scans::IndexScans;
pub use queries::index_size::IndexSize;
pub use queries::index_usage::IndexUsage;
pub use queries::indexes::Indexes;
pub use queries::locks::Locks;
pub use queries::long_running_queries::LongRunningQueries;
pub use queries::mandelbrot::Mandelbrot;
pub use queries::null_indexes::NullIndexes;
pub use queries::outliers::Outliers;
pub use queries::records_rank::RecordsRank;
pub use queries::seq_scans::SeqScans;
pub use queries::shared::get_default_schema;
pub use queries::shared::Query;
pub use queries::ssl_used::SslUsed;
pub use queries::table_cache_hit::TableCacheHit;
pub use queries::table_index_scans::TableIndexScans;
pub use queries::table_indexes_size::TableIndexesSize;
pub use queries::table_size::TableSize;
pub use queries::tables::Tables;
pub use queries::total_index_size::TotalIndexSize;
pub use queries::total_table_size::TotalTableSize;
pub use queries::unused_indexes::UnusedIndexes;
pub use queries::vacuum_stats::VacuumStats;

Modules§

diagnose
queries

Structs§

NEW_PG_STAT_STATEMENTS
PG_STAT_STATEMENTS_17

Enums§

PgExtrasError
PgStatsVersion

Functions§

all_locks
Shows detailed information about all locks in the database.
bloat
Returns table and index bloat in your database ordered by most wasteful.
blocking
Lists queries that are blocking other queries.
buffercache_stats
Shows statistics about shared buffer cache usage.
buffercache_usage
Shows distribution of buffer cache usage by database objects.
cache_hit
Shows cache hit rates for both tables and indexes.
calls
Returns statistics about query calls in the database.
connections
Shows information about current database connections and their states.
db_settings
Shows current values of important PostgreSQL settings.
diagnose
Runs a comprehensive set of diagnostic checks on the database.
duplicate_indexes
Shows indexes that have identical definitions but different names.
extensions
Lists all installed PostgreSQL extensions.
index_cache_hit
Shows index cache hit rates.
index_scans
Shows statistics about index scans.
index_size
Shows the size of all indexes, ordered by size.
index_usage
Shows statistics about index usage.
indexes
Lists all indexes in the database.
locks
Shows information about locks in the database.
long_running_queries
Lists currently running queries that have been running for a long time.
mandelbrot
Generates a Mandelbrot set as a test query.
null_indexes
Shows indexes that contain mostly NULL values.
outliers
Shows queries with the longest execution time in aggregate.
pg_pool
Creates a new connection pool to PostgreSQL.
records_rank
Shows estimated number of rows in each table, ordered by estimated count.
render_table
Renders a table to stdout for any type that implements the Query trait.
seq_scans
Shows statistics about sequential scans performed on tables.
ssl_used
Shows whether SSL is being used for current connections.
table_cache_hit
Shows cache hit rates for tables.
table_index_scans
Shows statistics about index scans performed on tables.
table_indexes_size
Shows total size of all indexes for each table.
table_size
Shows disk space used by each table, excluding indexes.
tables
Lists all tables in the database with their basic information.
total_index_size
Shows total size of all indexes in the database.
total_table_size
Shows total disk space used by tables and indexes.
unused_indexes
Lists indexes that haven’t been used or are rarely used.
vacuum_stats
Shows statistics about VACUUM and ANALYZE operations.