| .. |
|
global_reports
|
sql/global_reports/query_stat_total variant for postgresql 18
|
2 months ago |
|
old
|
Rename sql/create_db_activity_view_old.sql to sql/old/create_db_activity_view_old.sql
|
5 years ago |
|
slony
|
Create temp.txt
|
5 years ago |
|
83compat.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
amcheck_indexes.sql
|
added usage to comment
|
5 years ago |
|
cache_stat.sql
|
cache_stat.sql multiple c.oid fix
|
12 years ago |
|
check_all_tables_have_pk.sql
|
file name fix
|
4 years ago |
|
check_are_all_subscribed.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
check_config.sql
|
Added new sql script for checking PostgreSQL configuration over pg_settings view.
|
8 years ago |
|
check_missing_grants.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
check_strange_fk.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
check_uniq_indexes.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
create_db_activity_view.sql
|
Rename create_db_activity_view9.6.sql to create_db_activity_view.sql
|
5 years ago |
|
create_db_activity_view9.2.sql
|
show aborted transactions in db_activity view
|
11 years ago |
|
create_query_stat_cpu_time_view.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
create_query_stat_io_time_view.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
create_query_stat_log.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
create_query_stat_time_view.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
create_repl_activity_view9.5.sql
|
repl_activity: fix typo
|
9 years ago |
|
create_slonik_set_full.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
create_slonik_set_incremental.sql
|
fix create_slonik_set_incremental.sql
|
9 years ago |
|
create_xlog_math_procedures.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
db_activity.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
db_activity9.2.sql
|
show aborted transactions in db_activity view
|
11 years ago |
|
db_activity9.6.sql
|
fix db_activity view/query for 9.6
|
9 years ago |
|
dirty_to_read_stat.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
generate_drop_items.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
index_bloat.sql
|
table_bloat/index_bloat improvements: add prompt in psql for mask, combine schema and table name in one column, add limit for index_bloat query.
|
4 years ago |
|
index_candidates_from_ssd.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
index_candidates_to_deduplicate.sql
|
index_candidates_to_deduplicate: don't skip indexes without MCV statistics
|
3 years ago |
|
index_candidates_to_partial.sql
|
table_bloat_approx.sql: add table mask prompt, combine table and schema names. index_candidates_to_partial.sql: fix typo
|
3 years ago |
|
index_candidates_to_ssd.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
index_disk_activity.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
indexes_with_nulls.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
indexing_progress.sql
|
indexing_progress.sql: add additional columns, improve readability; index_candidates_to_deduplicate: fix columns order for multicolumn indexes estimates
|
3 years ago |
|
locktree.sql
|
Correct duplicate leader detection
|
7 years ago |
|
low_used_indexes.sql
|
Modified script for proper checking low used indecies on replica servers.
|
7 years ago |
|
low_used_indexes_with_replica.sql
|
added low used indexes analyze version with replica indexes included
|
8 years ago |
|
master_wal_position.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
query_stat_counts.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
query_stat_cpu_time.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
query_stat_io_time.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
query_stat_rows.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
query_stat_time.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
query_stat_total_single_db.sql
|
added single-db version of global report
|
11 years ago |
|
redundant_indexes.sql
|
location fix for indexprs and indpred
|
9 years ago |
|
reindex_non_btree_indexes.sql
|
add reindex_non_btree_indexes.sql
|
4 years ago |
|
replication_pretty.sql
|
Replication and progress scripts.
|
4 years ago |
|
seq_scan_tables.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
seq_scan_tables_with_replica.sql
|
added seq scan tables analyze with replica info included
|
8 years ago |
|
set_default_grants.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
set_missing_grants.sql
|
grant access to all schemas to role_ro/role_rw as well
|
9 years ago |
|
slave_wal_position.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
slony_tables.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
sync_tablespaces.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
table_bloat.sql
|
table_bloat/index_bloat improvements: add prompt in psql for mask, combine schema and table name in one column, add limit for index_bloat query.
|
4 years ago |
|
table_bloat_approx.sql
|
change script table_bloat_approx.sql
|
5 months ago |
|
table_bloat_approx12.sql
|
change script table_bloat_approx.sql
|
5 months ago |
|
table_candidates_from_ssd.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
table_candidates_to_ssd.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
table_index_write_activity.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
table_write_activity.sql
|
*.sql moved into dedicated sql/ directory
|
12 years ago |
|
top_databases.sql
|
add few more queries
|
10 years ago |
|
top_tables.sql
|
show materialized views at top_tables.sql output
|
7 years ago |
|
vacuum_progress.sql
|
Replication and progress scripts.
|
4 years ago |
|
vacuum_truncate_speedup.sql
|
add vacuum_truncate_speedup script
|
4 years ago |
|
versions_check.sql
|
Updated lastest actual versions of PostgreSQL
|
7 years ago |
melkij