pgcenter

Changelog

62a33c5 Adjust query for getting statements rate, accordingly to v13.
67a8df9 Adjust query for getting statements timings, accordingly to v13.
4f87424 Update travic-ci config: disable 'skip_cleanup', bump Go version to 1.14.

Changelog

7ee17a8 Merge branch 'dev'
7fd386c Merge branch 'issue-73' into dev
107801a Merge pull request #68 from lesovsky/dev
043994d Merge pull request #69 from lesovsky/dev
8904129 Merge pull request #70 from lesovsky/dev
59c9394 avoid passing zeroes to column widthes when do aligning
89be232 fix LDFLAGS in goreleaser config
8b71426 fix goreleaser changes - it breaks travis builds
7bd2d79 fix report query (G hothkey)
12127bc prepare 0.6.5 - update Changelog
152fb71 simplify Makefile, make cmd-related variables unexported
638491b tidy go modules

Changelog

cd2f24d attempt to fix goreleaser builds
cd793e2 attempt to fix goreleaser builds, 2
cdac7ef attempt to fix goreleaser builds, 3
be1d2ad goreleaser: clean before build
cb1e2e3 update travis config

Changelog

6340c1f Accept /proc/diskstat metrics with extra fields.
e555ab8 Merge branch 'dev'
c333d5a Merge pull request #64 from alexeyklyukin/diskstat_newer_kernels
ac9aedc added help description about pg_stat_progress_create_index view
7eb887f added menu for switching between progress stats in top utility
40c0f46 added pg_stat_progress_cluster stats to top/record/report utils
b669964 added pg_stat_progress_create_index stats
6923412 added stats context related to pg_stat_progress_cluster view
ea40b86 added support for pg_stat_database.checksum_failures
d170322 adjust header's styles of iostat/nicstat tabs in top utility
77db2dd another try of aligning refactoring - skip aligning if no rows in result set - don't truncate long values, such as names
6f040cf avoid rude disconnection from postgres at top-program exit
e7d9a77 describe "pgcenter config" doc more verbosely
73c4701 fix crashes when postgres is not running
477538e fix units
4c84af6 implemented switching between two progress stats
e5480d9 improve input args for progress stats in report utility
e41c3c8 inject version info at build time
20c8ef7 moved psql hotkey from 'p' to '~'
8bef0e0 readme/changelog changes
5276228 report: print header at the beginning of the output
4a36439 rethinking pg_stat_progress_vacuum query: - wait events merged into single column - changed order of columns - move 'wait events' after 'state' - changed totals to percents for scanned and vacuumed numbers changed reports' buitin docs

Changelog

91d51a1 Cursor handling improvements
4f61f75 Hide cursor when canceling operation
2250063 Merge pull request #60 from kjoe/dev
0738f4a Merge pull request #61 from kjoe/dev
b854b03 Merge pull request #63 from kjoe/feature/cursor
07db7eb Quitting from help and main screens with 'q' key
b363876 fix code formatting, misspeling, etc.
bd9690e fixed acidentally used case-sensitive pattern matching when accounting number of user-started vacuums
450bc6c record/report: extend "--help" messages
388b682 record/report: improve aligning and truncation of pg_stat_statements.query
f9b1499 reworked pg_stat_statements queries
e71ec38 rewrite PQconnectdb using connection setup in a loop
59e4bd9 top-like UI highlighting improvements
c1293cf top: do polling pg_stat_statements only if it's available (issue #59)
8f1f0a8 top: fixed handling of libpq errors during connection establishment
0079bfd top: printLogtail() tiny refactoring, removed unnecessary retval
ef35a4e top: read remote stats only if pgcenter schema exists
5e5565e top: removed notes about deprecated hotkeys; issue #57
a5aa203 v0.6.2

Changelog

9b148b4 Merge branch 'dev'
976339e README: add badges
2e1d14a top: fix wrong assembling of path to logfile

Changelog

680d081 Added dependencies downloading before building
c3aed31 Changelog file is returned
bf8c8d2 Merge branch 'dev'
0978622 Merge pull request #46 from andyone/master
a2ab4d0 added CGO_ENABLED=0
68fb4a8 added goreleaser support
549d54b added wait events profiling
fc8dd3b cast all numeric to the same precision
201a688 command management refactoring: config: moved parameters check from main program code to command management code config: emit error if neither '-i' nor '-u' specified profile: emit error if '-P' is not specified
d9a5906 doc improvements and fixes
bb1eeaa fix division by zero in query to pg_stat_user_functions
4cf170a fix travis config
088705e fix travis config, try 2
f6de7d4 fixed GoReport recommendations top: fix wrong masks handling when cancel/terminate group of backends fixed cyclomatic complexity in functions added proper comments for variables and methods done code formatting
3d5a44a lib/stat: fix wrong calculation of hits values
c303834 lib/utils/postgres: remove explicit sslmode from connectin string
90cad1e output aligning rewritten: - fixed aligning for 'top' command - dynamic aligning for 'report' command - two new hotkeys in 'top', have been introduced which allow to change width of active columns (up/down arrows) - column width map moved from PGresult level to Context - aligning is performed once when first stats displayed - stat.Print() marked as deprecated - fixed couple IDE's warnings (unused variables)
3e1ba7a pg_stat_database query fixes: - strict cast of blk_read_time and blk_write_time to numeric helps to avoid some kind of errors in diff/sort operations - show blks_read in kilobytes - clarify builtin help add error check into PGresult.New()
4c91221 profile: added docs and examples
b63da12 release 0.6.0
87b64c3 remove tabs from queries (looks ugly when log_destination=syslog)
b7d6c3e removed old commented and unused code
6282caf report: extend built-in help
b43be09 report: show last processed stats file on error\ when something goes wrong and pgcenter is failed to read stats, it shows name of\ last processes stats file within tar file. It helps to debug what was happened.
49a419e some refactoring in connection handling module: added error handling of pq (go driver) related errors added extra error handling in replaceEmptySettings() rewriten PGhost(), use advanced query for getting 'host' value fixed error when attepmting to connect to non-SSL postgres: 'pq: SSL is not enabled on the server'

• PostgreSQL 10 support:
  • xlog -> wal changes are implemented.
  • add lag fields into pg_stat_replication.
• Extended general overview:
  • add max_connections.
  • add info about prepared transactions.
• Add xact_age and time_age fields into pg_stat_replications.
• Add backend_type into pg_stat_activity.
• Add stats_age into pg_stat_database.
• Some bug fixes and code optimizations.

Major features:

• use qsort_r() instead of hand-made sorting - sort is now available for all columns;
• add filtration feature - it's possible to filter out unnecessary tables/indexes/queries/etc;
• add pg_stat_progress_vacuum (since 9.6);
• add compatibility with pg-9.6 (pg_stat_activity) - added wait_event and wait_event_type fields;
• added autovacuum info: print number of user vacuum and autovac max worker limit;
• exclude (auto)vacuum tasks accounting in xact_maxtime field;
• pg_stat_replication rewritten and now works on standbys too;
• change long queries min age from 500ms to 0ms - now all queries are shown in activity stats;
• allow to use connection settings from libpq env vars;
• pg_stat_statements: add local IO information context;
• pg_stat_statements: use menu and switching; c, v, V hotkeys are removed and X is used instead;
• remove unnecessary WHERE from pg_stat_statements queries;
• show details and hint if query has failed;
• and many many fixes and internal refactoring.

New:

• add iostat;
• add nicstat;
• pg_stat_statements fixes;
• use one button for config editing;
• other fixes and improvements.

add pg_stat_statements improvements.
add query detailed report based on pg_stat_statements.
add memory system statistics.
add support for 9.1.