explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LAYw

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

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

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

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

  • Merge Cond: (sentry_groupresolution.release_id = sentry_release_project.release_id)
3. 2.993 27.192 ↓ 19.3 5,112 1

Sort (cost=447.04..447.70 rows=265 width=44) (actual time=26.312..27.192 rows=5,112 loops=1)

  • Sort Key: sentry_groupresolution.release_id
  • Sort Method: quicksort Memory: 593kB
4. 18.065 24.199 ↓ 19.3 5,124 1

Bitmap Heap Scan on sentry_groupresolution (cost=21.62..436.37 rows=265 width=44) (actual time=6.390..24.199 rows=5,124 loops=1)

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

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

6. 6.115 6.115 ↓ 21.9 5,784 1

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

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

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

  • Index Cond: ((status = 0) AND (type IS NULL))
8. 11.001 11.001 ↓ 2.7 2,628 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=0.203..11.001 rows=2,628 loops=1)

  • Index Cond: (project_id = 1310544)
  • Heap Fetches: 732
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 08:02:27+00'::timestamp with time zone)
Planning time : 3.961 ms
Execution time : 39.327 ms