How to find the total number of sprints and identify the oldest closed sprints
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
サーバー*製品のサポートは 2024 年 2 月 15 日に終了しました。サーバー製品を利用している場合は、アトラシアンのサーバー製品のサポート終了のお知らせページにて移行オプションをご確認ください。
*Fisheye および Crucible は除く
目的
The total number of sprints, including closed sprints, in your instance can contribute to problems with the closedSprints() JQL function, and overall performance degradation related to slow sprint cache population.
ソリューション
If you experience problems, use the following queries to check the total number of sprints, and identify the oldest sprints so they can be deleted if no longer required.
Find the total number of sprints
Query tested on PostgreSQL and MySQL. You may need to adapt this query for other databases.
SELECT count(*)
FROM "AO_60DB71_SPRINT";SELECT count(*)
FROM AO_60DB71_SPRINT;Find the oldest sprints
Query tested on PostgreSQL and MySQL. You may need to adapt this query for other databases.
SELECT *, CAST(TO_TIMESTAMP("END_DATE"/1000) AS date) AS end_date_human_readable
FROM "AO_60DB71_SPRINT"
where "CLOSED" = true
order by "END_DATE";SELECT *
FROM AO_60DB71_SPRINT
where CLOSED = true
order by END_DATE