explain.depesz.com

PostgreSQL's explain analyze made readable

Result: V7eE

Settings
# exclusive inclusive rows x rows loops node
1. 50.407 7,122.362 ↓ 139.0 139 1

Unique (cost=119.84..119.84 rows=1 width=8) (actual time=6,945.553..7,122.362 rows=139 loops=1)

  • Buffers: shared hit=3869499 read=339183 dirtied=124
2. 305.306 7,071.955 ↓ 695,656.0 695,656 1

Sort (cost=119.84..119.84 rows=1 width=8) (actual time=6,945.553..7,071.955 rows=695,656 loops=1)

  • Sort Key: sentry_activity.group_id
  • Sort Method: quicksort Memory: 57185kB
  • Buffers: shared hit=3869499 read=339183 dirtied=124
3. 0.000 6,766.649 ↓ 695,656.0 695,656 1

Nested Loop (cost=1.56..119.83 rows=1 width=8) (actual time=0.381..6,766.649 rows=695,656 loops=1)

  • Buffers: shared hit=3869499 read=339183 dirtied=124
4. 105.034 4,057.589 ↓ 695,656.0 695,656 1

Nested Loop (cost=0.99..115.31 rows=1 width=8) (actual time=0.315..4,057.589 rows=695,656 loops=1)

  • Buffers: shared hit=351706 read=339183 dirtied=3
5. 0.213 0.213 ↓ 2.7 19 1

Index Scan using sentry_project_organization_id on sentry_project (cost=0.42..12.14 rows=7 width=8) (actual time=0.051..0.213 rows=19 loops=1)

  • Index Cond: (organization_id = 262117)
  • Buffers: shared hit=22
6. 3,952.342 3,952.342 ↓ 6,102.2 36,613 19

Index Scan using sentry_activity_weekly_report_jtcunning on sentry_activity (cost=0.56..14.68 rows=6 width=16) (actual time=0.017..208.018 rows=36,613 loops=19)

  • Index Cond: ((project_id = sentry_project.id) AND (user_id = 436965) AND (datetime >= '2020-03-16 00:00:00+00'::timestamp with time zone) AND (datetime < '2020-03-23 00:00:00+00'::timestamp with time zone))
  • Buffers: shared hit=351684 read=339183 dirtied=3
7. 2,782.624 2,782.624 ↑ 1.0 1 695,656

Index Scan using sentry_groupedmessage_pkey on sentry_groupedmessage (cost=0.57..4.51 rows=1 width=8) (actual time=0.003..0.004 rows=1 loops=695,656)

  • Index Cond: (id = sentry_activity.group_id)
  • Filter: (status = 1)
  • Buffers: shared hit=3517793 dirtied=121
Planning time : 1.217 ms
Execution time : 7,125.991 ms