explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0jxb

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=350.37..9,111.01 rows=412 width=11,220) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=350.08..8,762.57 rows=412 width=10,965) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=349.80..5,749.82 rows=412 width=10,710) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=349.51..2,737.07 rows=412 width=10,455) (actual rows= loops=)

  • Hash Cond: (shopgroup13_.map_icon_category = shopcatego19_.id)
5. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=347.79..2,729.94 rows=412 width=9,894) (actual rows= loops=)

  • Hash Cond: ((languagepr17_.language_id)::text = (language18_.id)::text)
6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=346.59..2,723.07 rows=412 width=8,921) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=346.31..2,418.52 rows=412 width=8,134) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=346.02..2,070.09 rows=412 width=7,879) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=345.74..1,721.65 rows=412 width=7,624) (actual rows= loops=)

  • Hash Cond: (shopgroup13_.create_user_id = user14_.id)
10. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=328.38..1,698.63 rows=412 width=6,712) (actual rows= loops=)

  • Hash Cond: (this_.shop_group_id = shopgroup13_.id)
11. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=164.42..1,527.46 rows=412 width=6,635) (actual rows= loops=)

  • Hash Cond: (mapshop9_.plan_id = plan10_.id)
12. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=149.72..1,507.10 rows=412 width=5,939) (actual rows= loops=)

  • Join Filter: (this_.location_id = location2_.id)
13. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=149.02..1,474.75 rows=412 width=1,304) (actual rows= loops=)

  • Hash Cond: (mapshop9_.linked_object_id = this_.id)
14. 0.000 0.000 ↓ 0.0

Seq Scan on map_object mapshop9_ (cost=0.00..1,265.45 rows=15,189 width=1,000) (actual rows= loops=)

  • Filter: ((class)::text = 'com.a1s.naviguide.MapShop'::text)
15. 0.000 0.000 ↓ 0.0

Hash (cost=143.87..143.87 rows=412 width=304) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on shops this_ (cost=11.57..143.87 rows=412 width=304) (actual rows= loops=)

  • Recheck Cond: (location_id = 2793)
  • Filter: (active AND (NOT deleted))
17. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on shops_location_id_idx (cost=0.00..11.46 rows=424 width=0) (actual rows= loops=)

  • Index Cond: (location_id = 2793)
18. 0.000 0.000 ↓ 0.0

Materialize (cost=0.70..26.18 rows=1 width=4,635) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.70..26.17 rows=1 width=4,635) (actual rows= loops=)

  • Join Filter: (group4_.parent_id = group5_.id)
20. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.70..24.88 rows=1 width=3,539) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.56..16.71 rows=1 width=2,627) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.42..16.47 rows=1 width=1,531) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Index Scan using location_pkey on location location2_ (cost=0.28..8.29 rows=1 width=619) (actual rows= loops=)

  • Index Cond: (id = 2793)
24. 0.000 0.000 ↓ 0.0

Index Scan using users_login_pkey on users_login user3_ (cost=0.14..8.16 rows=1 width=912) (actual rows= loops=)

  • Index Cond: (location2_.create_user_id = id)
25. 0.000 0.000 ↓ 0.0

Index Scan using groups_pkey on groups group4_ (cost=0.14..0.23 rows=1 width=1,096) (actual rows= loops=)

  • Index Cond: (user3_.group_id = id)
26. 0.000 0.000 ↓ 0.0

Index Scan using users_login_pkey on users_login user6_ (cost=0.14..8.16 rows=1 width=912) (actual rows= loops=)

  • Index Cond: (location2_.owner_id = id)
27. 0.000 0.000 ↓ 0.0

Seq Scan on groups group5_ (cost=0.00..1.13 rows=13 width=1,096) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Hash (cost=10.98..10.98 rows=298 width=696) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Seq Scan on plan plan10_ (cost=0.00..10.98 rows=298 width=696) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

Hash (cost=106.76..106.76 rows=4,576 width=77) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Seq Scan on shop_group shopgroup13_ (cost=0.00..106.76 rows=4,576 width=77) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Hash (cost=15.49..15.49 rows=149 width=912) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Seq Scan on users_login user14_ (cost=0.00..15.49 rows=149 width=912) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Index Scan using uploaded_image_pkey on uploaded_image uploadedim15_ (cost=0.29..0.84 rows=1 width=255) (actual rows= loops=)

  • Index Cond: (shopgroup13_.icon = id)
35. 0.000 0.000 ↓ 0.0

Index Scan using uploaded_image_pkey on uploaded_image uploadedim16_ (cost=0.29..0.84 rows=1 width=255) (actual rows= loops=)

  • Index Cond: (shopgroup13_.image = id)
36. 0.000 0.000 ↓ 0.0

Index Scan using shop_group_idx on shop_group_language_depend_property languagepr17_ (cost=0.28..0.73 rows=1 width=787) (actual rows= loops=)

  • Index Cond: (shopgroup13_.id = shop_group)
37. 0.000 0.000 ↓ 0.0

Hash (cost=1.09..1.09 rows=9 width=973) (actual rows= loops=)

38. 0.000 0.000 ↓ 0.0

Seq Scan on language language18_ (cost=0.00..1.09 rows=9 width=973) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

Hash (cost=1.32..1.32 rows=32 width=561) (actual rows= loops=)

40. 0.000 0.000 ↓ 0.0

Seq Scan on shop_categories shopcatego19_ (cost=0.00..1.32 rows=32 width=561) (actual rows= loops=)

41. 0.000 0.000 ↓ 0.0

Index Scan using uploaded_image_pkey on uploaded_image uploadedim20_ (cost=0.29..7.30 rows=1 width=255) (actual rows= loops=)

  • Index Cond: (shopcatego19_.icon = id)
42. 0.000 0.000 ↓ 0.0

Index Scan using uploaded_image_pkey on uploaded_image uploadedim21_ (cost=0.29..7.30 rows=1 width=255) (actual rows= loops=)

  • Index Cond: (shopcatego19_.image = id)
43. 0.000 0.000 ↓ 0.0

Index Scan using uploaded_image_pkey on uploaded_image uploadedim24_ (cost=0.29..0.84 rows=1 width=255) (actual rows= loops=)

  • Index Cond: (shopgroup13_.map_icon_self = id)