explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 5Exd

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 537.241 1566.773 ↑ 1.0 104585 1

Sort (cost=216401.89..216663.35 rows=104585 width=851) (actual time=1522.583..1566.773 rows=104585 loops=1)

  • Sort Key: l.time_stamp
  • Sort Method: external sort Disk: 20552kB
2. 592.584 1029.532 ↑ 1.0 104585 1

Hash Left Join (cost=14.85..89714.97 rows=104585 width=851) (actual time=2.105..1029.532 rows=104585 loops=1)

  • Hash Cond: (l.exploding_entity_type_id = eet.entity_type_id)
3. 38.481 436.940 ↑ 1.0 104585 1

Hash Left Join (cost=13.51..9052.31 rows=104585 width=847) (actual time=0.319..436.940 rows=104585 loops=1)

  • Hash Cond: (l.victim_user_id = vu.user_id)
4. 40.147 398.451 ↑ 1.0 104585 1

Hash Left Join (cost=12.20..8658.79 rows=104585 width=840) (actual time=0.296..398.451 rows=104585 loops=1)

  • Hash Cond: (l.block_type_id = bt.block_type_id)
5. 36.708 358.270 ↑ 1.0 104585 1

Hash Left Join (cost=9.78..8152.55 rows=104585 width=835) (actual time=0.247..358.270 rows=104585 loops=1)

  • Hash Cond: (l.player_holding_item_type_id = it.item_type_id)
6. 38.658 321.519 ↑ 1.0 104585 1

Hash Left Join (cost=6.96..7570.61 rows=104585 width=830) (actual time=0.184..321.519 rows=104585 loops=1)

  • Hash Cond: (l.player_user_id = pu.user_id)
7. 39.134 282.852 ↑ 1.0 104585 1

Hash Left Join (cost=5.64..6990.17 rows=104585 width=823) (actual time=0.155..282.852 rows=104585 loops=1)

  • Hash Cond: (l.damage_type_id = dt.damage_type_id)
8. 59.741 243.707 ↑ 1.0 104585 1

Hash Left Join (cost=4.21..6584.66 rows=104585 width=810) (actual time=0.125..243.707 rows=104585 loops=1)

  • Hash Cond: (l.world_id = w.world_id)
9. 56.326 183.958 ↑ 1.0 104585 1

Hash Left Join (cost=3.06..5145.45 rows=104585 width=712) (actual time=0.093..183.958 rows=104585 loops=1)

  • Hash Cond: (l.log_entry_type_id = let.log_entry_type_id)
10. 96.829 127.614 ↑ 1.0 104585 1

Hash Left Join (cost=1.34..3705.69 rows=104585 width=696) (actual time=0.051..127.614 rows=104585 loops=1)

  • Hash Cond: (l.victim_entity_type_id = vet.entity_type_id)
11. 30.774 30.774 ↑ 1.0 104585 1

Seq Scan on log_entries l (cost=0.00..2426.85 rows=104585 width=692) (actual time=0.008..30.774 rows=104585 loops=1)

12. 0.004 0.011 ↑ 1.0 15 1

Hash (cost=1.15..1.15 rows=15 width=12) (actual time=0.011..0.011 rows=15 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
13. 0.007 0.007 ↑ 1.0 15 1

Seq Scan on entity_types vet (cost=0.00..1.15 rows=15 width=12) (actual time=0.002..0.007 rows=15 loops=1)

14. 0.007 0.018 ↑ 1.0 32 1

Hash (cost=1.32..1.32 rows=32 width=24) (actual time=0.018..0.018 rows=32 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
15. 0.011 0.011 ↑ 1.0 32 1

Seq Scan on log_entry_types let (cost=0.00..1.32 rows=32 width=24) (actual time=0.003..0.011 rows=32 loops=1)

16. 0.003 0.008 ↑ 1.0 7 1

Hash (cost=1.07..1.07 rows=7 width=106) (actual time=0.008..0.008 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
17. 0.005 0.005 ↑ 1.0 7 1

Seq Scan on worlds w (cost=0.00..1.07 rows=7 width=106) (actual time=0.002..0.005 rows=7 loops=1)

18. 0.005 0.011 ↑ 1.0 19 1

Hash (cost=1.19..1.19 rows=19 width=21) (actual time=0.011..0.011 rows=19 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
19. 0.006 0.006 ↑ 1.0 19 1

Seq Scan on damage_types dt (cost=0.00..1.19 rows=19 width=21) (actual time=0.002..0.006 rows=19 loops=1)

20. 0.005 0.009 ↑ 1.0 14 1

Hash (cost=1.14..1.14 rows=14 width=15) (actual time=0.009..0.009 rows=14 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
21. 0.004 0.004 ↑ 1.0 14 1

Seq Scan on users pu (cost=0.00..1.14 rows=14 width=15) (actual time=0.002..0.004 rows=14 loops=1)

22. 0.024 0.043 ↑ 1.0 81 1

Hash (cost=1.81..1.81 rows=81 width=13) (actual time=0.043..0.043 rows=81 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 4kB
23. 0.019 0.019 ↑ 1.0 81 1

Seq Scan on item_types it (cost=0.00..1.81 rows=81 width=13) (actual time=0.003..0.019 rows=81 loops=1)

24. 0.018 0.034 ↑ 1.0 63 1

Hash (cost=1.63..1.63 rows=63 width=13) (actual time=0.034..0.034 rows=63 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 3kB
25. 0.016 0.016 ↑ 1.0 63 1

Seq Scan on block_types bt (cost=0.00..1.63 rows=63 width=13) (actual time=0.002..0.016 rows=63 loops=1)

26. 0.003 0.008 ↑ 1.0 14 1

Hash (cost=1.14..1.14 rows=14 width=15) (actual time=0.008..0.008 rows=14 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
27. 0.005 0.005 ↑ 1.0 14 1

Seq Scan on users vu (cost=0.00..1.14 rows=14 width=15) (actual time=0.001..0.005 rows=14 loops=1)

28. 0.005 0.008 ↑ 1.0 15 1

Hash (cost=1.15..1.15 rows=15 width=12) (actual time=0.008..0.008 rows=15 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
29. 0.003 0.003 ↑ 1.0 15 1

Seq Scan on entity_types eet (cost=0.00..1.15 rows=15 width=12) (actual time=0.001..0.003 rows=15 loops=1)