Query: ssl_additional_certificate_record

select
  c ->> 'common_name' as "Common Name",
  TO_CHAR((c ->> 'not_before')::timestamp, 'Dy, DD Mon YYYY HH24:MI:SS TZ') as "Valid From",
  TO_CHAR((c ->> 'not_after')::timestamp, 'Dy, DD Mon YYYY HH24:MI:SS TZ') || ' (expires in ' || date_trunc('day', age((c ->> 'not_after')::timestamp, now())) || ')' as "Valid Until",
  c ->> 'public_key_algorithm' || ' ' || (c ->> 'public_key_length')::text || ' bits' as "Key",
  c ->> 'issuer_name' as "Issuer",
  c ->> 'signature_algorithm' as "Signature Algorithm"
from
  net_certificate,
  jsonb_array_elements(chain) as c
where
  domain = $1
order by domain;