explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VHjS

Settings
# exclusive inclusive rows x rows loops node
1. 0.269 114.688 ↑ 1.0 53 1

Nested Loop Left Join (cost=8.37..2,458.21 rows=53 width=11,173) (actual time=1.731..114.688 rows=53 loops=1)

2. 0.248 114.366 ↑ 1.0 53 1

Nested Loop Left Join (cost=7.96..2,345.17 rows=53 width=10,473) (actual time=1.715..114.366 rows=53 loops=1)

3. 0.273 114.065 ↑ 1.0 53 1

Nested Loop Left Join (cost=7.68..2,257.39 rows=53 width=10,393) (actual time=1.703..114.065 rows=53 loops=1)

4. 0.242 113.739 ↑ 1.0 53 1

Nested Loop Left Join (cost=7.27..2,144.36 rows=53 width=9,697) (actual time=1.676..113.739 rows=53 loops=1)

5. 0.221 113.444 ↑ 1.0 53 1

Nested Loop Left Join (cost=6.99..2,056.58 rows=53 width=9,617) (actual time=1.660..113.444 rows=53 loops=1)

6. 0.259 113.117 ↑ 1.0 53 1

Nested Loop Left Join (cost=6.58..1,943.54 rows=53 width=8,921) (actual time=1.648..113.117 rows=53 loops=1)

7. 0.216 112.805 ↑ 1.0 53 1

Nested Loop Left Join (cost=6.30..1,855.77 rows=53 width=8,841) (actual time=1.636..112.805 rows=53 loops=1)

8. 0.226 102.254 ↑ 1.0 53 1

Nested Loop Left Join (cost=5.87..1,726.18 rows=53 width=8,643) (actual time=1.585..102.254 rows=53 loops=1)

9. 0.198 101.869 ↑ 1.0 53 1

Nested Loop Left Join (cost=5.46..1,613.14 rows=53 width=7,947) (actual time=1.567..101.869 rows=53 loops=1)

10. 0.215 101.512 ↑ 1.0 53 1

Nested Loop Left Join (cost=5.18..1,512.38 rows=53 width=7,867) (actual time=1.547..101.512 rows=53 loops=1)

11. 0.205 101.297 ↑ 1.0 53 1

Nested Loop Left Join (cost=4.77..1,399.34 rows=53 width=7,171) (actual time=1.535..101.297 rows=53 loops=1)

12. 0.189 101.092 ↑ 1.0 53 1

Nested Loop Left Join (cost=4.49..1,298.57 rows=53 width=7,091) (actual time=1.523..101.092 rows=53 loops=1)

13. 0.193 100.903 ↑ 1.0 53 1

Nested Loop Left Join (cost=4.08..1,185.53 rows=53 width=6,395) (actual time=1.514..100.903 rows=53 loops=1)

14. 0.166 100.710 ↑ 1.0 53 1

Nested Loop Left Join (cost=3.80..1,084.76 rows=53 width=6,315) (actual time=1.505..100.710 rows=53 loops=1)

15. 0.185 100.491 ↑ 1.0 53 1

Nested Loop Left Join (cost=3.11..870.42 rows=53 width=5,539) (actual time=1.495..100.491 rows=53 loops=1)

16. 0.186 99.988 ↑ 1.0 53 1

Nested Loop Left Join (cost=2.70..757.38 rows=53 width=4,843) (actual time=1.456..99.988 rows=53 loops=1)

17. 0.175 99.643 ↑ 1.0 53 1

Nested Loop Left Join (cost=2.42..656.61 rows=53 width=4,763) (actual time=1.435..99.643 rows=53 loops=1)

18. 0.149 83.780 ↑ 1.0 53 1

Nested Loop Left Join (cost=2.00..527.29 rows=53 width=4,410) (actual time=1.006..83.780 rows=53 loops=1)

19. 0.142 83.631 ↑ 1.0 53 1

Nested Loop Left Join (cost=1.58..414.25 rows=53 width=3,714) (actual time=0.998..83.631 rows=53 loops=1)

20. 0.149 83.489 ↑ 1.0 53 1

Nested Loop Left Join (cost=1.30..326.48 rows=53 width=3,634) (actual time=0.990..83.489 rows=53 loops=1)

21. 0.185 82.121 ↑ 1.0 53 1

Nested Loop (cost=0.88..230.02 rows=53 width=3,542) (actual time=0.953..82.121 rows=53 loops=1)

22. 47.433 47.433 ↑ 1.0 53 1

Index Scan Backward using orders_orderitem_pkey on orders_orderitem (cost=0.44..99.90 rows=53 width=3,326) (actual time=0.508..47.433 rows=53 loops=1)

  • Index Cond: (order_item_id = ANY ('{615553,5294338,5912197,1795334,5212044,4574732,4860942,609168,4058386,3835026,604690,3722777,545306,5126180,562600,533176,4515508,857654,5916088,5230905,6173881,744379,589754,3965629,3918909,5535679,5558976,738625,610237,564291,3635275,612300,598476,518225,733653,557911,4162393,695385,3411805,693471,596065,3335907,535141,4379367,3967983,604655,5450101,742010,615415,552825,5994746,6137083,5083263}'::integer[]))
23. 34.503 34.503 ↑ 1.0 1 53

Index Scan using orders_order_pkey on orders_order (cost=0.44..2.46 rows=1 width=216) (actual time=0.651..0.651 rows=1 loops=53)

  • Index Cond: (order_id = orders_orderitem.order_id)
24. 1.219 1.219 ↑ 1.0 1 53

Index Scan using clients_client_pkey on clients_client (cost=0.43..1.82 rows=1 width=92) (actual time=0.023..0.023 rows=1 loops=53)

  • Index Cond: (orders_order.client_id = client_id)
25. 0.000 0.000 ↓ 0.0 0 53

Index Scan using auth_user_pkey on auth_user (cost=0.28..1.66 rows=1 width=80) (actual time=0.000..0.000 rows=0 loops=53)

  • Index Cond: (orders_order.created_by_user_id = id)
26. 0.000 0.000 ↓ 0.0 0 53

Index Scan using profile_userconfig_user_id_key on profile_userconfig (cost=0.41..2.13 rows=1 width=696) (actual time=0.000..0.000 rows=0 loops=53)

  • Index Cond: (auth_user.id = user_id)
27. 15.688 15.688 ↑ 1.0 1 53

Index Scan using hotels_hotel_pkey on hotels_hotel (cost=0.42..2.44 rows=1 width=353) (actual time=0.296..0.296 rows=1 loops=53)

  • Index Cond: (orders_orderitem.hotel_id = id)
28. 0.159 0.159 ↓ 0.0 0 53

Index Scan using auth_user_pkey on auth_user t7 (cost=0.28..1.90 rows=1 width=80) (actual time=0.003..0.003 rows=0 loops=53)

  • Index Cond: (orders_orderitem.precheck_manager_id = id)
29. 0.318 0.318 ↓ 0.0 0 53

Index Scan using profile_userconfig_user_id_key on profile_userconfig t8 (cost=0.41..2.13 rows=1 width=696) (actual time=0.006..0.006 rows=0 loops=53)

  • Index Cond: (t7.id = user_id)
30. 0.053 0.053 ↓ 0.0 0 53

Nested Loop Left Join (cost=0.69..4.03 rows=1 width=776) (actual time=0.001..0.001 rows=0 loops=53)

31. 0.000 0.000 ↓ 0.0 0 53

Index Scan using auth_user_pkey on auth_user t11 (cost=0.28..1.90 rows=1 width=80) (actual time=0.000..0.000 rows=0 loops=53)

  • Index Cond: (orders_orderitem.baas_manager_id = id)
32. 0.000 0.000 ↓ 0.0 0

Index Scan using profile_userconfig_user_id_key on profile_userconfig t12 (cost=0.41..2.13 rows=1 width=696) (never executed)

  • Index Cond: (t11.id = user_id)
33. 0.000 0.000 ↓ 0.0 0 53

Index Scan using auth_user_pkey on auth_user t9 (cost=0.28..1.90 rows=1 width=80) (actual time=0.000..0.000 rows=0 loops=53)

  • Index Cond: (orders_orderitem.precheck_manager_callback_id = id)
34. 0.000 0.000 ↓ 0.0 0 53

Index Scan using profile_userconfig_user_id_key on profile_userconfig t10 (cost=0.41..2.13 rows=1 width=696) (actual time=0.000..0.000 rows=0 loops=53)

  • Index Cond: (t9.id = user_id)
35. 0.000 0.000 ↓ 0.0 0 53

Index Scan using auth_user_pkey on auth_user t13 (cost=0.28..1.90 rows=1 width=80) (actual time=0.000..0.000 rows=0 loops=53)

  • Index Cond: (orders_orderitem.noshow_manager_id = id)
36. 0.000 0.000 ↓ 0.0 0 53

Index Scan using profile_userconfig_user_id_key on profile_userconfig t14 (cost=0.41..2.13 rows=1 width=696) (actual time=0.000..0.000 rows=0 loops=53)

  • Index Cond: (t13.id = user_id)
37. 0.159 0.159 ↑ 1.0 1 53

Index Scan using auth_user_pkey on auth_user t15 (cost=0.28..1.90 rows=1 width=80) (actual time=0.003..0.003 rows=1 loops=53)

  • Index Cond: (orders_orderitem.modified_by_id = id)
38. 0.159 0.159 ↑ 1.0 1 53

Index Scan using profile_userconfig_user_id_key on profile_userconfig t16 (cost=0.41..2.13 rows=1 width=696) (actual time=0.003..0.003 rows=1 loops=53)

  • Index Cond: (t15.id = user_id)
39. 10.335 10.335 ↓ 0.0 0 53

Index Scan using orders_confirmation_pkey on orders_confirmation (cost=0.43..2.45 rows=1 width=198) (actual time=0.195..0.195 rows=0 loops=53)

  • Index Cond: (orders_orderitem.order_item_id = order_item_id)
40. 0.053 0.053 ↓ 0.0 0 53

Index Scan using auth_user_pkey on auth_user t18 (cost=0.28..1.66 rows=1 width=80) (actual time=0.001..0.001 rows=0 loops=53)

  • Index Cond: (orders_confirmation.precheck_manager_id = id)
41. 0.106 0.106 ↓ 0.0 0 53

Index Scan using profile_userconfig_user_id_key on profile_userconfig t19 (cost=0.41..2.13 rows=1 width=696) (actual time=0.002..0.002 rows=0 loops=53)

  • Index Cond: (t18.id = user_id)
42. 0.053 0.053 ↓ 0.0 0 53

Index Scan using auth_user_pkey on auth_user t20 (cost=0.28..1.66 rows=1 width=80) (actual time=0.001..0.001 rows=0 loops=53)

  • Index Cond: (orders_confirmation.created_by_id = id)
43. 0.053 0.053 ↓ 0.0 0 53

Index Scan using profile_userconfig_user_id_key on profile_userconfig t21 (cost=0.41..2.13 rows=1 width=696) (actual time=0.001..0.001 rows=0 loops=53)

  • Index Cond: (t20.id = user_id)
44. 0.053 0.053 ↓ 0.0 0 53

Index Scan using auth_user_pkey on auth_user t22 (cost=0.28..1.66 rows=1 width=80) (actual time=0.001..0.001 rows=0 loops=53)

  • Index Cond: (orders_confirmation.modified_by_id = id)
45. 0.053 0.053 ↓ 0.0 0 53

Index Scan using profile_userconfig_user_id_key on profile_userconfig t23 (cost=0.41..2.13 rows=1 width=696) (actual time=0.001..0.001 rows=0 loops=53)

  • Index Cond: (t22.id = user_id)