58fd879702
fix config comment
5 years ago
dfdc83f253
single file split into rarely changed data(tables) structure and stateless code(procedures) structure files
5 years ago
920c603241
change default value of minimum_reliable_index_size
5 years ago
fc3377cc64
removed debug RAISE NOTICE
5 years ago
0ace45e395
change bloat scale factor from 1.5 to 2
5 years ago
3c32db2d24
small fix
5 years ago
ed9abd08b9
index_watch added
5 years ago
9a913c005e
some fixes
5 years ago
2942fd3042
check_replication_lag.pl improvements: show correct lag when replica is restoring WALs from archive
5 years ago
410dda83ab
rework of structure
5 years ago
a5880cee51
some more fixes
5 years ago
b33dbf6a2f
typo fix
5 years ago
f102298ff0
simplification and cleanup
5 years ago
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
b555ba5419
Improve README.
...
This changes just the existing README entries, more to add.
5 years ago
1d4d6c7dd3
Introduce offline lag checking script.
...
Script checks lag against provided source in the cases when local
database is offline (not available for queries) and/or when remote
primary database is not directly reachable over network.
On passing, improve README wording slightly.
5 years ago
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
729bc99157
Update README.md
5 years ago
0fd6a3b61b
added usage to comment
5 years ago
43cfcb0654
script for am check text indexes
5 years ago
d6eaa47672
fix getting pgbouncer version
6 years ago
d9e225fd6f
show queries from dropped users and databases as from "unknown" instead of empty rows.
6 years ago
0f31b39343
Make check_replication_lag work with perl 5.10
6 years ago
b68fdb5b67
Merge pull request #6 from vitabaks/master
...
server-audit.sh: add server model info and exclude pg_basebackup from query result.
6 years ago
9410f05b1c
server-audit.sh: rename entry to be Streaming connections instead of Replicas.
6 years ago
07613c99a5
server-audit.sh: remove any where application_name filters
6 years ago
c6c4c4b55a
Merge branch 'crl_improvements'
6 years ago
869393f9ad
server-audit.sh: pgReplicaCount and pgReplicaList (exclude pg_basebackup).
...
1) In the primary_conninfo can be set to а custom of "application_name" value. In this case, application_name will not equal the value of "walreceiver".
2) Exclude "pg_basebackup" from the query result.
6 years ago
54f463922d
server-audit.sh: added server model info in hardware summary
6 years ago
e8db0d06b0
server-audit.sh: use more strict regexp when parsing postgresql.conf
6 years ago
3bfdc3b820
add sql/index_candidates_to_partial.sql
6 years ago
acf5a8cdb9
Replica thresholds and help improvements
...
Make it possible to provide optional thresholds for replicas.
Improve address handling, enforce square brackets for the IPv6 addresses
(per RFC3986).
Provide much more details in the help section.
On passing, reorganize code and move address handling into own function.
6 years ago
4ec0e485fa
Add optional ports to check_replication_lag
...
Now it is possible to specify port of master/replica via colon.
On passing, tidy up the code for common style.
6 years ago
f0a3cc6640
check_replication_lag improvements
...
- add extended Usage message
- add possibility to specify several replicas via comma
- add possibility to specify lag in KB and MB
- pretty-print lag as KB, MB, GB instead of plain bytes
6 years ago
9df8de36f8
Fix checking new verions of pgBouncer
6 years ago
9c31e22dbb
hotfix: get info about indexes/functions from the single views
6 years ago
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
e3a3835900
Modified script for proper checking low used indecies on replica servers.
7 years ago
d00de50c46
Added script for checking actual version of PostgreSQL
...
Modified script to check low used indexes on replica servers
7 years ago
afd4d67c87
Better detection of replication state of the host
...
Now it is not neccessary to comment out checks when servers exchange
their roles during switchover.
Also cascading replicas can be monitored now, we're checking lag between
current cascaded replica and it's remote.
Details:
- for MASTER (can be cascading replica) use either
pg_current_wal_lsn() or pg_last_wal_receive_lsn()
- for REPLICA use either pg_last_wal_receive_lsn()
or return NULL in cases database is open (not in replicaiton)
- trim trailing newline via `tr -d '\n'`
7 years ago
5168646df3
replace envsubst with cat in makecron.sh
7 years ago
56ad316cee
makecron.sh: fix issues
7 years ago
71672b61f8
makecron.sh: fix shell commands substitution
7 years ago
d98e065e2d
added makecron.sh
7 years ago
444fcf0cbf
bin/server-audit.sh: show number of pending_resart
7 years ago
7ae659ca40
bin/server-audit.sh: show 'nofile' details about pgbouncers
7 years ago
08c90a60f6
Added separated output for wal readers
7 years ago
681ee28ac3
Added sueqntial pareser for standard postgresql logs. just for internal using.
7 years ago
8231b32e5f
Added support for AWS EC2 NVMe disks.
...
Now you can see what a ueue schedule is used for that kind of disks.
7 years ago
31705a3b4c
Correct duplicate leader detection
...
Reverse leader level check for non-cycled case.
7 years ago
Maxim Boguk
Maxim Boguk
Alexey Ermakov
Victor Yegorov
Ilya Kosmodemiansky
PostgreSQL administrator
PostgreSQL administrator
Alexey Lesovsky
Vitaliy Kukharik
Andrey-Salnikov
Alexey Lesovsky