public inbox for [email protected]
help / color / mirror / Atom feedFrom: KK CHN <[email protected]>
To: pgsql-general <[email protected]>
Subject: Long Running query and trace potential issues
Date: Fri, 28 Feb 2025 17:21:50 +0530
Message-ID: <CAKgGyB_a=D7fKf6Jh-2a9=jArKECODHn_xGRb=w6suXhS+SL-A@mail.gmail.com> (raw)
List
postgres=# SELECT PID, now() - pg_stat_activity.query_start AS duration,
query, state FROM pg_stat_activity WHERE (now() - pg
_stat_activity.query_start) > interval '5 minutes' AND state = 'active';
pid | duration | query
| state
------+-------------------------+------------------------------------------+--------
3957 | 17 days 12:00:30.782583 | START_REPLICATION B5/EE000000 TIMELINE 1
| active
(1 row)
postgres=#
Postgres 16 and pgbackrest 2.52.1 on RHEL 9.4
Is this a potential issue ? It has been running for 17 days . ( I have
configured WAL replication to a standby server and pgbackrest to a remote
server ) is this normal running 17 days START_REPLICATION B5/EE000000
TIMELINE1 active ?
Any hints to further trace where the query is executing, what it's trying
to perform, how to optimize if this is not normal ? Any guidance is much
appreciated..
Thank you,
Krishane
view thread (2+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: Long Running query and trace potential issues
In-Reply-To: <CAKgGyB_a=D7fKf6Jh-2a9=jArKECODHn_xGRb=w6suXhS+SL-A@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox