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 months ago
Marat B.	58d3bff00a	Merge pull request #15 from Melkij/query_stat_total_18 ... sql/global_reports/query_stat_total variant for postgresql 18	4 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	4 months ago
Ilya Kosmodemiansky	f59b296aa4	Merge pull request #13 from dataegret/TableBloatApprox ... Refactor bloat query: switch to tuple_len method, support TOAST via approx	7 months ago
Marat Bogatyrev	0824671abc	change script table_bloat_approx.sql	7 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.	1 year ago
Maxim Boguk	a4a242edca	added support for 17 version	1 year 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	4 years ago
Alexey Ermakov	33e02f698a	indexing_progress.sql: add additional columns, improve readability; index_candidates_to_deduplicate: fix columns order for multicolumn indexes estimates	4 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	4 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.	5 years ago
Maxim Boguk	47b32709f3	bump version on 0.7	5 years ago
Maxim Boguk	e950e711d0	fix division by zero and bump function version on 0.7	5 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