PgHero.Database (pghero v0.1.1)

A configured Postgres database and the query helpers used by the dashboard.

Summary

Functions

analyze(db, table, opts \\ [])

analyze_tables(db, opts \\ [])

autovacuum_danger(db)

autovacuum_settings(db)

blocked_queries(db)

build(id, config)

cache_hit_rate_threshold(db)

capture_query_stats(db, opts \\ [])

capture_query_stats?(database)

capture_space_stats(db)

clean_query_stats(db, opts \\ [])

clean_space_stats(db, opts \\ [])

connection_sources(db)

connection_states(db)

connections(db)

current_user(db)

database_name(db)

database_size(db)

disable_query_stats(db)

duplicate_indexes(db, opts \\ [])

enable_query_stats(db)

explain(db, sql, opts \\ [])

explain_timeout_sec(db)

explainable?(db, query)

historical_query_stats_enabled?(db)

index_bloat(db, opts \\ [])

index_bloat_bytes(db)

index_caching(db)

index_hit_rate(db)

index_usage(db)

indexes(db)

invalid_constraints(db)

invalid_indexes(db, opts \\ [])

kill(db, pid)

kill_all(db)

kill_long_running_queries(db, opts \\ [])

last_stats_reset_time(db)

long_running_queries(db)

long_running_query_sec(db)

maintenance_info(db)

missing_indexes(db)

queries_table_exists?(db)

query_hash_stats(db, query_hash, opts \\ [])

query_stats(db, opts \\ [])

query_stats_available?(db)

query_stats_enabled?(db)

query_stats_extension_enabled?(db)

query_stats_readable?(db)

query_stats_table_exists?(db)

relation_sizes(db)

relation_space_stats(db, relation, opts \\ [])

replica?(db)

replicating?(db)

replication_lag(db)

replication_slots(db)

reset_query_stats(db, opts \\ [])

reset_stats(db)

running_queries(db, opts \\ [])

sequence_danger(db, opts \\ [])

sequences(db)

server_version(db)

server_version_num(db)

settings(db)

slow_queries(db, opts \\ [])

slow_query_calls(db)

slow_query_ms(db)

space_growth(db, opts \\ [])

space_stats_enabled?(db)

ssl_used?(db)

suggested_indexes(db, opts \\ [])

suggested_indexes_by_query(db, opts \\ [])

suggested_indexes_enabled?(db)

system_stats_enabled?(db)

system_stats_provider(db)

table_caching(db)

table_hit_rate(db)

table_sizes(db)

table_stats(db, opts \\ [])

total_connections(db)

total_connections_threshold(db)

transaction_id_danger(db, opts \\ [])

unused_index_bytes(db)

unused_indexes(db, opts \\ [])

unused_tables(db)

vacuum_progress(db)

vacuum_settings(db)

Functions

analyze(db, table, opts \\ [])

analyze_tables(db, opts \\ [])

autovacuum_danger(db)

autovacuum_settings(db)

blocked_queries(db)

build(id, config)

cache_hit_rate_threshold(db)

capture_query_stats(db, opts \\ [])

capture_query_stats?(database)

capture_space_stats(db)

clean_query_stats(db, opts \\ [])

clean_space_stats(db, opts \\ [])

connection_sources(db)

connection_states(db)

connections(db)

current_user(db)

database_name(db)

database_size(db)

disable_query_stats(db)

duplicate_indexes(db, opts \\ [])

enable_query_stats(db)

explain(db, sql, opts \\ [])

explain_timeout_sec(db)

explainable?(db, query)

historical_query_stats_enabled?(db)

index_bloat(db, opts \\ [])

index_bloat_bytes(db)

index_caching(db)

index_hit_rate(db)

index_usage(db)

indexes(db)

invalid_constraints(db)

invalid_indexes(db, opts \\ [])

kill(db, pid)

kill_all(db)

kill_long_running_queries(db, opts \\ [])

last_stats_reset_time(db)

long_running_queries(db)

long_running_query_sec(db)

maintenance_info(db)

missing_indexes(db)

queries_table_exists?(db)

query_hash_stats(db, query_hash, opts \\ [])

query_stats(db, opts \\ [])

query_stats_available?(db)

query_stats_enabled?(db)

query_stats_extension_enabled?(db)

query_stats_readable?(db)

query_stats_table_exists?(db)

relation_sizes(db)

relation_space_stats(db, relation, opts \\ [])

replica?(db)

replicating?(db)

replication_lag(db)

replication_slots(db)

reset_query_stats(db, opts \\ [])

reset_stats(db)

running_queries(db, opts \\ [])

sequence_danger(db, opts \\ [])

sequences(db)

server_version(db)

server_version_num(db)

settings(db)

slow_queries(db, opts \\ [])

slow_query_calls(db)

slow_query_ms(db)

space_growth(db, opts \\ [])

space_stats_enabled?(db)

ssl_used?(db)

suggested_indexes(db, opts \\ [])

suggested_indexes_by_query(db, opts \\ [])

suggested_indexes_enabled?(db)

system_stats_enabled?(db)

system_stats_provider(db)

table_caching(db)

table_hit_rate(db)

table_sizes(db)

table_stats(db, opts \\ [])

total_connections(db)

total_connections_threshold(db)

transaction_id_danger(db, opts \\ [])

unused_index_bytes(db)

unused_indexes(db, opts \\ [])

unused_tables(db)

vacuum_progress(db)

vacuum_settings(db)