[Redshift] テーブルの最終Analyze時刻その他を表示

gistfile1.sql

SELECT
  TO_CHAR(starttime + INTERVAL '9 hour', 'YYYY-MM-DD HH24:MI:SS') AS starttime
  ,TO_CHAR(endtime + INTERVAL '9 hour', 'YYYY-MM-DD HH24:MI:SS') AS endtime
  ,DATE_DIFF('sec', starttime, endtime) AS secs
  ,text
FROM
  svl_statementtext
WHERE
  sequence = 0
  AND xid IN (
    SELECT
      xid
    FROM
      svl_statementtext s
    WHERE
      s.text LIKE 'padb_fetch_sample%'
      AND s.text LIKE '%<table name>%'
    )
ORDER BY
  starttime
  ,endtime;