Re: pgadmin server-status does not display

Hi dave,

INFO   : 18:54:15: Running a DEBUG build.

and that is only output if the build was done with the WXDEBUG flag set. It shouldn't make any difference here, but isn't the norm

Really strange - but that should not be the problem.

in the log i can't see any result for queries except fetching the pg_log-files. but i'm not 100% shure where to look at.

This query, for example, is used to populate the Activity pane:

SELECT p.pid AS pid, application_name, datname, usename,

CASE WHEN client_port=-1 THEN 'local pipe' WHEN length(client_hostname)>0 THEN client_hostname||':'||client_port ELSE textin(inet_out(client_addr))||':'||client_port END AS client,

date_trunc('second', backend_start) AS backend_start, CASE WHEN state='active' THEN date_trunc('second', query_start)::text ELSE '' END AS query_start,

date_trunc('second', xact_start) AS xact_start, state, date_trunc('second', state_change) AS state_change, backend_xid::text, backend_xmin::text, (SELECT min(l1.pid) FROM pg_locks l1 WHERE GRANTED AND (relation IN (SELECT relation FROM pg_locks l2 WHERE l2.pid=p.pid AND NOT granted) OR transactionid IN (SELECT transactionid FROM pg_locks l3 WHERE l3.pid=p.pid AND NOT granted))) AS blockedby,

query AS query,

CASE WHEN query_start IS NULL OR state<>'active' THEN false ELSE query_start < now() - '10 seconds'::interval END AS slowquery

FROM pg_stat_activity p ORDER BY 1 ASC

If I'm honest, I'm pretty stumped now. I can't see any reason why the data wouldn't be displayed. Anyone else?

Tried the query using psql - and of course it's returning data.

May be you should add an info about returned data in the debug log? something like "77 lines received"

First i'll use a network sniffer (wireshark) to see the answer sent to the client.
Next i'll install pgadmin4 from source (no big problem for me but using packets for such a tool is much easier)

thank's for your patience
Walter