explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Svk6 : dan.sql

Settings
# exclusive inclusive rows x rows loops node
1. 15,746.342 15,747.250 ↑ 1.7 23 1

Nested Loop (cost=5,267.79..421,627.24 rows=40 width=192) (actual time=43.133..15,747.250 rows=23 loops=1)

2. 0.788 0.788 ↑ 1.0 40 1

Index Only Scan using sentry_project_pkey on sentry_project p (cost=0.47..97.65 rows=40 width=8) (actual time=0.157..0.788 rows=40 loops=1)

  • Index Cond: (id = ANY ('{1282303,247790,1303709,253185,1191279,253188,1376073,253186,1376077,253189,1216042,247729,1327974,253179,1216037,253190,1216041,253187,1376071,279725,1210568,1257779,1292624,1282302,245840,1206143,1196636,1187778,1210587,1210589,246021,1282224,246063,1296516,261908,246062,257979,1296514,1211066,1211067}'::bigint[]))
  • Heap Fetches: 17
3. 0.000 0.120 ↑ 1.0 1 40

Index Scan using sentry_release_pkey on sentry_release r (cost=5,267.32..10,538.23 rows=1 width=184) (actual time=0.003..0.003 rows=1 loops=40)

  • Index Cond: (id = (SubPlan 1))
4.          

SubPlan (forIndex Scan)

5. 0.080 15,746.160 ↑ 1.0 1 40

Limit (cost=5,266.88..5,266.89 rows=1 width=20) (actual time=393.654..393.654 rows=1 loops=40)

6. 431.960 15,746.080 ↑ 1,001.0 1 40

Sort (cost=5,266.88..5,269.39 rows=1,001 width=20) (actual time=393.652..393.652 rows=1 loops=40)

  • Sort Key: (COALESCE(lrr.date_released, lrr.date_added))
  • Sort Method: quicksort Memory: 25kB
7. 1,564.320 15,314.120 ↓ 55.2 55,207 40

Nested Loop (cost=1.00..5,261.88 rows=1,001 width=20) (actual time=0.188..382.853 rows=55,207 loops=40)

8. 2,708.360 2,708.360 ↓ 55.2 55,207 40

Index Only Scan using sentry_release_project_project_id_35add08b8e678ec7_uniq on sentry_release_project lrp (cost=0.56..814.41 rows=1,001 width=8) (actual time=0.171..67.709 rows=55,207 loops=40)

  • Index Cond: (project_id = p.id)
  • Heap Fetches: 766350
9. 11,041.440 11,041.440 ↑ 1.0 1 2,208,288

Index Scan using sentry_release_pkey on sentry_release lrr (cost=0.43..4.43 rows=1 width=20) (actual time=0.005..0.005 rows=1 loops=2,208,288)

  • Index Cond: (id = lrp.release_id)
10. 0.080 15,746.160 ↑ 1.0 1 40

Limit (cost=5,266.88..5,266.89 rows=1 width=20) (actual time=393.654..393.654 rows=1 loops=40)

11. 431.960 15,746.080 ↑ 1,001.0 1 40

Sort (cost=5,266.88..5,269.39 rows=1,001 width=20) (actual time=393.652..393.652 rows=1 loops=40)

  • Sort Key: (COALESCE(lrr.date_released, lrr.date_added))
  • Sort Method: quicksort Memory: 25kB
12. 1,564.320 15,314.120 ↓ 55.2 55,207 40

Nested Loop (cost=1.00..5,261.88 rows=1,001 width=20) (actual time=0.188..382.853 rows=55,207 loops=40)

13. 2,708.360 2,708.360 ↓ 55.2 55,207 40

Index Only Scan using sentry_release_project_project_id_35add08b8e678ec7_uniq on sentry_release_project lrp (cost=0.56..814.41 rows=1,001 width=8) (actual time=0.171..67.709 rows=55,207 loops=40)

  • Index Cond: (project_id = p.id)
  • Heap Fetches: 766350
14. 11,041.440 11,041.440 ↑ 1.0 1 2,208,288

Index Scan using sentry_release_pkey on sentry_release lrr (cost=0.43..4.43 rows=1 width=20) (actual time=0.005..0.005 rows=1 loops=2,208,288)

  • Index Cond: (id = lrp.release_id)