pgsentinel is not collecting data

[prensgold]

Hi ,

Although I successfully finished the installation, the result of pg_active_session_history returns empty.
pgsentinel is not collecting any data.
What can I check to fix the problem?

Thanks
Sönmez

[prensgold]

i installed it on the patroni cluster and postgresql 15 installed database server.
Is there a problem with the database or cluster version?

airbyte=# \dx+ pgsentinel
Objects in extension "pgsentinel"
Object description

function get_parsedinfo(integer)
function pg_active_session_history()
function pg_stat_statements_history()
view pg_active_session_history
view pg_stat_statements_history
(5 rows)

airbyte=# select * from pg_available_extensions where name = 'pgsentinel';
name | default_version | installed_version | comment
------------+-----------------+-------------------+------------------------
pgsentinel | 1.0 | 1.0 | active session history
(1 row)

airbyte=# \dx
List of installed extensions
Name | Version | Schema | Description
--------------------+---------+------------+------------------------------------------------------------------------
oracle_fdw | 1.2 | public | foreign data wrapper for Oracle access
pgsentinel | 1.0 | public | active session history
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(6 rows)

airbyte=# \d 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 | | |
leader_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 | | |
backend_xmin | xid | | |
top_level_query | text | | |
query | text | | |
cmdtype | text | | |
queryid | bigint | | |
backend_type | text | | |
blockers | integer | | |
blockerpid | integer | | |
blocker_state | text | | |

airbyte=#

[bdrouvot]

Hi,

Might be similar to #43 ?

Bertrand