explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Uecc

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 5.321 405.255 ↓ 1.2 5,210 1

Hash Join (cost=23,386.15..27,357.28 rows=4,202 width=163) (actual time=375.680..405.255 rows=5,210 loops=1)

  • Hash Cond: (ek.keyword_id = k.id)
2. 2.215 382.699 ↓ 1.2 5,210 1

Nested Loop (cost=22,674.55..26,566.89 rows=4,202 width=129) (actual time=358.431..382.699 rows=5,210 loops=1)

3. 0.958 374.904 ↓ 1.4 1,116 1

Hash Left Join (cost=22,674.55..25,036.08 rows=787 width=125) (actual time=358.420..374.904 rows=1,116 loops=1)

  • Hash Cond: (e.id = e.id)
4. 15.732 15.732 ↓ 1.4 1,116 1

Seq Scan on events e (cost=0.00..2,281.75 rows=787 width=121) (actual time=0.188..15.732 rows=1,116 loops=1)

  • Filter: display
5. 0.302 358.214 ↓ 1.3 1,028 1

Hash (cost=22,664.72..22,664.72 rows=787 width=4) (actual time=358.214..358.214 rows=1,028 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
6. 16.489 357.912 ↓ 1.3 1,028 1

HashAggregate (cost=22,648.98..22,656.85 rows=787 width=4) (actual time=357.628..357.912 rows=1,028 loops=1)

7. 34.257 341.423 ↓ 1.8 44,843 1

Nested Loop (cost=0.00..22,586.18 rows=25,120 width=4) (actual time=0.198..341.423 rows=44,843 loops=1)

8. 19.860 122.849 ↓ 2.0 61,439 1

Nested Loop (cost=0.00..11,754.45 rows=30,776 width=8) (actual time=0.189..122.849 rows=61,439 loops=1)

9. 4.466 32.089 ↓ 1.6 14,180 1

Nested Loop (cost=0.00..4,926.33 rows=8,830 width=8) (actual time=0.180..32.089 rows=14,180 loops=1)

10. 16.463 16.463 ↓ 1.4 1,116 1

Seq Scan on events e (cost=0.00..2,281.75 rows=787 width=4) (actual time=0.166..16.463 rows=1,116 loops=1)

  • Filter: display
11. 11.160 11.160 ↑ 1.7 13 1,116

Index Scan using markets_event_id_index on markets m (cost=0.00..3.09 rows=22 width=8) (actual time=0.004..0.010 rows=13 loops=1,116)

  • Index Cond: (event_id = e.id)
12. 70.900 70.900 ↑ 3.2 4 14,180

Index Scan using outcomes_market_id_index on outcomes o (cost=0.00..0.61 rows=13 width=8) (actual time=0.003..0.005 rows=4 loops=14,180)

  • Index Cond: (market_id = m.id)
13. 184.317 184.317 ↑ 1.0 1 61,439

Index Scan using prices_outcome_id_key on prices p (cost=0.00..0.34 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=61,439)

  • Index Cond: (outcome_id = o.id)
14. 5.580 5.580 ↑ 1.0 5 1,116

Index Scan using events_keywords_event_id_idx on events_keywords ek (cost=0.00..1.88 rows=5 width=8) (actual time=0.003..0.005 rows=5 loops=1,116)

  • Index Cond: (event_id = e.id)
15. 10.869 17.235 ↑ 1.0 20,934 1

Hash (cost=439.60..439.60 rows=21,760 width=42) (actual time=17.235..17.235 rows=20,934 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 1577kB
16. 6.366 6.366 ↑ 1.0 20,934 1

Seq Scan on keywords k (cost=0.00..439.60 rows=21,760 width=42) (actual time=0.008..6.366 rows=20,934 loops=1)