PgHero.Database (pghero v0.1.0)

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

Summary

Functions

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

See PgHero.Methods.Maintenance.analyze/3.

analyze_tables(db, opts \\ [])

See PgHero.Methods.Maintenance.analyze_tables/2.

autovacuum_danger(db)

See PgHero.Methods.Maintenance.autovacuum_danger/1.

autovacuum_settings(db)

See PgHero.Methods.Settings.autovacuum_settings/1.

blocked_queries(db)

See PgHero.Methods.Queries.blocked_queries/1.

build(id, config)

cache_hit_rate_threshold(db)

capture_query_stats(db, opts \\ [])

See PgHero.Methods.QueryStats.capture_query_stats/2.

capture_query_stats?(database)

capture_space_stats(db)

See PgHero.Methods.Space.capture_space_stats/1.

clean_query_stats(db, opts \\ [])

See PgHero.Methods.QueryStats.clean_query_stats/2.

clean_space_stats(db, opts \\ [])

See PgHero.Methods.Space.clean_space_stats/2.

connection_sources(db)

See PgHero.Methods.Connections.connection_sources/1.

connection_states(db)

See PgHero.Methods.Connections.connection_states/1.

connections(db)

See PgHero.Methods.Connections.connections/1.

current_user(db)

See PgHero.Methods.Basic.current_user/1.

database_name(db)

See PgHero.Methods.Basic.database_name/1.

database_size(db)

See PgHero.Methods.Space.database_size/1.

disable_query_stats(db)

See PgHero.Methods.QueryStats.disable_query_stats/1.

duplicate_indexes(db, opts \\ [])

See PgHero.Methods.Indexes.duplicate_indexes/2.

enable_query_stats(db)

See PgHero.Methods.QueryStats.enable_query_stats/1.

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

See PgHero.Methods.Explain.explain/3.

explain_timeout_sec(db)

explainable?(db, query)

See PgHero.Methods.QueryStats.explainable?/2.

historical_query_stats_enabled?(db)

See PgHero.Methods.QueryStats.historical_query_stats_enabled?/1.

index_bloat(db, opts \\ [])

See PgHero.Methods.Indexes.index_bloat/2.

index_bloat_bytes(db)

index_caching(db)

See PgHero.Methods.Indexes.index_caching/1.

index_hit_rate(db)

See PgHero.Methods.Indexes.index_hit_rate/1.

index_usage(db)

See PgHero.Methods.Indexes.index_usage/1.

indexes(db)

See PgHero.Methods.Indexes.indexes/1.

invalid_constraints(db)

See PgHero.Methods.Constraints.invalid_constraints/1.

invalid_indexes(db, opts \\ [])

See PgHero.Methods.Indexes.invalid_indexes/2.

kill(db, pid)

See PgHero.Methods.Kill.kill/2.

kill_all(db)

See PgHero.Methods.Kill.kill_all/1.

kill_long_running_queries(db, opts \\ [])

See PgHero.Methods.Kill.kill_long_running_queries/2.

last_stats_reset_time(db)

See PgHero.Methods.Indexes.last_stats_reset_time/1.

long_running_queries(db)

See PgHero.Methods.Queries.long_running_queries/1.

long_running_query_sec(db)

maintenance_info(db)

See PgHero.Methods.Maintenance.maintenance_info/1.

missing_indexes(db)

See PgHero.Methods.Indexes.missing_indexes/1.

queries_table_exists?(db)

See PgHero.Methods.QueryStats.queries_table_exists?/1.

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

See PgHero.Methods.QueryStats.query_hash_stats/3.

query_stats(db, opts \\ [])

See PgHero.Methods.QueryStats.query_stats/2.

query_stats_available?(db)

See PgHero.Methods.QueryStats.query_stats_available?/1.

query_stats_enabled?(db)

See PgHero.Methods.QueryStats.query_stats_enabled?/1.

query_stats_extension_enabled?(db)

See PgHero.Methods.QueryStats.query_stats_extension_enabled?/1.

query_stats_readable?(db)

See PgHero.Methods.QueryStats.query_stats_readable?/1.

query_stats_table_exists?(db)

See PgHero.Methods.QueryStats.query_stats_table_exists?/1.

relation_sizes(db)

See PgHero.Methods.Space.relation_sizes/1.

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

See PgHero.Methods.Space.relation_space_stats/3.

replica?(db)

See PgHero.Methods.Replication.replica?/1.

replicating?(db)

See PgHero.Methods.Replication.replicating?/1.

replication_lag(db)

See PgHero.Methods.Replication.replication_lag/1.

replication_slots(db)

See PgHero.Methods.Replication.replication_slots/1.

reset_query_stats(db, opts \\ [])

See PgHero.Methods.QueryStats.reset_query_stats/2.

reset_stats(db)

See PgHero.Methods.Indexes.reset_stats/1.

running_queries(db, opts \\ [])

See PgHero.Methods.Queries.running_queries/2.

sequence_danger(db, opts \\ [])

See PgHero.Methods.Sequences.sequence_danger/2.

sequences(db)

See PgHero.Methods.Sequences.sequences/1.

server_version(db)

See PgHero.Methods.Basic.server_version/1.

server_version_num(db)

See PgHero.Methods.Basic.server_version_num/1.

settings(db)

See PgHero.Methods.Settings.settings/1.

slow_queries(db, opts \\ [])

See PgHero.Methods.QueryStats.slow_queries/2.

slow_query_calls(db)

slow_query_ms(db)

space_growth(db, opts \\ [])

See PgHero.Methods.Space.space_growth/2.

space_stats_enabled?(db)

See PgHero.Methods.Space.space_stats_enabled?/1.

ssl_used?(db)

See PgHero.Methods.Basic.ssl_used?/1.

suggested_indexes(db, opts \\ [])

suggested_indexes_enabled?(db)

system_stats_enabled?(db)

system_stats_provider(db)

table_caching(db)

See PgHero.Methods.Tables.table_caching/1.

table_hit_rate(db)

See PgHero.Methods.Tables.table_hit_rate/1.

table_sizes(db)

See PgHero.Methods.Space.table_sizes/1.

table_stats(db, opts \\ [])

See PgHero.Methods.Tables.table_stats/2.

total_connections(db)

See PgHero.Methods.Connections.total_connections/1.

total_connections_threshold(db)

transaction_id_danger(db, opts \\ [])

See PgHero.Methods.Maintenance.transaction_id_danger/2.

unused_index_bytes(db)

unused_indexes(db, opts \\ [])

See PgHero.Methods.Indexes.unused_indexes/2.

unused_tables(db)

See PgHero.Methods.Tables.unused_tables/1.

vacuum_progress(db)

See PgHero.Methods.Maintenance.vacuum_progress/1.

vacuum_settings(db)

See PgHero.Methods.Settings.vacuum_settings/1.