> Do we have similar commands in pgaudit , which captures only failed DML and not the successful ones.
Not in pgaudit. Just in the standard PG config, in the logging section, you can choose if/how errors are logged. Not at the granularity of your example, but you can log all errors, then in your monitoring filter and classify them.
