select sequence_number, type as aggregate, REPLACE(payload_type, 'com.machingclee.payment.command.CommandAndEvents$SubscriptionPlanOrder$', '') as event, encode(payload, 'escape') as payload, time_stamp, aggregate_identifier from domain_event_entry where encode(payload, 'escape')::jsonb->>'orderId' = '019136f9-794b-9a58-ba74-363facf9a814' order by time_stamp asc
Result: