SELECT
d.refobjid::regclass as table_name,
a.attname as column_name
FROM pg_depend d
JOIN pg_class s ON d.objid = s.oid
JOIN pg_attribute a ON (d.refobjid = a.attrelid AND d.refobjsubid = a.attnum)
WHERE s.relname = 'investor_order_idfa_id_seq';
SELECT
MAX(id) AS table_max_id,
currval('investor_order_idfa_id_seq') AS sequence_current,
MAX(id) - currval('investor_order_idfa_id_seq') AS gap
FROM investor_order_idfa;