---

SELECT
    id,
    name,
    is_active
FROM report.conf_scheduler_sfr
WHERE is_active = true
ORDER BY id;



SELECT
    pid,
    application_name,
    state,
    query_start,
    clock_timestamp() - query_start AS duration,
    wait_event_type,
    wait_event,
    pg_blocking_pids(pid) AS blocking_pids,
    query
FROM pg_stat_activity
WHERE datname = current_database()
  AND pid <> pg_backend_pid()
  AND state <> 'idle'
  AND query ILIKE '%f3_create_sfr_register%'
ORDER BY query_start;