explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vf9

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 221.589 ↓ 0.0 0 1

Nested Loop (cost=135.45..669.87 rows=1 width=44) (actual time=221.589..221.589 rows=0 loops=1)

  • Join Filter: (sentry_groupresolution.release_id = sentry_release.id)
2. 0.819 221.588 ↓ 0.0 0 1

Hash Join (cost=134.89..669.23 rows=1 width=52) (actual time=221.588..221.588 rows=0 loops=1)

  • Hash Cond: (sentry_groupresolution.release_id = sentry_release_project.release_id)
3. 4.908 6.557 ↓ 19.5 5,157 1

Bitmap Heap Scan on sentry_groupresolution (cost=21.62..436.37 rows=265 width=44) (actual time=1.858..6.557 rows=5,157 loops=1)

  • Recheck Cond: (((status = 0) AND (type = 1)) OR ((status = 0) AND (type IS NULL)))
  • Filter: (release_id <> 81950264)
  • Heap Blocks: exact=1479
4. 0.003 1.649 ↓ 0.0 0 1

BitmapOr (cost=21.62..21.62 rows=265 width=0) (actual time=1.649..1.649 rows=0 loops=1)

5. 1.637 1.637 ↓ 19.7 5,197 1

Bitmap Index Scan on idx_sentry_groupresolution_pending (cost=0.00..19.06 rows=264 width=0) (actual time=1.637..1.637 rows=5,197 loops=1)

  • Index Cond: ((status = 0) AND (type = 1))
6. 0.009 0.009 ↓ 3.0 3 1

Bitmap Index Scan on idx_sentry_groupresolution_pending (cost=0.00..2.43 rows=1 width=0) (actual time=0.009..0.009 rows=3 loops=1)

  • Index Cond: ((status = 0) AND (type IS NULL))
7. 36.125 214.212 ↓ 73.9 187,364 1

Hash (cost=81.57..81.57 rows=2,536 width=8) (actual time=214.211..214.212 rows=187,364 loops=1)

  • Buckets: 262144 (originally 4096) Batches: 1 (originally 1) Memory Usage: 9367kB
8. 37.613 178.087 ↓ 73.9 187,364 1

Nested Loop (cost=9.95..81.57 rows=2,536 width=8) (actual time=0.071..178.087 rows=187,364 loops=1)

9. 0.001 0.041 ↑ 2.0 1 1

Unique (cost=9.51..9.52 rows=2 width=16) (actual time=0.040..0.041 rows=1 loops=1)

10. 0.006 0.040 ↑ 2.0 1 1

Sort (cost=9.51..9.52 rows=2 width=16) (actual time=0.039..0.040 rows=1 loops=1)

  • Sort Key: u0.id
  • Sort Method: quicksort Memory: 25kB
11. 0.003 0.034 ↑ 2.0 1 1

Nested Loop (cost=0.99..9.50 rows=2 width=16) (actual time=0.032..0.034 rows=1 loops=1)

12. 0.018 0.018 ↑ 2.0 1 1

Index Only Scan using sentry_release_project_release_id_project_id on sentry_release_project u1 (cost=0.56..4.60 rows=2 width=8) (actual time=0.018..0.018 rows=1 loops=1)

  • Index Cond: (release_id = 81950264)
  • Heap Fetches: 1
13. 0.013 0.013 ↑ 1.0 1 1

Index Only Scan using sentry_project_pkey on sentry_project u0 (cost=0.42..2.44 rows=1 width=8) (actual time=0.012..0.013 rows=1 loops=1)

  • Index Cond: (id = u1.project_id)
  • Heap Fetches: 1
14. 140.433 140.433 ↓ 147.8 187,364 1

Index Scan using sentry_release_project_project_id on sentry_release_project (cost=0.44..23.34 rows=1,268 width=16) (actual time=0.030..140.433 rows=187,364 loops=1)

  • Index Cond: (project_id = u0.id)
15. 0.000 0.000 ↓ 0.0 0

Index Scan using sentry_release_id_organization_id on sentry_release (cost=0.56..0.62 rows=1 width=4) (never executed)

  • Index Cond: (id = sentry_release_project.release_id)
  • Filter: (date_added < '2019-10-05 00:02:04.369+00'::timestamp with time zone)
Planning time : 1.739 ms
Execution time : 221.762 ms