explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cGYX

Settings
# exclusive inclusive rows x rows loops node
1. 7.991 8,730.238 ↓ 335.9 67,184 1

Unique (cost=111,934.96..111,939.92 rows=200 width=110) (actual time=8,712.937..8,730.238 rows=67,184 loops=1)

2. 44.917 8,722.247 ↓ 68.5 67,973 1

Sort (cost=111,934.96..111,937.44 rows=992 width=110) (actual time=8,712.934..8,722.247 rows=67,973 loops=1)

  • Sort Key: omaha_request.userid COLLATE "C", omaha_request.created DESC
  • Sort Method: quicksort Memory: 8378kB
3. 30.552 8,677.330 ↓ 68.5 67,973 1

Nested Loop (cost=544.18..111,885.59 rows=992 width=110) (actual time=280.453..8,677.330 rows=67,973 loops=1)

4. 1,112.429 8,510.832 ↓ 68.5 67,973 1

Nested Loop (cost=543.63..107,792.63 rows=992 width=8) (actual time=280.444..8,510.832 rows=67,973 loops=1)

5. 781.230 4,460.499 ↓ 199.4 2,937,904 1

Nested Loop (cost=543.20..98,842.40 rows=14,737 width=12) (actual time=280.429..4,460.499 rows=2,937,904 loops=1)

6. 498.422 741.365 ↓ 199.4 2,937,904 1

Bitmap Heap Scan on omaha_apprequest u0 (cost=542.77..44,092.22 rows=14,737 width=8) (actual time=280.408..741.365 rows=2,937,904 loops=1)

  • Recheck Cond: ((appid)::text = '{98DA7DF2-4E3E-4744-9DE6-EC931886ABAB}'::text)
  • Heap Blocks: exact=151300
7. 242.943 242.943 ↓ 199.4 2,937,904 1

Bitmap Index Scan on omaha_apprequest_7aa64062 (cost=0.00..539.08 rows=14,737 width=0) (actual time=242.943..242.943 rows=2,937,904 loops=1)

  • Index Cond: ((appid)::text = '{98DA7DF2-4E3E-4744-9DE6-EC931886ABAB}'::text)
8. 2,937.904 2,937.904 ↑ 1.0 1 2,937,904

Index Only Scan using omaha_apprequest_events_apprequest_id_fe1d45b7_uniq on omaha_apprequest_events u1 (cost=0.43..3.71 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=2,937,904)

  • Index Cond: (apprequest_id = u0.id)
  • Heap Fetches: 0
9. 2,937.904 2,937.904 ↓ 0.0 0 2,937,904

Index Scan using omaha_event_pkey on omaha_event u2 (cost=0.43..0.60 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=2,937,904)

  • Index Cond: (id = u1.event_id)
  • Filter: ((eventtype = ANY ('{2,3}'::integer[])) AND (eventresult = 1))
  • Rows Removed by Filter: 1
10. 135.946 135.946 ↑ 1.0 1 67,973

Index Only Scan using omaha_request_version_4 on omaha_request (cost=0.56..4.12 rows=1 width=110) (actual time=0.002..0.002 rows=1 loops=67,973)

  • Index Cond: (id = u0.request_id)
  • Heap Fetches: 0