Postgres 15

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table job(serialized_params)as values(jsonb '{"job_id": "9522f8a0-7eca-4682-a6e8-ef8771e5b86e", "locale": "en", "priority": null, "timezone": "Mountain Time (US & Canada)", "_good_job": {"id": "9522f8a0-7eca-4682-a6e8-ef8771e5b86e", "error": null, "labels": null, "cron_at": null, "batch_id": null, "cron_key": null, "priority": 0, "job_class": "ActionMailer::MailDeliveryJob", "lock_type": null, "locked_at": null, "created_at": "2026-05-12 08:02:41 -0600", "queue_name": "default", "updated_at": "2026-05-12 08:02:41 -0600", "error_event": null, "finished_at": null, "is_discrete": null, "locked_by_id": null, "performed_at": null, "scheduled_at": "2026-05-13 12:00:00 -0600", "active_job_id": "9522f8a0-7eca-4682-a6e8-ef8771e5b86e", "concurrency_key": null, "executions_count": null, "batch_callback_id": null, "retried_good_job_id": null}, "arguments": ["ReminderMailer", "inspection_created", "deliver_now", {"args": [], "params": {"event_id": 2480, "recipient": ["jesselasalle@mailer.com", "Jesse"], "_aj_symbol_keys": ["event_id", "recipient"]}, "_aj_ruby2_keywords": ["params", "args"]}], "job_class": "ActionMailer::MailDeliveryJob", "executions": 0, "queue_name": "default", "enqueued_at": "2026-05-12T14:02:41.494322527Z", "scheduled_at": "2026-05-13T18:00:00.000000000Z", "provider_job_id": null, "exception_executions": {}}');

SELECT 1

select serialized_params->'arguments'->>0
     , serialized_params
from job;

?column?
serialized_params

ReminderMailer
{"job_id": "9522f8a0-7eca-4682-a6e8-ef8771e5b86e", "locale": "en", "priority": null, "timezone": "Mountain Time (US & Canada)", "_good_job": {"id": "9522f8a0-7eca-4682-a6e8-ef8771e5b86e", "error": null, "labels": null, "cron_at": null, "batch_id": null, "cron_key": null, "priority": 0, "job_class": "ActionMailer::MailDeliveryJob", "lock_type": null, "locked_at": null, "created_at": "2026-05-12 08:02:41 -0600", "queue_name": "default", "updated_at": "2026-05-12 08:02:41 -0600", "error_event": null, "finished_at": null, "is_discrete": null, "locked_by_id": null, "performed_at": null, "scheduled_at": "2026-05-13 12:00:00 -0600", "active_job_id": "9522f8a0-7eca-4682-a6e8-ef8771e5b86e", "concurrency_key": null, "executions_count": null, "batch_callback_id": null, "retried_good_job_id": null}, "arguments": ["ReminderMailer", "inspection_created", "deliver_now", {"args": [], "params": {"event_id": 2480, "recipient": ["jesselasalle@mailer.com", "Jesse"], "_aj_symbol_keys": ["event_id", "recipient"]}, "_aj_ruby2_keywords": ["params", "args"]}], "job_class": "ActionMailer::MailDeliveryJob", "executions": 0, "queue_name": "default", "enqueued_at": "2026-05-12T14:02:41.494322527Z", "scheduled_at": "2026-05-13T18:00:00.000000000Z", "provider_job_id": null, "exception_executions": {}}

SELECT 1

select *
from job
where serialized_params->arguments->>0 = 'ReminderMailer';

ERROR:  column "arguments" does not exist
LINE 3: where serialized_params->arguments->>0 = 'ReminderMailer';
                                 ^

alter table job 
  add column arguments text default 'this_key_does_not_exist_in_serialized_params';

select *
from job
where serialized_params->arguments->>0 = 'ReminderMailer';

ALTER TABLE

serialized_params
arguments

SELECT 0