Skip to content

Instantly share code, notes, and snippets.

@hiroyuki-sato
Created February 15, 2021 11:24
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save hiroyuki-sato/41b6b33abc6884803ec252ff9a35d460 to your computer and use it in GitHub Desktop.
Save hiroyuki-sato/41b6b33abc6884803ec252ff9a35d460 to your computer and use it in GitHub Desktop.
digdag slow attempts check
select
p.name,
sa.attempt_name,
sa.created_at,
sa.finished_at,
(sa.finished_at - sa.created_at) as est
from
session_attempts sa,
projects p
where
p.id = sa.project_id
order by est desc
-- name | attempt_name | created_at | finished_at | est
-- ------+--------------------------------------+-------------------------------+-------------------------------+-----------------
-- hoge | | 2021-02-02 22:32:47.097649+09 | 2021-02-02 22:32:51.489824+09 | 00:00:04.392175
-- hoge | | 2021-02-02 22:33:02.602718+09 | 2021-02-02 22:33:06.550269+09 | 00:00:03.947551
-- hoge | | 2021-02-02 22:24:59.543474+09 | 2021-02-02 22:25:03.466639+09 | 00:00:03.923165
-- hoge | | 2021-02-02 22:33:26.784654+09 | 2021-02-02 22:33:30.704554+09 | 00:00:03.9199
-- hoge | 321aa530-1cba-410c-91af-cab4467bdb2b | 2021-02-02 22:29:31.612708+09 | 2021-02-02 22:29:35.480339+09 | 00:00:03.867631
-- hoge | 63d0dd3d-1fa1-4ab6-a811-ec932a423def | 2021-02-02 22:27:36.090758+09 | 2021-02-02 22:27:38.98716+09 | 00:00:02.896402
-- hoge | | 2021-02-02 22:33:45.042313+09 | 2021-02-02 22:33:47.871633+09 | 00:00:02.82932
-- hoge | 3d1d15df-920f-483a-9064-ad1783d66ecd | 2021-02-02 22:29:17.842574+09 | 2021-02-02 22:29:20.614553+09 | 00:00:02.771979
-- hoge | d5d2c787-10ab-49aa-bac4-74059f71c048 | 2021-02-02 22:28:00.954483+09 | 2021-02-02 22:28:03.707361+09 | 00:00:02.752878
-- hoge | | 2021-02-02 22:33:55.891713+09 | 2021-02-02 22:33:58.623253+09 | 00:00:02.73154
-- hoge | a12d23ca-cc57-41c9-8006-0b4ea01d58c5 | 2021-02-02 22:29:02.608034+09 | 2021-02-02 22:29:05.29565+09 | 00:00:02.687616
-- hoge | 0ded436f-7ba1-4c37-bfdc-b8275236fc21 | 2021-02-02 22:28:09.035379+09 | 2021-02-02 22:28:11.638604+09 | 00:00:02.603225
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment