| From: | Nikhil Ingale <niks(dot)bgm(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | idle in transaction |
| Date: | 2023-11-28 04:00:20 |
| Message-ID: | CALXkTpxX+P1qB+FPc-bHYEF2ZkHWqdBeTh4kUyfOkeJwggaZvQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi All,
Can somebody help me to understand the below given idle in transaction?
SELECT * FROM pg_stat_activity where pid = 2161513;
-[ RECORD 1
]----+-----------------------------------------------------------------------------------
datid | 37490141
datname | prod
pid | 2161513
leader_pid |
usesysid | 37490157
usename | admin
application_name |
client_addr | ::1
client_hostname |
client_port | 16788
backend_start | 2023-11-27 20:24:20.20062+05:30
xact_start | 2023-11-27 20:24:33.694904+05:30
query_start | 2023-11-28 09:25:57.666297+05:30
state_change | 2023-11-28 09:25:57.666336+05:30
wait_event_type | Client
wait_event | ClientRead
state | idle in transaction
backend_xid |
backend_xmin |
query | SAVEPOINT _per_query_svp_;DEALLOCATE
"_PLAN0x7fdd58004550";RELEASE _per_query_svp_
backend_type | client backend
I would like to understand the following query found in the
pg_stat_activity.
I see this particular process always active but not doing anything in the
BDR network. How do I find out what query is it running?
SAVEPOINT _per_query_svp_;DEALLOCATE "_PLAN0x7fdd58004550";RELEASE
_per_query_svp_
Regards,
Nikhil Ingale
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2023-11-28 04:07:36 | Re: idle in transaction |
| Previous Message | Tom Lane | 2023-11-28 00:45:45 | Re: pg_dump -Are statistics saved? |