explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 338

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=1,337,613.91..1,337,875.37 rows=104,585 width=2,859) (actual time=.. rows= loops=)

  • Sort Key: l.time_stamp
2. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=824,004.30..941,748.99 rows=104,585 width=2,859) (actual time=.. rows= loops=)

  • Hash Cond: (l.exploding_entity_type_id = eet.entity_type_id)
3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=823,987.10..861,070.44 rows=104,585 width=2,645) (actual time=.. rows= loops=)

  • Hash Cond: (l.victim_user_id = vu.user_id)
4. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=823,969.90..860,661.04 rows=104,585 width=2,431) (actual time=.. rows= loops=)

  • Hash Cond: (inner_l1.log_entry_id = l.log_entry_id)
5. 0.000 0.000 ↓ 0.0

WindowAgg (cost=782,831.67..784,661.90 rows=104,585 width=12) (actual time=.. rows= loops=)

6. 0.000 0.000 ↓ 0.0

Sort (cost=782,831.67..783,093.13 rows=104,585 width=12) (actual time=.. rows= loops=)

  • Sort Key: (max(inner_l2.time_stamp))
7. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=745,524.59..772,323.75 rows=104,585 width=12) (actual time=.. rows= loops=)

8. 0.000 0.000 ↓ 0.0

Sort (cost=745,524.59..754,109.02 rows=3,433,775 width=12) (actual time=.. rows= loops=)

  • Sort Key: inner_l1.log_entry_id
9. 0.000 0.000 ↓ 0.0

Merge Join (cost=16,154.21..196,711.39 rows=3,433,775 width=12) (actual time=.. rows= loops=)

  • Merge Cond: (inner_l2.player_user_id = inner_l1.player_user_id)
  • Join Filter: (inner_l2.time_stamp <= inner_l1.time_stamp)
10. 0.000 0.000 ↓ 0.0

Sort (cost=3,219.44..3,236.31 rows=6,747 width=12) (actual time=.. rows= loops=)

  • Sort Key: inner_l2.player_user_id
11. 0.000 0.000 ↓ 0.0

Hash Semi Join (cost=13.88..2,790.33 rows=6,747 width=12) (actual time=.. rows= loops=)

  • Hash Cond: (inner_l2.log_entry_type_id = log_entry_types.log_entry_type_id)
12. 0.000 0.000 ↓ 0.0

Seq Scan on log_entries inner_l2 (cost=0.00..2,426.85 rows=104,585 width=16) (actual time=.. rows= loops=)

13. 0.000 0.000 ↓ 0.0

Hash (cost=13.86..13.86 rows=2 width=4) (actual time=.. rows= loops=)

14. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on log_entry_types (cost=8.52..13.86 rows=2 width=4) (actual time=.. rows= loops=)

  • Recheck Cond: ((log_entry_type_name)::text = ANY ('{"Player join","Player joined"}'::text[]))
15. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on log_entry_types_log_entry_type_name_key (cost=0.00..8.52 rows=2 width=0) (actual time=.. rows= loops=)

  • Index Cond: ((log_entry_type_name)::text = ANY ('{"Player join","Player joined"}'::text[]))
16. 0.000 0.000 ↓ 0.0

Materialize (cost=12,934.77..13,457.69 rows=104,585 width=16) (actual time=.. rows= loops=)

17. 0.000 0.000 ↓ 0.0

Sort (cost=12,934.77..13,196.23 rows=104,585 width=16) (actual time=.. rows= loops=)

  • Sort Key: inner_l1.player_user_id
18. 0.000 0.000 ↓ 0.0

Seq Scan on log_entries inner_l1 (cost=0.00..2,426.85 rows=104,585 width=16) (actual time=.. rows= loops=)

19. 0.000 0.000 ↓ 0.0

Hash (cost=8,679.93..8,679.93 rows=104,585 width=2,415) (actual time=.. rows= loops=)

20. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=85.12..8,679.93 rows=104,585 width=2,415) (actual time=.. rows= loops=)

  • Hash Cond: (l.victim_entity_type_id = vet.entity_type_id)
21. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=67.92..7,384.66 rows=104,585 width=2,201) (actual time=.. rows= loops=)

  • Hash Cond: (l.damage_type_id = dt.damage_type_id)
22. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=50.72..6,963.66 rows=104,585 width=1,987) (actual time=.. rows= loops=)

  • Hash Cond: (l.world_id = w.world_id)
23. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=38.69..5,513.59 rows=104,585 width=1,129) (actual time=.. rows= loops=)

  • Hash Cond: (l.player_user_id = pu.user_id)
24. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=21.49..4,916.16 rows=104,585 width=915) (actual time=.. rows= loops=)

  • Hash Cond: (l.log_entry_type_id = let.log_entry_type_id)
25. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=4.29..3,460.91 rows=104,585 width=701) (actual time=.. rows= loops=)

  • Hash Cond: (l.block_type_id = bt.block_type_id)
26. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=2.15..2,962.22 rows=104,585 width=696) (actual time=.. rows= loops=)

  • Hash Cond: (l.player_holding_item_type_id = it.item_type_id)
27. 0.000 0.000 ↓ 0.0

Seq Scan on log_entries l (cost=0.00..2,426.85 rows=104,585 width=692) (actual time=.. rows= loops=)

28. 0.000 0.000 ↓ 0.0

Hash (cost=1.51..1.51 rows=51 width=12) (actual time=.. rows= loops=)

29. 0.000 0.000 ↓ 0.0

Seq Scan on item_types it (cost=0.00..1.51 rows=51 width=12) (actual time=.. rows= loops=)

30. 0.000 0.000 ↓ 0.0

Hash (cost=1.51..1.51 rows=51 width=13) (actual time=.. rows= loops=)

31. 0.000 0.000 ↓ 0.0

Seq Scan on block_types bt (cost=0.00..1.51 rows=51 width=13) (actual time=.. rows= loops=)

32. 0.000 0.000 ↓ 0.0

Hash (cost=13.20..13.20 rows=320 width=222) (actual time=.. rows= loops=)

33. 0.000 0.000 ↓ 0.0

Seq Scan on log_entry_types let (cost=0.00..13.20 rows=320 width=222) (actual time=.. rows= loops=)

34. 0.000 0.000 ↓ 0.0

Hash (cost=13.20..13.20 rows=320 width=222) (actual time=.. rows= loops=)

35. 0.000 0.000 ↓ 0.0

Seq Scan on users pu (cost=0.00..13.20 rows=320 width=222) (actual time=.. rows= loops=)

36. 0.000 0.000 ↓ 0.0

Hash (cost=10.90..10.90 rows=90 width=866) (actual time=.. rows= loops=)

37. 0.000 0.000 ↓ 0.0

Seq Scan on worlds w (cost=0.00..10.90 rows=90 width=866) (actual time=.. rows= loops=)

38. 0.000 0.000 ↓ 0.0

Hash (cost=13.20..13.20 rows=320 width=222) (actual time=.. rows= loops=)

39. 0.000 0.000 ↓ 0.0

Seq Scan on damage_types dt (cost=0.00..13.20 rows=320 width=222) (actual time=.. rows= loops=)

40. 0.000 0.000 ↓ 0.0

Hash (cost=13.20..13.20 rows=320 width=222) (actual time=.. rows= loops=)

41. 0.000 0.000 ↓ 0.0

Seq Scan on entity_types vet (cost=0.00..13.20 rows=320 width=222) (actual time=.. rows= loops=)

42. 0.000 0.000 ↓ 0.0

Hash (cost=13.20..13.20 rows=320 width=222) (actual time=.. rows= loops=)

43. 0.000 0.000 ↓ 0.0

Seq Scan on users vu (cost=0.00..13.20 rows=320 width=222) (actual time=.. rows= loops=)

44. 0.000 0.000 ↓ 0.0

Hash (cost=13.20..13.20 rows=320 width=222) (actual time=.. rows= loops=)

45. 0.000 0.000 ↓ 0.0

Seq Scan on entity_types eet (cost=0.00..13.20 rows=320 width=222) (actual time=.. rows= loops=)