pg-utils

Commit Graph

Author	SHA1	Message	Date
melkij	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	2 months ago
Marat Bogatyrev	0824671abc	change script table_bloat_approx.sql	5 months ago
melkij	868937af06	added working support for 17 version postgresql commit 13d00729d422c84b1764c24251abcc785ea4adb1 renamed blk_read_time/blk_write_time columns. That's why the symlink didn't work with the new version. While here, slightly change IO timing calculations: now it includes in addition to shared_blk_read_time also local_blk_read_time and temp_blk_read_time. These are also IO timings, so it will be more correct this way. Similarly with write timings.	11 months ago
Maxim Boguk	a4a242edca	added support for 17 version	11 months ago
melkij	7d8552b127	added global report for Postgresql 16 (symlink)	2 years ago
Maxim Boguk	7950d96cfe	added global report for Postgresql 15	3 years ago
Alexey Ermakov	8a612bd826	index_candidates_to_deduplicate: don't skip indexes without MCV statistics	3 years ago
melkij	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	3 years ago
Alexey Ermakov	33e02f698a	indexing_progress.sql: add additional columns, improve readability; index_candidates_to_deduplicate: fix columns order for multicolumn indexes estimates	3 years ago
Alexey Ermakov	f7d9d90dfa	table_bloat_approx.sql: add table mask prompt, combine table and schema names. index_candidates_to_partial.sql: fix typo	3 years ago
Victor Yegorov	b116f7e1aa	Replication and progress scripts. User-friendly output from the: - pg_stat_replication - pg_stat_progress_vacuum - pg_stat_progress_create_index	4 years ago
Alexey Ermakov	2465cfab78	fix index_candidates_to_deduplicate (allow index names with uppercase letters)	4 years ago
Alexey Ermakov	f630d80e42	add reindex_non_btree_indexes.sql	4 years ago
Alexey Ermakov	ed7f42cc5d	Add index_candidates_to_deduplicate.sql query to list indexes which could benefit from "btree index deduplication" feature in pg 13+	4 years ago
Maxim Boguk	1b6c20cd10	create version specific symlinks for query_stat_total_*.sql	4 years ago
PostgreSQL program user	8e5dbc8cf3	file name fix	4 years ago
PostgreSQL program user	b312b40430	added check script for pk on all tables (required for logical replication)	4 years ago
Alexey Ermakov	6eb13513bc	add vacuum_truncate_speedup script	4 years ago
Alexey Ermakov	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.	4 years ago
Nikitin-Alexandr	32aece7f84	Create temp.txt	5 years ago
Nikitin-Alexandr	79db36c3bf	Delete temp.txt	5 years ago
Nikitin-Alexandr	151c24f8ff	Rename create_db_activity_view9.6.sql to create_db_activity_view.sql rename from view9.6.sql to view.sql	5 years ago
Nikitin-Alexandr	38d4f0ab09	Rename sql/create_db_activity_view_old.sql to sql/old/create_db_activity_view_old.sql mv file to "old"	5 years ago
Nikitin-Alexandr	aee429eaad	Rename create_db_activity_view.sql to create_db_activity_view_old.sql rename file to *_old.sql	5 years ago
Nikitin-Alexandr	dd12258614	Create temp.txt Create directory "slony"	5 years ago
Nikitin-Alexandr	ccbdbdeb40	Delete temp.txt	5 years ago
Nikitin-Alexandr	00788f8d72	Rename sql/table_disk_activity.sql to sql/old/table_disk_activity.sql move old file to "old" directory	5 years ago
Nikitin-Alexandr	e135505fa3	Create temp.txt	5 years ago
Alexey Ermakov	106d00ba9d	adding support for pg_stat_statements 1.8 (introduced on postgresql 13) for query_stat_total.sql report (in separate file)	5 years ago
Alexey Ermakov	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.	5 years ago
PostgreSQL administrator	0fd6a3b61b	added usage to comment	5 years ago
PostgreSQL administrator	43cfcb0654	script for am check text indexes	5 years ago
Alexey Ermakov	d9e225fd6f	show queries from dropped users and databases as from "unknown" instead of empty rows.	6 years ago
Alexey Ermakov	3bfdc3b820	add sql/index_candidates_to_partial.sql	6 years ago
Andrey-Salnikov	598fc8f3f8	Updated lastest actual versions of PostgreSQL 20th June 2019: PostgreSQL 11.4, 10.9, 9.6.14, 9.5.18, 9.4.23, and 12 Beta 2 Released!	7 years ago
Andrey-Salnikov	e3a3835900	Modified script for proper checking low used indecies on replica servers.	7 years ago
Andrey-Salnikov	d00de50c46	Added script for checking actual version of PostgreSQL Modified script to check low used indexes on replica servers	7 years ago
Victor Yegorov	31705a3b4c	Correct duplicate leader detection Reverse leader level check for non-cycled case.	7 years ago
Victor Yegorov	4dbb55ec9d	Provide `wait_on_object` column in the output It might desirable to see which object we're waiting on. To do so join to the pairs by both, locker and waiter, otherwise duplicates are prodcued. To do so add `dad` column to the `tree` subquery. It was tempting to also change database and relation (wherever possible) oids into names, but I choose not to do so.	7 years ago
Victor Yegorov	1f5514f0d4	Another duplicates fix for locks tree It turns out that quite frequently single session will block others on different objects, especially if it is idle in transaction. Therefore get rid of the `mode` column in `leads` and `tree` subqueries and group leads only by locker. This lead to the change for the non-cyclic sessions. As `mode` is gone, lockers are filtered by highest level instead. Last change was to get rid of early cycle checks in the `leads` subquery, as it is causing wrong results when tree is formed.	7 years ago
Victor Yegorov	f2f7e3a291	Update tree output - display `!>` for deadlocked sessions - reduce interval precisions to full seconds - rearrange columns - put oldest lockers on top	7 years ago
Victor Yegorov	a38f24f882	Add deadlock detection It might happen that all lockers are also waiting on some other resources, which leads to empty output. Properly detect locking leads via another recursive check on lockers only.	7 years ago
Victor Yegorov	b0376e2726	Avoid duplicates in lockers In cases where locker is holding several locks on the same entry, make sure to use only the highest lock to avoid duplicates. Lock mode is transfered into numeric form via array. It is possible to convert it back, but as mode is not shown in the final output I choose not bother.	7 years ago
Alexey Ermakov	b193b05851	show materialized views at top_tables.sql output	7 years ago
Victor Yegorov	c04360d444	Add `locktree.sql` to the collection Query to display a tree of blocking sessions based on the information from `pg_locks` and `pg_stat_activity` views.	8 years ago
Alexey Ermakov	fe9ea524ab	fix table_bloat/index_bloat queries: don't read unlogged tables on replicas, get info from materialized views add table_bloat_approx query which uses pgstattuple_approx function	8 years ago
Andrey-Salnikov	c105ee06f5	Added new sql script for checking PostgreSQL configuration over pg_settings view.	8 years ago
Alexey Ermakov	1c2c6dab48	fix tables/indexes bloat queries: ignore temp tables, invalid indexes, support different schemas.	8 years ago
PostgreSQL administrator	8c5aa354f8	added seq scan tables analyze with replica info included	8 years ago
PostgreSQL administrator	ff24f8034d	added low used indexes analyze version with replica indexes included	8 years ago

1 2

82 Commits (master)