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;