# Pgaudit: How to log command status

**URL:** <https://forums.percona.com/t/pgaudit-how-to-log-command-status/39323>\
**Category:** PostgreSQL\
**Created:** [September 10, 2025, 8:04am UTC](https://forums.percona.com/t/pgaudit-how-to-log-command-status/39323 "2025-09-10T08:04:29Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![fborden](https://avatars.discourse-cdn.com/v4/letter/f/fbc32d/32.png) [@fborden](https://forums.percona.com/u/fborden)\
**Post date:** [September 10, 2025, 8:04am UTC](https://forums.percona.com/t/pgaudit-how-to-log-command-status/39323/1 "2025-09-10T08:04:29Z")

</div>

Hello all,

looking at the pgaudit logs I can not see the event status of DDL or DML.  
All rows are “state: INPROGRESS”

e.g. the following two rows in the audit trail:

2025-09-09 14:20:21.010 GMT,“postgres”,“hrprod”,84139,“[local]”,68c03794.148ab,11,“INSERT”,2025-09-09 14:20:04 GMT,1/4,768,DEBUG,00000,“CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 768/1/0 (used)”,“insert into dummy values (1);”,“psql”,“client backend”,0

2025-09-09 14:51:08.444 GMT,“postgres”,“hrprod”,86684,“[local]”,68c03d25.1529c,21,“CREATE TABLE”,2025-09-09 14:43:49 GMT,2/10,772,DEBUG,00000,“CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 772/1/1”,"CREATE TABLE ““DEMO\_HR\_ROLES””

( ““USERID”” VARCHAR(100),

```
    ""ROLEID"" VARCHAR(100)

```

) ;",“psql”,“client backend”,0

What am I missing?

Thanks,

Frank