Branch: master

FixStatQueries

TableBloatApprox

add-readme

change_column_names

master

my_cool_feature

table_indentity

Branches Tags

${ item.name }

Create tag ${ searchTerm }

Create branch ${ searchTerm }

from 'master'

${ noResults }

Commit Graph

199 Commits (master)

 

All Branches   

Search

Author	SHA1	Message	Date
Alexey Ermakov	66e294a01f	Add pg_log_search - fast PostgreSQL log query search tool	2 weeks ago
Marat B.	58d3bff00a	Merge pull request #15 from Melkij/query_stat_total_18 ... sql/global_reports/query_stat_total variant for postgresql 18	2 months ago
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
Ilya Kosmodemiansky	f59b296aa4	Merge pull request #13 from dataegret/TableBloatApprox ... Refactor bloat query: switch to tuple_len method, support TOAST via approx	5 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
Valeria Kaplan	c14b025bb7	Update LICENSE.md ... added spaces	3 years ago
Valeria Kaplan	7b7e62042a	Update LICENSE.md	3 years ago
Valeria Kaplan	f9c575e076	Update LICENSE.md	3 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
Nina Belyavskaya	7ec1f2d0dd	index_watch -> pg_index_watch (external)	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
Nina Belyavskaya	fa66a12eba	100MB -> 10MB in comment	4 years ago
Nina Belyavskaya	90d88801ad	Merge branch 'master' of https://github.com/dataegret/pg-utils	4 years ago
Nina Belyavskaya	7c7ed0d4fd	100MB -> 10MB in comment	4 years ago
Alexey Ermakov	6eb13513bc	add vacuum_truncate_speedup script	4 years ago
Nina Belyavskaya	52e20c165e	version 0.9	4 years ago
Nina Belyavskaya	b58b21bea9	Merge branch 'master' of https://github.com/dataegret/pg-utils	4 years ago
Nina Belyavskaya	aebc1492d1	Merge branch 'master' of https://github.com/dataegret/pg-utils ... check the uniqueness of the launch	4 years ago
Nina Belyavskaya	b955af2c02	check the uniqueness of the launch	4 years ago
Nina Belyavskaya	df5fc036e0	check the uniqueness of the launch	4 years ago
Maxim Boguk	51aedf99ee	change minimal index size from 100MB to 10MB	4 years ago
Nina Belyavskaya	02e9f1b7aa	work with non-default port	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
Maxim Boguk	47b32709f3	bump version on 0.7	4 years ago
Maxim Boguk	e950e711d0	fix division by zero and bump function version on 0.7	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
Maxim Boguk	e6dc31c9b7	add check to skip exculsion constraint indexes to prevent error: concurrent index creation for exclusion constraints is not supported	5 years ago
Maxim Boguk	b0f3ed45fe	script set restructurization	5 years ago
Maxim Boguk	63e8c0af83	add database ordering during work	5 years ago