Skip to content

sahapasci/dba.postgresql

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

20 Commits
LICENSE
LICENSE
 
 
README.txt
README.txt
 
 
dba.sp_alter_index_tablespaces.sql
dba.sp_alter_index_tablespaces.sql
 
 
dba.sp_blocked_query.sql
dba.sp_blocked_query.sql
 
 
dba.sp_copy_table_priviledges.sql
dba.sp_copy_table_priviledges.sql
 
 
dba.sp_copy_user_priviledges.sql
dba.sp_copy_user_priviledges.sql
 
 
dba.sp_get_connection_usage.sql
dba.sp_get_connection_usage.sql
 
 
dba.sp_get_idle_in_transaction_count.sql
dba.sp_get_idle_in_transaction_count.sql
 
 
dba.sp_get_replica_delay_sec.sql
dba.sp_get_replica_delay_sec.sql
 
 
dba.sp_get_running_query_count.sql
dba.sp_get_running_query_count.sql
 
 
dba.sp_get_top_10_index_sizes.sql
dba.sp_get_top_10_index_sizes.sql
 
 
dba.sp_get_top_10_table_sizes.sql
dba.sp_get_top_10_table_sizes.sql
 
 
dba.sp_get_waiting_transaction_count.sql
dba.sp_get_waiting_transaction_count.sql
 
 
dba.sp_grant_all_sequences.sql
dba.sp_grant_all_sequences.sql
 
 
dba.sp_grant_readonly_access.sql
dba.sp_grant_readonly_access.sql
 
 
dba.sp_grant_to_all_tables.sql
dba.sp_grant_to_all_tables.sql
 
 
dba.sp_locked_tables.sql
dba.sp_locked_tables.sql
 
 
dba.sp_refresh_all_sequences.sql
dba.sp_refresh_all_sequences.sql
 
 
dba.sp_refresh_sequence.sql
dba.sp_refresh_sequence.sql
 
 
dba.sp_revoke_all_sequences.sql
dba.sp_revoke_all_sequences.sql
 
 
dba.sp_revoke_all_tables.sql
dba.sp_revoke_all_tables.sql
 
 
dba.v_disc_spaces.sql
dba.v_disc_spaces.sql
 
 
dba.v_dublicate_indexes.sql
dba.v_dublicate_indexes.sql
 
 

Repository files navigation

# dba.postgresql
Useful views and functions for postgreSQL DBA's.  

First create "dba" schema in your postgreSQL database instance. Then create any functions you find useful by using scripts in the repository.

About

Useful views and functions for postgreSQL DBA's.

Resources

Readme

License

Apache-2.0 license
Activity

Stars

13 stars

Watchers

4 watching

Forks

1 fork
Report repository

Releases

No releases published

Packages

No packages published

Languages