PgHero

Live Queries

1 query

Pid Duration State
3327883 00:02:41 active
pg_cron upadmin
UPDATE consignment_imports
SET year  = EXTRACT(YEAR FROM created_date),
    month = EXTRACT(MONTH FROM created_date)
WHERE year is null
  and source = 'scurri'
  and id > 120658891;

You may need to restart your app servers afterwards.