PostgreSQL version:
9.4.4

postgresql.conf:
shared_preload_libraries = 'pg_stat_statements'
pg_stat_statements.max = 10000
pg_stat_statements.track = 'all'
pg_stat_statements.save = off

track_io_timing = on
log_lock_waits = on
log_temp_files = 0
track_activities = on
track_counts = on
track_functions = all

Operating system/version:
Debian GNU/Linux 8
3.16.0-4-amd64

pgcenter-0.4.0 installed from source.

PostgreSQL log:
ERROR: numeric field overflow
DETAIL: A field with precision 6, scale 3 must round to an absolute value less than 10^3.
STATEMENT: SELECT (sum(total_time) / sum(calls))::numeric(6,3) AS avg_query, sum(calls) AS total_calls FROM pg_stat_statements

As you've already warned in readme, segfauls might appear.
Most of the time, I want to switch to 'a' activity mode, I'm getting a segfault.

Which information do you need to fix the problem?

My system:´´´Linux tobwen 3.16.0-4-amd64 #1 SMP Debian 3.16.7-ckt20-1+deb8u1 (2015-12-14) x86_64 GNU/Linux´´´

My PostgreSQL: 9.4.5-0+deb8u1

activity screen should have a cpu usage column and screens can be colored with contrast colors.

Most postgres tools (pg_dump, psql) are happy with the same set of environment variables and this is how people (I for one) got used to control them.

Ref: http://www.postgresql.org/docs/current/static/libpq-envars.html

cheers

Regards

when I try to configure it gives me the following error:

ERROR: Can't locate Linux/Ethtool/Settings.pm in @inc (you may need to install the Linux::Ethtool::Settings module) (@inc contains: /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.22.1 /usr/local/share/perl/5.22.1 /usr/lib/x86_64-linux-gnu/perl5/5.22 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.22 /usr/share/perl/5.22 /usr/local/lib/site_perl .) at line 2.
BEGIN failed--compilation aborted at line 2.
DETAIL:
HINT:
STATEMENT: CREATE FUNCTION pgcenter.get_netdev_link_settings(INOUT iface CHARACTER VARYING, OUT speed BIGINT, OUT duplex INTEGER) RETURNS RECORD
LANGUAGE plperlu
AS $$
use Linux::Ethtool::Settings;
if (my $settings = Linux::Ethtool::Settings->new($[0])) {
my $if_speed = $settings->speed();
my $if_duplex = $settings->duplex() ? 1 : 0;
return {iface => $[0], speed => $if_speed, duplex => $if_duplex};
} else {
return {iface => $_[0], speed => 0, duplex => -1};
}
$$;

git clone https://github.com/lesovsky/pgcenter.git --single-branch --depth=1

$ make
go mod download
CGO_ENABLED=0 GOOS=linux GOARCH= go build -ldflags "-X main.COMMIT=9b148b446e53d558191fa63e86843bb0ae79cd86 -X main.BRANCH=master" -o pgcenter pgcenter.go

$ ./pgcenter
-bash: ./pgcenter: cannot execute binary file

$ ls -la pgcenter
-rwxr-xr-x 1 olleg staff 9053984 11 фев 15:06 pgcenter

MacOs 10.14.2,
$ go version
go version go1.11.5 darwin/amd64

pgcenter_0.6.0_Linux_x86_64.deb

'L' logtail.
result:
Failed to stat logfile: stat : no such file or directory

l open log file with pager.
result:
Can't determine log file: can't parse log_filename format

show log_directory;

    log_directory
---------------------
 /var/log/postgresql

show log_filename;

   log_filename
-------------------
 postgresql-%a.log

p.s.
This actions is worked on v0.4.0.

I suggest to reuse a higher level build system than your current small make file so that powerful checks for software features will become easier.

• CMake
• Autotools

Hi!

At startup pgcenter used all available memory and was killed with oom-killer
this behavior is only with version 10

Tested on different servers
Local and remote connection

Please help me!
I would very much like to use a pgcenter with postgresql 10

pgcenter: latest (installed from source)
OS: Debian 8 (3.16.0-4-amd64) and 9 (4.9.0-6-amd64)
PostgreSQL: 10.4 and 10.5

I want to test record and report feature and do like this.

pgcenter -h 127.0.0.01 -U postgres  record -f zabbix.tar -d zabbix
INFO: recording to zabbix.tar

 pgcenter -h 127.0.0.01 -U postgres  report -f zabbix.tar 
'pgcenter report' reads statistics from file and prints reports.

Usage:
  pgcenter report [OPTIONS]...

Options:
  -f, --file			read stats from file (default: pgcenter.stat.tar)
  -s, --start			starting time of the report (format: [YYYYMMDD-]HHMMSS)
  -e, --end			ending time of the report (format: [YYYYMMDD-]HHMMSS)
  -o, --order			order values by column (default descending, use '+' sign before a column name for ascending order)
  -g, --grep			filter values in specfied column (format: colname:filtertext)
  -l, --limit			print only limited number of rows per sample (default: unlimited)
  -t, --truncate		maximum string size to print (default: 32)
  -i, --interval		delta interval (default: 1s)

Report options:
  -A, --activity		show pg_stat_activity statistics
  -S, --sizes			show statistics about tables sizes
  -D, --databases		show pg_stat_database statistics
  -F, --functions		show pg_stat_user_functions statistics
  -R, --replication		show pg_stat_replication statistics
  -T, --tables			show pg_stat_user_tables statistics
  -I, --indexes			show pg_stat_user_indexes and pg_statio_user_indexes statistics
  -V, --vacuum			show pg_stat_progress_vacuum statistics
  -X, --statements [X]		show pg_stat_statements statistics, use additional selector to choose stats.
				'm' - timings; 'g' - general; 'i' - io; 't' - temp files io; 'l' - local files io. 

  -d, --describe		show statistics description, combined with one of the report options

General options:
  -?, --help		show this help and exit
      --version		show version information and exit

Report bugs to https://github.com/lesovsky/pgcenter/issues

I've got pg_stat_statements installed but not in the default schema for the user I've connected using. Is there a way for pgcenter to read it from a different schema?

When I run pgcenter,something is wrong.
I check pglog,found some error such as :

ERROR: relation "pgcenter.sys_proc_diskstats" does not exist
Statement: SELECT count(1) FROM pgcenter.sys_proc_diskstats
AND
Statement: SELECT count(1) FROM pgcenter.sys_proc_netdev,etc.

Thanks for the great tool frist! But when I run "pgcenter top mydb", specifying the DB to be monitored explicilty, still the stat_statements view shows statements from other DBs, making it a bit "crowded". Probably not as intended.

Source code is

snprintf(msg, 128, "Set filter, current: \"%s\": ", ctx.fstrings[ctx.order_key]);

Maybe better code

snprintf(msg, S_BUF_LEN, "Set filter, current: \"%s\": ", ctx.fstrings[ctx.order_key]);

I try use pgcenter with PostgreSQL 11.x, and get this error:

pgcenter top -U user -h 10.156.0.7 -d backend_prod
Password for user user : ERROR: pq: password authentication failed for user "user"

if i will try psql :

Password for user user: 
psql (9.6.11, server 11.1 (Ubuntu 11.1-3.pgdg18.04+1))
WARNING: psql major version 9.6, server major version 11.
         Some psql features might not work.
SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off)
Type "help" for help.

backend_prod=# \q

password is correct.

First of all thanks very much for the tool - the best one in its niche!

I believe pgcenter v0.5.0 has a problem with ordering by time columns. Please note that in the example below when using descending ordering by t_all_t 791:04:45 goes after 79:18:40 which is wrong.

user       database   t_all_t      t_read_t   t_write_t   t_cpu_t      all_t     read_t   write_t   cpu_t     calls   queryid      query            
*****	   *****      96:58:35     00:02:00   00:00:00    96:56:34     0.00      0        0         0.00      0       5081e3f831   
*****	   *****      96:06:25     00:00:05   00:00:00    96:06:20     0.00      0        0         0.00      0       50e483e9ae   
*****	   *****      95:48:34     00:00:00   00:00:00    95:48:34     0.00      0        0         0.00      0       767b8a56f9   
*****	   *****      86:49:53     00:07:09   00:00:00    86:42:44     0.00      0        0         0.00      0       01d93a5541   
*****	   *****      82:54:56     00:04:13   00:00:00    82:50:42     0.00      0        0         0.00      0       36bc1dca66   
*****	   *****      82:25:43     00:03:37   00:00:00    82:22:06     0.00      0        0         0.00      0       868c464987   
*****	   *****      80:39:06     00:00:01   00:00:00    80:39:04     15.00     0        0         15.00     2       79d439f1fa   
*****	   *****      79:18:40     00:00:00   00:00:00    79:18:40     0.00      0        0         0.00      0       117b589937   
*****	   *****      791:04:45    02:42:08   00:00:00    788:22:37    52.00     0.50     0         51.50     46      c0ad1d000f   
*****	   *****      77:20:25     05:42:33   00:00:00    71:37:51     0.50      0.00     0         1.00      1       d8c30fc873   
*****	   *****      74:42:21     00:00:00   00:00:00    74:42:21     0.00      0        0         0.00      1       313c122eae   
*****	   *****      74:38:34     00:00:00   00:00:00    74:38:33     0.00      0        0         0.00      0       0c83c46b25   
*****	   *****      74:23:57     00:06:18   00:00:00    74:17:38     0.50      0        0         0.50      0       e8609f8be3   
*****	   *****      74:15:11     00:06:20   00:00:00    74:08:50     0.00      0        0         0.00      0       86eebe2b71   

Thanks in advance.

pgCenter crashes when trying to start iostat (B hotkey).
gdb output

Program terminated with signal SIGSEGV, Segmentation fault.
#0  0x0000000000407bfe in print_iostat (window=0x11b3380, w_cmd=0x11ac260, c_ios=0x7ffcb2b95100, p_ios=0x7ffcb2b94ff0, bdev=32, repaint=0x7ffcb2b9528f) at pgcenter.c:1689
1689            c_ios[i]->major = major;

Catched on systems with too many lines in /proc/diskstats.

Would you like to replace more defines for constant values like REP_… by enumerations to stress their relationships?

GoReleaser - https://github.com/goreleaser/goreleaser

if you connect to a remote db host, it's confusing to show cpu/io stats (because they are not real)

this could either be auto-detected or use a commandline flag

FATAL: ERROR: column "deadlocks" does not exist
LINE 1: ...dates, tup_deleted AS deletes, conflicts, deadlocks,...

I propose to add support for narrow screens (1280x1024 for example) either by adaptive TUI, or by template option.

Steps to reproduce

1. Create a new Ubuntu 14.04 LTS VM or LXC container
2. Build PostgreSQL from source according to official documentation (it's easy!): ./configure --enable-tap-tests --enable-debug && make clean && make -j8 && make check && sudo make install
3. Use this init.d script to start a service: https://github.com/afiskon/postgresql-initd
4. Install pgcenter
5. Run pgcenter postgres

Expected result:

Nice picture like this: http://blog.postgresql-consulting.com/2015/12/pgcenter-020-released.html

Actual result:

Something like this http://i.imgur.com/Wpv9aUl.png

The connection to the server was lost. Attempting reconnect.
FATAL: no connection to the server
ERROR: Connection to : with postgres@postgres failed.

Hi!
On some databases, when the pgcenter is started, temporary files are generated.

LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp112190.57", size 26511854
2018-09-06 15:49:14 MSK 5b912212.1b63e [112190-116] [local] postgres@mydb STATEMENT: SELECT (sum(total_time) / sum(calls))::numeric(20,2) AS avg_query, sum(calls) AS total_calls FROM pg_stat_statements

work_mem = 512MB
PostgreSQL 9.4

As feature wishlist.
If query for pg_stat_statements return error "don't exists", remember this and don't repeat the query. :) Pg_stat_statements is an optional module for PostgreSQL.

The functions "endwin" and "exit" do not belong to the list of async-signal-safe functions.
I guess that a different program design will be needed for your function "sig_handler".

relation "pg_stat_statements" does not exist at character 98

2017-09-22 16:12:14 CST [32277-46833] postgres@postgres ERROR: relation "pg_stat_statements" does not exist at character 98
2017-09-22 16:12:14 CST [32277-46834] postgres@postgres STATEMENT: SELECT (sum(total_time) / sum(calls))::numeric(6,3) AS avg_query, sum(calls) AS total_calls FROM pg_stat_statements

Hi,

To build pgcenter RPMs on Fedora 23+, I added the following patch so that it detects ncurses 6. It may be good to add this upstream:

https://git.postgresql.org/gitweb/?p=pgrpms.git;a=blob;f=rpm/redhat/9.6/pgcenter/EL-6/pgcenter-makefile.patch;h=d904e8fe0b57b5bcf7e16a4cdbf36f56ed4a1f54;hb=61f8fe2d62127379ec3cd698fae2647959233142

Thanks!

How do you think about to benefit from parallel build trees also for this software?
Would you like to support out-of-source (VPATH) builds?

------------>command:
pgcenter -h localhost -p 5432 -U xdb -d testdb -i

------------>Message return:
INFO: installing stats schema into xdb@localhost:5432/testdb
ERROR: install stats schema into xdb@localhost:5432/testdb failed:
ERROR: Can't locate Linux/Ethtool/Settings.pm in @inc (@inc contains: /root/perl5/lib/perl5 /usr/local/lib64/perl5 /usr/local/s

I am on Debian 6/Squeeze, and I get this error on the compile:

cc -g -std=gnu99 -Wall -pedantic -I/usr/local/pgsql/include -L/usr/local/pgsql/lib -o pgcenter pgcenter.c -L/usr/lib -lncurses -lmenu -lpq
pgcenter.c: In function ‘get_speed_duplex’:
pgcenter.c:1701: error: ‘DUPLEX_UNKNOWN’ undeclared (first use in this function)
---------------------------

Hi,
first of all -- thank you for the great tool, we have successfully used it with PostgreSQL 9.6. After upgrade to version 10.0, click on 'r' replication returns an error:
ERROR: function pg_current_xlog_location() does not exist

I assume, the reason for it is -- function pg_current_xlog_location is renamed to pg_current_wal_lsn. More about new function names -- https://wiki.postgresql.org/wiki/New_in_postgres_10#Renaming_of_.22xlog.22_to_.22wal.22_Globally_.28and_location.2Flsn.29

Can you please look into it? Thanks in advance.

action: "pause program execution" (space) - does not work.

pgcenter_0.6.1_Linux_x86_64.deb

pgcenter sounds like it has a lot of awesome features. Even so, the UI could make or break it for me... It would be great to see a few screenshots of the tool in action to avoid having to install and configure it.

Hi,

pgcenter RPMs are available in PostgreSQL YUM repository: https://yum.postgresql.org . Can you please update to reflect this? Packages are available for RHEL 6, RHEL 7, and Fedora 23+

Thanks!

Regards, Devrim

Hi,

is it possible to push release 0.5 to community repository (download.postgresql.org) please ?

Thank you.

Best Regards

I would like to point out that an identifier like "__PGCENTER_H__" does not fit to the expected naming convention of the C language standard.
Would you like to adjust your selection for unique names?

pgcenter top -h localhost -U postgres -d mydb

pgcenter: 2018-12-15 14:59:21, load average: 0.00, 0.00, 0.00                                                         state [failed]: localhost:5432 postgres@iodb (ver: , up , recovery: )
    %cpu:  0.0 us,  0.0 sy,  0.0 ni,  0.0 id,  0.0 wa,  0.0 hi,  0.0 si,  0.0 st                                        activity:  0/0 conns,  0/0 prepared,  0 idle,  0 idle_xact,  0 active,  0 waiting,  0 others
 MiB mem:      0 total,      0 free,      0 used,        0 buff/cached                                                autovacuum:  0/0 workers/max,  0 manual,  0 wraparound, --:--:-- vac_maxtime
MiB swap:      0 total,      0 free,      0 used,      0/0 dirty/writeback                                            statements:   0 stmt/s, 0.000 stmt_avgtime, --:--:-- xact_maxtime, --:--:-- prep_maxtime

ERROR: auth failed
DETAIL:
HINT:

I even have a pgcenterrc file like this:
localhost:5432:mydb:postgres:mypassword

I can do psql like this:
psql -h localhost -U postgres mydb -p 5432

Hi,

Can i get historical data using this tool ? If yes, How? Please send document link if available.

Regards,
Sachin

This is what I get trying to build pgcenter on OS X 10.10.5:
$ make
cc -g -std=gnu99 -Wall -pedantic -I/usr/local/Cellar/postgresql/9.5.4_1/include -L/usr/local/lib -o pgcenter pgcenter.c -lpq -lncurses -lmenu
pgcenter.c:13:10: fatal error: 'linux/types.h' file not found

include <linux/types.h>

     ^

1 error generated.
make: *** [pgcenter] Error 1

Ubuntu 12.04 LTS, Postgres 9.2 running on the latest vagrant:

vagrant@precise64:$ git clone https://github.com/lesovsky/pgcenter
Cloning into 'pgcenter'...
remote: Counting objects: 861, done.
remote: Compressing objects: 100% (8/8), done.
remote: Total 861 (delta 1), reused 0 (delta 0), pack-reused 853
Receiving objects: 100% (861/861), 344.22 KiB | 292 KiB/s, done.
Resolving deltas: 100% (438/438), done.
vagrant@precise64:$ cd pgcenter
vagrant@precise64:/pgcenter$ make
cc -g -std=gnu99 -Wall -pedantic -I/usr/include/postgresql -L/usr/lib/x86_64-linux-gnu -L/usr/lib/x86_64-linux-gnu -o pgcenter pgcenter.c -lpq -lncurses -ltinfo -lmenu
pgcenter.c:15:18: fatal error: menu.h: No such file or directory
compilation terminated.
make: *** [pgcenter] Error 1
vagrant@precise64:/pgcenter$

I have installed pgcenter from source code on ubuntu 16.04. When I try to login to a database it gives above error.
pgcenter my_database

...like avg_t, avg_self_t. The columns are sorted as text, not as a number.

I suggest to add the key word "const" to the type specifiers for parameters like the following.

• progname (function "print_title")
• s_string, r_string (function "strrpl")

Would you like to apply the advices from an article to more places in your source files?

no running postgres

$ ps aux|grep postgres
lesovsky  8716  0.0  0.0  15652  1080 pts/5    S+   19:30   0:00 grep --colour=auto postgres

trying to run pgcenter and oops.

$ pgcenter top
panic: interface conversion: error is *net.OpError, not *pq.Error

goroutine 1 [running]:
github.com/lesovsky/pgcenter/lib/utils.PQconnectdb(0xb02f60, 0xc00001a240, 0x25, 0x6b19d0, 0x7919a0, 0x0)
        /home/lesovsky/Git/pgcenter/lib/utils/postgres.go:87 +0x4fc
github.com/lesovsky/pgcenter/lib/utils.CreateConn(0xb02f60, 0x0, 0x0, 0xb02f60)
        /home/lesovsky/Git/pgcenter/lib/utils/postgres.go:44 +0x3d
github.com/lesovsky/pgcenter/top.RunMain(0xb1ff08, 0x0, 0x0, 0x0, 0x0, 0x1538, 0x0, 0x0, 0x0, 0x0, ...)
        /home/lesovsky/Git/pgcenter/top/top.go:29 +0xbf
github.com/lesovsky/pgcenter/cmd/top.glob..func1(0xafea60, 0xb1ff08, 0x0, 0x0)
        /home/lesovsky/Git/pgcenter/cmd/top/top.go:23 +0x72
github.com/spf13/cobra.(*Command).execute(0xafea60, 0xb1ff08, 0x0, 0x0, 0xafea60, 0xb1ff08)
        /home/lesovsky/Git/go/pkg/mod/github.com/spf13/[email protected]/command.go:766 +0x2ae
github.com/spf13/cobra.(*Command).ExecuteC(0xafde80, 0x73f498, 0xc000057f88, 0xc00001c1d8)
        /home/lesovsky/Git/go/pkg/mod/github.com/spf13/[email protected]/command.go:852 +0x2c0
github.com/spf13/cobra.(*Command).Execute(...)
        /home/lesovsky/Git/go/pkg/mod/github.com/spf13/[email protected]/command.go:800
main.main()
        /home/lesovsky/Git/pgcenter/pgcenter.go:8 +0x2e

It is tried to set the variable "ESCDELAY" directly.
How do you think about to use the function "set_escdelay" instead?

Would you like to add more error handling for return values from functions like the following?

• fscanf ⇒ get_loadavg
• malloc ⇒ password_prompt

Hello! I don't now it's an issue or smth else, but this can be useful.

When I try to run pgcenter with AmazonRDS and touch "x" for switching to pg_stat_statements, I catched error: "ERROR: permission denied for relation pg_authid".

Trouble is that the "pg_authid" system table is not accessible even for the RDS master user because it stores information (passwords) that needs to be protected to maintain service security and stability.
But subset of "pg_authid" information is available in "pg_roles" but the latter table doesn't contain user passwords.

So I had to change some files from you source code.

sed -i 's/pg_authid/pg_roles/g' ./share/doc/pgcenter.1
sed -i 's/pg_authid/pg_roles/g' ./src/include/qstats.h
sed -i 's/pg_authid/pg_roles/g' ./src/include/queries.h

After make && make install and pg_stat_statements working fine.