explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 0yZ

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 664.741 2,095.938 ↑ 1.0 104,585 1

Nested Loop Left Join (cost=0.00..348,371.74 rows=104,585 width=2,843) (actual time=1.895..2,095.938 rows=104,585 loops=1)

2. 81.796 1,431.197 ↑ 1.0 104,585 1

Nested Loop Left Join (cost=0.00..238,762.59 rows=104,585 width=2,629) (actual time=0.152..1,431.197 rows=104,585 loops=1)

3. 39.377 1,349.401 ↑ 1.0 104,585 1

Nested Loop Left Join (cost=0.00..209,422.42 rows=104,585 width=2,415) (actual time=0.152..1,349.401 rows=104,585 loops=1)

4. 90.864 1,100.854 ↑ 1.0 104,585 1

Nested Loop Left Join (cost=0.00..180,082.26 rows=104,585 width=2,201) (actual time=0.151..1,100.854 rows=104,585 loops=1)

5. 50.696 1,009.990 ↑ 1.0 104,585 1

Nested Loop Left Join (cost=0.00..150,742.09 rows=104,585 width=1,987) (actual time=0.149..1,009.990 rows=104,585 loops=1)

6. 100.993 750.124 ↑ 1.0 104,585 1

Nested Loop Left Join (cost=0.00..121,401.92 rows=104,585 width=1,129) (actual time=0.134..750.124 rows=104,585 loops=1)

7. 117.222 649.131 ↑ 1.0 104,585 1

Nested Loop Left Join (cost=0.00..92,097.76 rows=104,585 width=1,124) (actual time=0.131..649.131 rows=104,585 loops=1)

8. 77.861 531.909 ↑ 1.0 104,585 1

Nested Loop Left Join (cost=0.00..62,757.59 rows=104,585 width=910) (actual time=0.093..531.909 rows=104,585 loops=1)

9. 71.268 244.878 ↑ 1.0 104,585 1

Nested Loop Left Join (cost=0.00..33,417.42 rows=104,585 width=696) (actual time=0.059..244.878 rows=104,585 loops=1)

10. 69.025 69.025 ↑ 1.0 104,585 1

Index Scan using log_entries_time_stamp_idx on log_entries l (cost=0.00..4,113.26 rows=104,585 width=692) (actual time=0.053..69.025 rows=104,585 loops=1)

11. 104.585 104.585 ↓ 0.0 0 104,585

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=104,585)

  • Index Cond: (item_type_id = l.player_holding_item_type_id)
12. 209.170 209.170 ↑ 1.0 1 104,585

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=104,585)

  • Index Cond: (log_entry_type_id = l.log_entry_type_id)
13. 0.000 0.000 ↓ 0.0 0 104,585

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=104,585)

  • Index Cond: (user_id = l.player_user_id)
14. 0.000 0.000 ↓ 0.0 0 104,585

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=104,585)

  • Index Cond: (block_type_id = l.block_type_id)
15. 209.170 209.170 ↑ 1.0 1 104,585

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=104,585)

  • Index Cond: (world_id = l.world_id)
16. 0.000 0.000 ↓ 0.0 0 104,585

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=104,585)

  • Index Cond: (damage_type_id = l.damage_type_id)
17. 209.170 209.170 ↑ 1.0 1 104,585

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=104,585)

  • Index Cond: (entity_type_id = l.victim_entity_type_id)
18. 0.000 0.000 ↓ 0.0 0 104,585

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=104,585)

  • Index Cond: (user_id = l.victim_user_id)
19. 0.000 0.000 ↓ 0.0 0 104,585

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=104,585)

  • Index Cond: (entity_type_id = l.exploding_entity_type_id)