#	exclusive	inclusive	rows x	rows	loops	node
1.	1.466	2662.026	↓ 142.7	428	1	→ Nested Loop Left Join (cost=10000001523.32..3660000537256.79 rows=3 width=1692) (actual time=13.881..2662.026 rows=428 loops=1)
2.	622.239	623.732	↓ 180.0	180	1	→ Nested Loop (cost=10000001523.32..3660000528699.67 rows=1 width=1427) (actual time=6.687..623.732 rows=180 loops=1) Join Filter: (e.id = m.event_id)
3.	0.211	0.593	↑ 1.0	180	1	→ Bitmap Heap Scan on events e (cost=82.24..295.35 rows=183 width=767) (actual time=0.404..0.593 rows=180 loops=1) Recheck Cond: (id = ANY ('{60313,61093,60995,61147,60361,60890,61098,61096,61197,61144,60621,60309,60318,61152,60364,60465,61252,60887,61248,60625,61249,60467,60836,61094,60683,60784,59198,60314,60937,60892,60369,60785,59196,60786,60679,604
4.	0.382	0.382	↑ 1.0	180	1	→ Bitmap Index Scan on events_pkey (cost=0.00..82.20 rows=183 width=0) (actual time=0.382..0.382 rows=180 loops=1) Index Cond: (id = ANY ('{60313,61093,60995,61147,60361,60890,61098,61096,61197,61144,60621,60309,60318,61152,60364,60465,61252,60887,61248,60625,61249,60467,60836,61094,60683,60784,59198,60314,60937,60892,60369,60785,59196,60786,60679
5.	0.000	0.900	↑ 1.0	1	180	→ Index Scan using markets_pkey on markets m (cost=10000001441.08..10000001446.36 rows=1 width=664) (actual time=0.004..0.005 rows=1 loops=180) Index Cond: (m.id = (SubPlan 2))
6.						SubPlan (forIndex Scan)
7.	0.180	621.360	↑ 1.0	1	180	→ Limit (cost=10000001441.08..10000001441.08 rows=1 width=8) (actual time=3.452..3.452 rows=1 loops=180)
8.	1.620	621.180	↑ 11.0	1	180	→ Sort (cost=10000001441.08..10000001441.11 rows=11 width=8) (actual time=3.451..3.451 rows=1 loops=180) Sort Key: public.markets.index Sort Method: quicksort Memory: 25kB
9.	619.560	619.560	↑ 1.1	10	180	→ Seq Scan on markets (cost=10000000000.00..10000001441.02 rows=11 width=8) (actual time=2.224..3.442 rows=10 loops=180) Filter: (active AND displayed AND (event_id = $0))
10.	0.180	621.360	↑ 1.0	1	180	→ Limit (cost=10000001441.08..10000001441.08 rows=1 width=8) (actual time=3.452..3.452 rows=1 loops=180)
11.	1.620	621.180	↑ 11.0	1	180	→ Sort (cost=10000001441.08..10000001441.11 rows=11 width=8) (actual time=3.451..3.451 rows=1 loops=180) Sort Key: public.markets.index Sort Method: quicksort Memory: 25kB
12.	619.560	619.560	↑ 1.1	10	180	→ Seq Scan on markets (cost=10000000000.00..10000001441.02 rows=11 width=8) (actual time=2.224..3.442 rows=10 loops=180) Filter: (active AND displayed AND (event_id = $0))
13.	1.260	1.260	↑ 2.5	2	180	→ Index Scan using outcomes_market_id_active_index on outcomes o (cost=0.00..1.19 rows=5 width=269) (actual time=0.005..0.007 rows=2 loops=180) Index Cond: (o.market_id = m.id)
14.						SubPlan (forNested Loop Left Join)
15.	8.560	2035.568	↑ 1.0	1	428	→ Aggregate (cost=2851.94..2851.95 rows=1 width=4) (actual time=4.756..4.756 rows=1 loops=428)
16.	12.342	2027.008	↑ 1.1	52	428	→ Nested Loop (cost=0.00..2851.80 rows=55 width=4) (actual time=3.202..4.736 rows=52 loops=428)
17.	1998.760	1998.760	↓ 1.1	12	428	→ Index Scan using markets_pkey on markets (cost=0.00..2717.60 rows=11 width=4) (actual time=3.197..4.670 rows=12 loops=428) Filter: (active AND displayed AND (event_id = $0))
18.	15.906	15.906	↑ 1.2	4	5302	→ Index Scan using outcomes_market_id_active_index on outcomes (cost=0.00..12.14 rows=5 width=4) (actual time=0.002..0.003 rows=4 loops=5302) Index Cond: (outcomes.market_id = public.markets.id)

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Nested Loop Left Join  (cost=10000001523.32..3660000537256.79 rows=3 width=1692) (actual time=13.881..2662.026 rows=428 loops=1)
   ->  Nested Loop  (cost=10000001523.32..3660000528699.67 rows=1 width=1427) (actual time=6.687..623.732 rows=180 loops=1)
         Join Filter: (e.id = m.event_id)
         ->  Bitmap Heap Scan on events e  (cost=82.24..295.35 rows=183 width=767) (actual time=0.404..0.593 rows=180 loops=1)
               Recheck Cond: (id = ANY ('{60313,61093,60995,61147,60361,60890,61098,61096,61197,61144,60621,60309,60318,61152,60364,60465,61252,60887,61248,60625,61249,60467,60836,61094,60683,60784,59198,60314,60937,60892,60369,60785,59196,60786,60679,604
5,60942,60363,60674,60680,60989,60473,61045,61143,61308,60838,60735,61042,60682,61300,61302,61303,61256,60316,60470,61254,61044,60628,60941,61148,60782,60624,60987,60885,60622,60315,61150,61306,60629,60677,61247,61196,61204,61250,61199,60367,60886,6122,60
19,61198,59202,60996,60834,59194,60421,6121,60940,60991,60994,60317,61305,60888,61145,60681,60832,59199,61097,60573,60370,60365,60779,60414,60781,61048,61253,60780,60730,60310,6123,60833,61041,60889,61299,60787,60468,60472,60835,60733,60623,60570,60731,60
66,60420,60676,60839,60311,60572,60626,61202,60575,61365,61149,60678,61039,60469,60569,60935,61146,60571,61099,60891,61100,60362,60413,61307,61095,61151,60831,60990,60729,60992,60574,60732,59200,60938,60312,60675,61201,60939,59195,60630,60788,6120,6060944
60943,61200,60416,60466,60988,61301,61092,60578,60471,61304,60783,60837,59197,61195,60727,60577,60474,60728,60417,60884,61255,61203,61251,60422,60418,60368,59201,60993,60936,61091}'::integer[]))
               ->  Bitmap Index Scan on events_pkey  (cost=0.00..82.20 rows=183 width=0) (actual time=0.382..0.382 rows=180 loops=1)
                     Index Cond: (id = ANY ('{60313,61093,60995,61147,60361,60890,61098,61096,61197,61144,60621,60309,60318,61152,60364,60465,61252,60887,61248,60625,61249,60467,60836,61094,60683,60784,59198,60314,60937,60892,60369,60785,59196,60786,60679
60415,60942,60363,60674,60680,60989,60473,61045,61143,61308,60838,60735,61042,60682,61300,61302,61303,61256,60316,60470,61254,61044,60628,60941,61148,60782,60624,60987,60885,60622,60315,61150,61306,60629,60677,61247,61196,61204,61250,61199,60367,60886,612
,60419,61198,59202,60996,60834,59194,60421,6121,60940,60991,60994,60317,61305,60888,61145,60681,60832,59199,61097,60573,60370,60365,60779,60414,60781,61048,61253,60780,60730,60310,6123,60833,61041,60889,61299,60787,60468,60472,60835,60733,60623,60570,6073
,60366,60420,60676,60839,60311,60572,60626,61202,60575,61365,61149,60678,61039,60469,60569,60935,61146,60571,61099,60891,61100,60362,60413,61307,61095,61151,60831,60990,60729,60992,60574,60732,59200,60938,60312,60675,61201,60939,59195,60630,60788,6120,606
944,60943,61200,60416,60466,60988,61301,61092,60578,60471,61304,60783,60837,59197,61195,60727,60577,60474,60728,60417,60884,61255,61203,61251,60422,60418,60368,59201,60993,60936,61091}'::integer[]))
         ->  Index Scan using markets_pkey on markets m  (cost=10000001441.08..10000001446.36 rows=1 width=664) (actual time=0.004..0.005 rows=1 loops=180)
               Index Cond: (m.id = (SubPlan 2))
               SubPlan 2
                 ->  Limit  (cost=10000001441.08..10000001441.08 rows=1 width=8) (actual time=3.452..3.452 rows=1 loops=180)
                       ->  Sort  (cost=10000001441.08..10000001441.11 rows=11 width=8) (actual time=3.451..3.451 rows=1 loops=180)
                             Sort Key: public.markets.index
                             Sort Method:  quicksort  Memory: 25kB
                             ->  Seq Scan on markets  (cost=10000000000.00..10000001441.02 rows=11 width=8) (actual time=2.224..3.442 rows=10 loops=180)
                                   Filter: (active AND displayed AND (event_id = $0))
               SubPlan 2
                 ->  Limit  (cost=10000001441.08..10000001441.08 rows=1 width=8) (actual time=3.452..3.452 rows=1 loops=180)
                       ->  Sort  (cost=10000001441.08..10000001441.11 rows=11 width=8) (actual time=3.451..3.451 rows=1 loops=180)
                             Sort Key: public.markets.index
                             Sort Method:  quicksort  Memory: 25kB
                             ->  Seq Scan on markets  (cost=10000000000.00..10000001441.02 rows=11 width=8) (actual time=2.224..3.442 rows=10 loops=180)
                                   Filter: (active AND displayed AND (event_id = $0))
   ->  Index Scan using outcomes_market_id_active_index on outcomes o  (cost=0.00..1.19 rows=5 width=269) (actual time=0.005..0.007 rows=2 loops=180)
         Index Cond: (o.market_id = m.id)
   SubPlan 1
     ->  Aggregate  (cost=2851.94..2851.95 rows=1 width=4) (actual time=4.756..4.756 rows=1 loops=428)
           ->  Nested Loop  (cost=0.00..2851.80 rows=55 width=4) (actual time=3.202..4.736 rows=52 loops=428)
                 ->  Index Scan using markets_pkey on markets  (cost=0.00..2717.60 rows=11 width=4) (actual time=3.197..4.670 rows=12 loops=428)
                       Filter: (active AND displayed AND (event_id = $0))
                 ->  Index Scan using outcomes_market_id_active_index on outcomes  (cost=0.00..12.14 rows=5 width=4) (actual time=0.002..0.003 rows=4 loops=5302)
                       Index Cond: (outcomes.market_id = public.markets.id)
 Total runtime: 2662.364 ms
(33 rows)

Per node type stats

node type	count	sum of times	% of query
Aggregate	1	8.560 ms	0.3 %
Bitmap Heap Scan	1	0.211 ms	0.0 %
Bitmap Index Scan	1	0.382 ms	0.0 %
Index Scan	4	2015.926 ms	75.7 %
Limit	2	0.360 ms	0.0 %
Nested Loop	2	634.581 ms	23.8 %
Nested Loop Left Join	1	1.466 ms	0.1 %
Seq Scan	2	1239.120 ms	46.5 %
Sort	2	3.240 ms	0.1 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
events	1	0.211 ms	0.0 %
Bitmap Heap Scan	1	0.211 ms	100.0 %
markets	4	3237.880 ms	121.6 %
Index Scan	2	1998.760 ms	61.7 %
Seq Scan	2	1239.120 ms	38.3 %
outcomes	2	17.166 ms	0.6 %
Index Scan	2	17.166 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: wTt

Colorize:

Columns visibility:

Per node type stats

Per table stats