#	exclusive	inclusive	rows x	rows	loops	node
1.	664.741	2095.938	↑ 1.0	104585	1	→ Nested Loop Left Join (cost=0.00..348371.74 rows=104585 width=2843) (actual time=1.895..2095.938 rows=104585 loops=1)
2.	81.796	1431.197	↑ 1.0	104585	1	→ Nested Loop Left Join (cost=0.00..238762.59 rows=104585 width=2629) (actual time=0.152..1431.197 rows=104585 loops=1)
3.	39.377	1349.401	↑ 1.0	104585	1	→ Nested Loop Left Join (cost=0.00..209422.42 rows=104585 width=2415) (actual time=0.152..1349.401 rows=104585 loops=1)
4.	90.864	1100.854	↑ 1.0	104585	1	→ Nested Loop Left Join (cost=0.00..180082.26 rows=104585 width=2201) (actual time=0.151..1100.854 rows=104585 loops=1)
5.	50.696	1009.990	↑ 1.0	104585	1	→ Nested Loop Left Join (cost=0.00..150742.09 rows=104585 width=1987) (actual time=0.149..1009.990 rows=104585 loops=1)
6.	100.993	750.124	↑ 1.0	104585	1	→ Nested Loop Left Join (cost=0.00..121401.92 rows=104585 width=1129) (actual time=0.134..750.124 rows=104585 loops=1)
7.	117.222	649.131	↑ 1.0	104585	1	→ Nested Loop Left Join (cost=0.00..92097.76 rows=104585 width=1124) (actual time=0.131..649.131 rows=104585 loops=1)
8.	77.861	531.909	↑ 1.0	104585	1	→ Nested Loop Left Join (cost=0.00..62757.59 rows=104585 width=910) (actual time=0.093..531.909 rows=104585 loops=1)
9.	71.268	244.878	↑ 1.0	104585	1	→ Nested Loop Left Join (cost=0.00..33417.42 rows=104585 width=696) (actual time=0.059..244.878 rows=104585 loops=1)
10.	69.025	69.025	↑ 1.0	104585	1	→ Index Scan using log_entries_time_stamp_idx on log_entries l (cost=0.00..4113.26 rows=104585 width=692) (actual time=0.053..69.025 rows=104585 loops=1)
11.	104.585	104.585	↓ 0.0	0	104585	→ Index Scan using item_types_pkey on item_types it (cost=0.00..0.27 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=104585) Index Cond: (item_type_id = l.player_holding_item_type_id)
12.	209.170	209.170	↑ 1.0	1	104585	→ Index Scan using log_entry_types_pkey on log_entry_types let (cost=0.00..0.27 rows=1 width=222) (actual time=0.002..0.002 rows=1 loops=104585) Index Cond: (log_entry_type_id = l.log_entry_type_id)
13.	0.000	0.000	↓ 0.0	0	104585	→ Index Scan using users_pkey on users pu (cost=0.00..0.27 rows=1 width=222) (actual time=0.000..0.000 rows=0 loops=104585) Index Cond: (user_id = l.player_user_id)
14.	0.000	0.000	↓ 0.0	0	104585	→ Index Scan using block_types_pkey on block_types bt (cost=0.00..0.27 rows=1 width=13) (actual time=0.000..0.000 rows=0 loops=104585) Index Cond: (block_type_id = l.block_type_id)
15.	209.170	209.170	↑ 1.0	1	104585	→ Index Scan using worlds_pkey on worlds w (cost=0.00..0.27 rows=1 width=866) (actual time=0.001..0.002 rows=1 loops=104585) Index Cond: (world_id = l.world_id)
16.	0.000	0.000	↓ 0.0	0	104585	→ Index Scan using damage_types_pkey on damage_types dt (cost=0.00..0.27 rows=1 width=222) (actual time=0.000..0.000 rows=0 loops=104585) Index Cond: (damage_type_id = l.damage_type_id)
17.	209.170	209.170	↑ 1.0	1	104585	→ Index Scan using entity_types_pkey on entity_types vet (cost=0.00..0.27 rows=1 width=222) (actual time=0.001..0.002 rows=1 loops=104585) Index Cond: (entity_type_id = l.victim_entity_type_id)
18.	0.000	0.000	↓ 0.0	0	104585	→ Index Scan using users_pkey on users vu (cost=0.00..0.27 rows=1 width=222) (actual time=0.000..0.000 rows=0 loops=104585) Index Cond: (user_id = l.victim_user_id)
19.	0.000	0.000	↓ 0.0	0	104585	→ Index Scan using entity_types_pkey on entity_types eet (cost=0.00..0.27 rows=1 width=222) (actual time=0.000..0.000 rows=0 loops=104585) Index Cond: (entity_type_id = l.exploding_entity_type_id)

Null display is "{null}".
Timing is on.
                                                                                                   QUERY PLAN                                                                                                   
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Nested Loop Left Join  (cost=0.00..348371.74 rows=104585 width=2843) (actual time=1.895..2095.938 rows=104585 loops=1)
   ->  Nested Loop Left Join  (cost=0.00..238762.59 rows=104585 width=2629) (actual time=0.152..1431.197 rows=104585 loops=1)
         ->  Nested Loop Left Join  (cost=0.00..209422.42 rows=104585 width=2415) (actual time=0.152..1349.401 rows=104585 loops=1)
               ->  Nested Loop Left Join  (cost=0.00..180082.26 rows=104585 width=2201) (actual time=0.151..1100.854 rows=104585 loops=1)
                     ->  Nested Loop Left Join  (cost=0.00..150742.09 rows=104585 width=1987) (actual time=0.149..1009.990 rows=104585 loops=1)
                           ->  Nested Loop Left Join  (cost=0.00..121401.92 rows=104585 width=1129) (actual time=0.134..750.124 rows=104585 loops=1)
                                 ->  Nested Loop Left Join  (cost=0.00..92097.76 rows=104585 width=1124) (actual time=0.131..649.131 rows=104585 loops=1)
                                       ->  Nested Loop Left Join  (cost=0.00..62757.59 rows=104585 width=910) (actual time=0.093..531.909 rows=104585 loops=1)
                                             ->  Nested Loop Left Join  (cost=0.00..33417.42 rows=104585 width=696) (actual time=0.059..244.878 rows=104585 loops=1)
                                                   ->  Index Scan using log_entries_time_stamp_idx on log_entries l  (cost=0.00..4113.26 rows=104585 width=692) (actual time=0.053..69.025 rows=104585 loops=1)
                                                   ->  Index Scan using item_types_pkey on item_types it  (cost=0.00..0.27 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=104585)
                                                         Index Cond: (item_type_id = l.player_holding_item_type_id)
                                             ->  Index Scan using log_entry_types_pkey on log_entry_types let  (cost=0.00..0.27 rows=1 width=222) (actual time=0.002..0.002 rows=1 loops=104585)
                                                   Index Cond: (log_entry_type_id = l.log_entry_type_id)
                                       ->  Index Scan using users_pkey on users pu  (cost=0.00..0.27 rows=1 width=222) (actual time=0.000..0.000 rows=0 loops=104585)
                                             Index Cond: (user_id = l.player_user_id)
                                 ->  Index Scan using block_types_pkey on block_types bt  (cost=0.00..0.27 rows=1 width=13) (actual time=0.000..0.000 rows=0 loops=104585)
                                       Index Cond: (block_type_id = l.block_type_id)
                           ->  Index Scan using worlds_pkey on worlds w  (cost=0.00..0.27 rows=1 width=866) (actual time=0.001..0.002 rows=1 loops=104585)
                                 Index Cond: (world_id = l.world_id)
                     ->  Index Scan using damage_types_pkey on damage_types dt  (cost=0.00..0.27 rows=1 width=222) (actual time=0.000..0.000 rows=0 loops=104585)
                           Index Cond: (damage_type_id = l.damage_type_id)
               ->  Index Scan using entity_types_pkey on entity_types vet  (cost=0.00..0.27 rows=1 width=222) (actual time=0.001..0.002 rows=1 loops=104585)
                     Index Cond: (entity_type_id = l.victim_entity_type_id)
         ->  Index Scan using users_pkey on users vu  (cost=0.00..0.27 rows=1 width=222) (actual time=0.000..0.000 rows=0 loops=104585)
               Index Cond: (user_id = l.victim_user_id)
   ->  Index Scan using entity_types_pkey on entity_types eet  (cost=0.00..0.27 rows=1 width=222) (actual time=0.000..0.000 rows=0 loops=104585)
         Index Cond: (entity_type_id = l.exploding_entity_type_id)
 Total runtime: 2107.677 ms
(29 rows)

Time: 2119.836 ms

Per node type stats

node type	count	sum of times	% of query
Index Scan	10	801.120 ms	38.2 %
Nested Loop Left Join	9	1294.818 ms	61.8 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
block_types	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
damage_types	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
entity_types	2	209.170 ms	10.0 %
Index Scan	2	209.170 ms	100.0 %
item_types	1	104.585 ms	5.0 %
Index Scan	1	104.585 ms	100.0 %
log_entries	1	69.025 ms	3.3 %
Index Scan	1	69.025 ms	100.0 %
log_entry_types	1	209.170 ms	10.0 %
Index Scan	1	209.170 ms	100.0 %
users	2	0.000 ms	0.0 %
Index Scan	2	0.000 ms	0.0 %
worlds	1	209.170 ms	10.0 %
Index Scan	1	209.170 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 0yZ

Colorize:

Columns visibility:

Per node type stats

Per table stats