search

dbacvetkov / PASH-Viewer

PostgreSQL ASH Viewer (PASH Viewer) provides graphical view of active session history data within the PostgreSQL database
GNU General Public License v3.0
120 stars 18 forks source link

Is pash based on pgsentinel supported with pg 11 ? #4

Closed legrandlegrand closed 5 years ago

legrandlegrand commented 5 years ago

Hello, I'm not able to use pg_active_session_history from pgsentinel. (If I was using it, it would not appear as top process ;o)

PostgreSQL 11beta2 on x86_64-w64-mingw32, compiled by gcc.exe (x86_64-win32-seh-rev1, Built by MinGW-W64 project) 7.2.0, 64-bit.

postgres=# \d public.pg_active_session_history
                   View "public.pg_active_session_history"
      Column      |           Type           | Collation | Nullable | Default
------------------+--------------------------+-----------+----------+---------
 ash_time         | timestamp with time zone |           |          |
 datid            | oid                      |           |          |
 datname          | text                     |           |          |
 pid              | integer                  |           |          |
 usesysid         | oid                      |           |          |
 usename          | text                     |           |          |
 application_name | text                     |           |          |
 client_addr      | text                     |           |          |
 client_hostname  | text                     |           |          |
 client_port      | integer                  |           |          |
 backend_start    | timestamp with time zone |           |          |
 xact_start       | timestamp with time zone |           |          |
 query_start      | timestamp with time zone |           |          |
 state_change     | timestamp with time zone |           |          |
 wait_event_type  | text                     |           |          |
 wait_event       | text                     |           |          |
 state            | text                     |           |          |
 backend_xid      | xid                      |           |          |
legrandlegrand commented 5 years ago

It seems that pash is waiting for pg version in format X.Y, my version 11beta2 is not supported. see org.ash.conn.model.

I have forced version number to 10.0 in java code, and it works !!

dbacvetkov commented 5 years ago

Hello Legrand! Thank you for this issue. I think i fixed it in last commit. Not binary. Could you compile and check?

legrandlegrand commented 5 years ago

Hello, Yes I confirm that this issue is fixed ! Thank you for this useful tool ;o)

Regards PAscal