explain.depesz.com

PostgreSQL's explain analyze made readable

Result: p7P

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

Unique (cost=114,551.15..114,556.11 rows=200 width=118) (actual time=8,680.572..8,698.385 rows=67,184 loops=1)

2. 47.451 8,690.894 ↓ 68.5 67,973 1

Sort (cost=114,551.15..114,553.63 rows=992 width=118) (actual time=8,680.571..8,690.894 rows=67,973 loops=1)

  • Sort Key: r.userid COLLATE "C", r.created DESC
  • Sort Method: quicksort Memory: 12621kB
3. 13.223 8,643.443 ↓ 68.5 67,973 1

Nested Loop (cost=544.45..114,501.78 rows=992 width=118) (actual time=272.130..8,643.443 rows=67,973 loops=1)

4. 31.324 8,562.247 ↓ 68.5 67,973 1

Nested Loop (cost=544.18..114,204.17 rows=992 width=118) (actual time=272.125..8,562.247 rows=67,973 loops=1)

5. 1,785.278 8,394.977 ↓ 68.5 67,973 1

Nested Loop Semi Join (cost=543.63..110,111.22 rows=992 width=8) (actual time=272.117..8,394.977 rows=67,973 loops=1)

6. 498.322 733.891 ↓ 199.4 2,937,904 1

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

  • Recheck Cond: ((appid)::text = '{98DA7DF2-4E3E-4744-9DE6-EC931886ABAB}'::text)
  • Heap Blocks: exact=151300
7. 235.569 235.569 ↓ 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=235.569..235.569 rows=2,937,904 loops=1)

  • Index Cond: ((appid)::text = '{98DA7DF2-4E3E-4744-9DE6-EC931886ABAB}'::text)
8. 0.000 5,875.808 ↓ 0.0 0 2,937,904

Nested Loop Semi Join (cost=0.86..4.47 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=2,937,904)

9. 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 ae (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 = ar.id)
  • Heap Fetches: 0
10. 2,937.904 2,937.904 ↓ 0.0 0 2,937,904

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

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

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

  • Index Cond: (id = ar.request_id)
  • Heap Fetches: 0
12. 67.973 67.973 ↑ 1.0 1 67,973

Index Only Scan using omaha_os_pkey on omaha_os os (cost=0.27..0.29 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=67,973)

  • Index Cond: (id = r.os_id)
  • Heap Fetches: 67973