I was using the pg_activity monitoring tool, which I find quite awesome.
Table "audits.audits"
Column | Type | Modifiers
-------------------+-----------------------------+-----------------------------------------------------------------------
id | bigint | not null default nextval('audits.audits_id_seq'::regclass)
auditable_type_id | oid | not null
auditable_id | integer |
operation | audits.operation | not null
old_data | jsonb |
new_data | jsonb |
user_id | integer | default (NULLIF(session.get_var('user_id'::text), ''::text))::integer
ip | inet | default (NULLIF(session.get_var('ip'::text), ''::text))::inet
service_name | character varying(100) | default NULLIF(session.get_var('service'::text), ''::text)
service_action | text | default NULLIF(session.get_var('action'::text), ''::text)
created_at | timestamp without time zone | not null default clock_timestamp()
Indexes:
"audits_pkey" PRIMARY KEY, btree (id)
"index_audits_on_auditable_type_id_and_auditable_id" btree (auditable_type_id, auditable_id)
"index_audits_on_created_at" btree (created_at)
