GitHub
/
pg-utils
mirror of https://github.com/dataegret/pg-utils.git
1
0
Fork 0
Code Issues Projects Releases Wiki Activity

Commit Graph

  • 13a9b81aca
         Merge c4ceb837a2 into 66e294a01f #12 Rinat 2026-02-09 11:14:33 +0530
  • ff4cbc1b84
         Merge ae280f62dc into 66e294a01f #2 Roman 2026-01-09 14:54:57 +0400
  • 6f1cc670f5
         Merge 6eb0ba4753 into 66e294a01f #7 Rinat 2025-12-25 12:11:13 +0000
  • bb5101d807
         Merge ed7886f380 into 66e294a01f #14 Marat B. 2025-12-19 21:52:20 +0600
  • 1b271a83dc
         Merge 181fff2a15 into 66e294a01f #10 Sardorkhuja Tukhtakhodjaev 2025-12-18 19:23:36 +0000
  • 66e294a01f Add pg_log_search - fast PostgreSQL log query search tool master Alexey Ermakov 2025-12-05 14:47:16 +0600
  • 58d3bff00a
         Merge pull request #15 from Melkij/query_stat_total_18 Marat B. 2025-10-14 13:28:03 +0200
  • 7d123d8ad5 sql/global_reports/query_stat_total variant for postgresql 18 There are no functional changes compared to PostgreSQL 17 version, so just a symlink #15 melkij 2025-10-13 15:16:16 +0300
  • ed7886f380 Fix average time calculation: remove multiply by 1000 #14 FixStatQueries Marat Bogatyrev 2025-07-11 14:22:29 +0200
  • f59b296aa4
         Merge pull request #13 from dataegret/TableBloatApprox Ilya Kosmodemiansky 2025-07-11 12:43:38 +0200
  • 0824671abc change script table_bloat_approx.sql #13 TableBloatApprox Marat Bogatyrev 2025-07-11 12:31:30 +0200
  • 868937af06 added working support for 17 version melkij 2025-01-09 12:48:04 +0300
  • a4a242edca added support for 17 version Maxim Boguk 2025-01-07 09:25:53 +0000
  • 57a140018f check identity table_indentity Ilya Kosmodemiansky 2024-08-23 17:25:58 +0200
  • c4ceb837a2
         Format code: newlines, spaces, indents, unneccessary brackets deleted #12 Rinat Mukhtarov 2024-04-12 13:20:21 +0300
  • 7d8552b127 added global report for Postgresql 16 (symlink) melkij 2023-12-13 15:25:02 +0300
  • c14b025bb7
         Update LICENSE.md Valeria Kaplan 2023-03-22 14:21:22 +0000
  • 7b7e62042a
         Update LICENSE.md Valeria Kaplan 2023-03-22 14:20:20 +0000
  • f9c575e076
         Update LICENSE.md Valeria Kaplan 2023-03-22 14:00:20 +0000
  • 7950d96cfe added global report for Postgresql 15 Maxim Boguk 2023-02-28 18:43:34 +1100
  • 8a612bd826 index_candidates_to_deduplicate: don't skip indexes without MCV statistics Alexey Ermakov 2022-09-13 18:28:37 +0600
  • 38f6eced67 check only valid indexes calling bt_metap during loading tuples in tree will corrupt this index: https://www.postgresql.org/message-id/flat/17568-ef121b956ec1559c%40postgresql.org melkij 2022-08-15 16:12:43 +0300
  • 33e02f698a indexing_progress.sql: add additional columns, improve readability; index_candidates_to_deduplicate: fix columns order for multicolumn indexes estimates Alexey Ermakov 2022-08-02 12:04:43 +0600
  • f7d9d90dfa table_bloat_approx.sql: add table mask prompt, combine table and schema names. index_candidates_to_partial.sql: fix typo Alexey Ermakov 2022-07-19 18:31:59 +0600
  • b116f7e1aa Replication and progress scripts. Victor Yegorov 2022-05-10 21:29:50 +0300
  • 2465cfab78 fix index_candidates_to_deduplicate (allow index names with uppercase letters) Alexey Ermakov 2022-03-05 16:22:15 +0600
  • f630d80e42 add reindex_non_btree_indexes.sql Alexey Ermakov 2022-03-02 15:12:25 +0600
  • ed7f42cc5d Add index_candidates_to_deduplicate.sql query to list indexes which could benefit from "btree index deduplication" feature in pg 13+ Alexey Ermakov 2022-02-16 13:27:30 +0600
  • 1b6c20cd10 create version specific symlinks for query_stat_total_*.sql Maxim Boguk 2022-01-28 00:24:48 +0300
  • 7ec1f2d0dd index_watch -> pg_index_watch (external) Nina Belyavskaya 2021-10-18 13:02:36 +0200
  • 8e5dbc8cf3 file name fix PostgreSQL program user 2021-10-15 13:49:36 +0300
  • b312b40430 added check script for pk on all tables (required for logical replication) PostgreSQL program user 2021-10-15 13:44:09 +0300
  • fa66a12eba 100MB -> 10MB in comment Nina Belyavskaya 2021-10-14 16:33:39 +0200
  • 90d88801ad Merge branch 'master' of https://github.com/dataegret/pg-utils Nina Belyavskaya 2021-10-14 16:30:15 +0200
  • 7c7ed0d4fd 100MB -> 10MB in comment Nina Belyavskaya 2021-10-14 16:29:26 +0200
  • 6eb13513bc add vacuum_truncate_speedup script Alexey Ermakov 2021-10-12 18:35:21 +0600
  • 52e20c165e version 0.9 Nina Belyavskaya 2021-10-01 16:02:58 +0200
  • b58b21bea9 Merge branch 'master' of https://github.com/dataegret/pg-utils Nina Belyavskaya 2021-10-01 11:02:05 +0200
  • aebc1492d1 Merge branch 'master' of https://github.com/dataegret/pg-utils Nina Belyavskaya 2021-10-01 10:43:05 +0200
  • b955af2c02 check the uniqueness of the launch Nina Belyavskaya 2021-10-01 10:41:36 +0200
  • df5fc036e0 check the uniqueness of the launch Nina Belyavskaya 2021-10-01 10:40:04 +0200
  • 51aedf99ee change minimal index size from 100MB to 10MB Maxim Boguk 2021-09-22 08:51:59 +0000
  • 02e9f1b7aa work with non-default port Nina Belyavskaya 2021-09-22 10:20:44 +0200
  • 23f084539c 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. Alexey Ermakov 2021-08-16 19:27:53 +0600
  • 181fff2a15
         catch devision by zero #10 Sardorkhuja Tukhtakhodjaev 2021-08-12 10:40:08 +0500
  • 46a2f1c2b3
         catch devision by zero #9 Sardorkhuja Tukhtakhodjaev 2021-08-12 10:31:36 +0500
  • 47b32709f3 bump version on 0.7 Maxim Boguk 2021-08-06 10:15:17 +0000
  • e950e711d0 fix division by zero and bump function version on 0.7 Maxim Boguk 2021-08-06 10:01:15 +0000
  • 5b961695d2 change column name change_column_names Test User 2021-07-15 13:49:20 +0700
  • 091c0327b5
         Update table_index_write_activity.sql #8 Nikitin-Alexandr 2021-07-07 18:17:46 +0700
  • ef635a8ba7
         Update table_write_activity.sql Nikitin-Alexandr 2021-07-07 18:15:58 +0700
  • 1dceb56bb5
         Update table_write_activity.sql Nikitin-Alexandr 2021-07-07 18:15:31 +0700
  • 2286901404
         Update table_write_activity.sql Nikitin-Alexandr 2021-07-07 18:14:53 +0700
  • df4dbb1443
         Update table_index_write_activity.sql Nikitin-Alexandr 2021-07-07 18:14:08 +0700
  • 26834275ae
         Update table_write_activity.sql Nikitin-Alexandr 2021-07-07 18:12:53 +0700
  • 95576f6b61
         Rename sql/83compat.sql to sql/old/83compat.sql Nikitin-Alexandr 2021-07-07 18:11:27 +0700
  • 3b702638c7
         Update table_candidates_from_ssd.sql Nikitin-Alexandr 2021-07-07 18:10:52 +0700
  • 3e15665828
         Update dirty_to_read_stat.sql Nikitin-Alexandr 2021-07-07 18:10:09 +0700
  • 9997540cda
         Update index_disk_activity.sql Nikitin-Alexandr 2021-07-07 18:09:36 +0700
  • b312694627
         Update index_bloat.sql Nikitin-Alexandr 2021-07-07 18:08:06 +0700
  • 008af53542
         Update query_stat_counts.sql Nikitin-Alexandr 2021-07-07 18:06:47 +0700
  • 597c1c1ca5
         Update table_bloat_approx.sql Nikitin-Alexandr 2021-07-07 17:56:57 +0700
  • 3823d9da5d
         Update low_used_indexes.sql Nikitin-Alexandr 2021-07-07 17:54:50 +0700
  • 05f3eed03f
         Update low_used_indexes.sql Nikitin-Alexandr 2021-07-07 17:53:46 +0700
  • dfb8abe163
         Update seq_scan_tables.sql Nikitin-Alexandr 2021-07-07 17:53:14 +0700
  • 2521d44201
         Update table_candidates_to_ssd.sql Nikitin-Alexandr 2021-07-07 17:52:43 +0700
  • 2e6a3265c1
         Update table_candidates_from_ssd.sql Nikitin-Alexandr 2021-07-07 17:52:07 +0700
  • a7e9c2cbec
         Update table_index_write_activity.sql Nikitin-Alexandr 2021-07-07 17:51:33 +0700
  • 32aece7f84
         Create temp.txt Nikitin-Alexandr 2021-07-02 15:23:46 +0700
  • 79db36c3bf
         Delete temp.txt Nikitin-Alexandr 2021-07-02 14:56:27 +0700
  • 151c24f8ff
         Rename create_db_activity_view9.6.sql to create_db_activity_view.sql Nikitin-Alexandr 2021-07-02 14:03:54 +0700
  • 38d4f0ab09
         Rename sql/create_db_activity_view_old.sql to sql/old/create_db_activity_view_old.sql Nikitin-Alexandr 2021-07-02 14:02:41 +0700
  • aee429eaad
         Rename create_db_activity_view.sql to create_db_activity_view_old.sql Nikitin-Alexandr 2021-07-02 14:02:01 +0700
  • dd12258614
         Create temp.txt Nikitin-Alexandr 2021-07-02 13:44:12 +0700
  • ccbdbdeb40
         Delete temp.txt Nikitin-Alexandr 2021-07-02 13:43:11 +0700
  • 00788f8d72
         Rename sql/table_disk_activity.sql to sql/old/table_disk_activity.sql Nikitin-Alexandr 2021-07-02 13:41:42 +0700
  • e135505fa3
         Create temp.txt Nikitin-Alexandr 2021-07-02 13:38:31 +0700
  • e6dc31c9b7 add check to skip exculsion constraint indexes to prevent error: concurrent index creation for exclusion constraints is not supported Maxim Boguk 2021-06-06 20:31:19 +0000
  • b0f3ed45fe script set restructurization Maxim Boguk 2021-06-05 11:39:22 +0300
  • 63e8c0af83 add database ordering during work Maxim Boguk 2021-06-04 05:57:53 +0000
  • 58fd879702 fix config comment Maxim Boguk 2021-05-27 21:12:32 +0000
  • dfdc83f253 single file split into rarely changed data(tables) structure and stateless code(procedures) structure files Maxim Boguk 2021-05-27 08:38:23 +0000
  • 920c603241 change default value of minimum_reliable_index_size Maxim Boguk 2021-05-27 06:58:57 +0000
  • fc3377cc64 removed debug RAISE NOTICE Maxim Boguk 2021-05-25 23:10:40 +0000
  • 0ace45e395 change bloat scale factor from 1.5 to 2 Maxim Boguk 2021-05-25 22:12:44 +0000
  • 3c32db2d24 small fix Maxim Boguk 2021-05-25 20:22:48 +0000
  • ed9abd08b9 index_watch added Maxim Boguk 2021-05-25 19:38:32 +0000
  • 9a913c005e some fixes Maxim Boguk 2021-04-28 10:33:42 +0200
  • 2942fd3042 check_replication_lag.pl improvements: show correct lag when replica is restoring WALs from archive Alexey Ermakov 2021-04-27 17:32:01 +0600
  • 410dda83ab rework of structure Maxim Boguk 2021-04-22 11:31:20 +0200
  • a5880cee51 some more fixes Maxim Boguk 2021-04-21 12:38:55 +0200
  • b33dbf6a2f typo fix Maxim Boguk 2021-04-21 12:33:58 +0200
  • f102298ff0 simplification and cleanup Maxim Boguk 2021-04-21 12:17:57 +0200
  • 106d00ba9d adding support for pg_stat_statements 1.8 (introduced on postgresql 13) for query_stat_total.sql report (in separate file) Alexey Ermakov 2021-03-29 15:34:37 +0600
  • b555ba5419 Improve README. Victor Yegorov 2021-02-10 22:46:43 +0100
  • 1d4d6c7dd3 Introduce offline lag checking script. Victor Yegorov 2021-02-10 22:26:15 +0100
  • 598cd5833e query_stat_total.sql fixes: display "unknown" for rows in pg_stat_statements with null in query column. fix "division by zero" error for pg13 when call column could be 0. Alexey Ermakov 2021-01-21 16:57:37 +0600
  • 729bc99157
         Update README.md Ilya Kosmodemiansky 2021-01-21 11:32:07 +0100
  • 0fd6a3b61b added usage to comment PostgreSQL administrator 2020-09-15 22:20:40 +0300
  • 43cfcb0654 script for am check text indexes PostgreSQL administrator 2020-09-15 21:05:20 +0300