explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ySU

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 42.260 ↓ 0.0 0 1

Nested Loop (cost=449.21..956.06 rows=1 width=44) (actual time=42.260..42.260 rows=0 loops=1)

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

Merge Join (cost=448.65..951.47 rows=1 width=52) (actual time=42.260..42.260 rows=0 loops=1)

  • Merge Cond: (sentry_groupresolution.release_id = sentry_release_project.release_id)
3. 2.924 25.278 ↓ 19.3 5,104 1

Sort (cost=447.04..447.70 rows=265 width=44) (actual time=24.189..25.278 rows=5,104 loops=1)

  • Sort Key: sentry_groupresolution.release_id
  • Sort Method: quicksort Memory: 591kB
4. 16.294 22.354 ↓ 19.3 5,104 1

Bitmap Heap Scan on sentry_groupresolution (cost=21.62..436.37 rows=265 width=44) (actual time=6.303..22.354 rows=5,104 loops=1)

  • Recheck Cond: (((status = 0) AND (type = 1)) OR ((status = 0) AND (type IS NULL)))
  • Filter: (release_id <> 82338389)
  • Heap Blocks: exact=1486
5. 0.001 6.060 ↓ 0.0 0 1

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

6. 6.047 6.047 ↓ 20.1 5,307 1

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

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

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

  • Index Cond: ((status = 0) AND (type IS NULL))
8. 16.006 16.006 ↓ 2.2 2,146 1

Index Only Scan using sentry_release_project_project_id_35add08b8e678ec7_uniq on sentry_release_project (cost=0.56..500.70 rows=963 width=8) (actual time=1.261..16.006 rows=2,146 loops=1)

  • Index Cond: (project_id = 1198904)
  • Heap Fetches: 696
9. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (id = sentry_release_project.release_id)
  • Filter: (date_added < '2019-10-08 01:15:46.126772+00'::timestamp with time zone)
Planning time : 3.651 ms
Execution time : 42.496 ms