explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fBVm

Settings
# exclusive inclusive rows x rows loops node
1. 0.564 116,427.284 ↑ 1.0 1 1

Aggregate (cost=4,428.79..4,428.80 rows=1 width=0) (actual time=116,427.283..116,427.284 rows=1 loops=1)

2. 1.047 116,426.720 ↓ 65.1 846 1

Append (cost=116.28..4,428.76 rows=13 width=0) (actual time=47,579.433..116,426.720 rows=846 loops=1)

3. 0.001 0.397 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1 (cost=116.28..116.30 rows=1 width=0) (actual time=0.397..0.397 rows=0 loops=1)

4. 0.001 0.396 ↓ 0.0 0 1

HashAggregate (cost=116.28..116.29 rows=1 width=16) (actual time=0.396..0.396 rows=0 loops=1)

5. 0.002 0.395 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.00..116.27 rows=1 width=16) (actual time=0.395..0.395 rows=0 loops=1)

  • Join Filter: (public.action_params.value = (blocket_2009.ad_actions.action_id)::text)
6. 0.000 0.393 ↓ 0.0 0 1

Nested Loop (cost=0.00..18.67 rows=1 width=16) (actual time=0.393..0.393 rows=0 loops=1)

  • Join Filter: ((blocket_2009.ad_actions.current_state = blocket_2009.action_states.state_id) AND (blocket_2009.ad_actions.action_id = blocket_2009.action_states.action_id))
7. 0.002 0.393 ↓ 0.0 0 1

Nested Loop (cost=0.00..18.09 rows=1 width=24) (actual time=0.393..0.393 rows=0 loops=1)

8. 0.003 0.391 ↓ 0.0 0 1

Nested Loop (cost=0.00..17.40 rows=1 width=12) (actual time=0.391..0.391 rows=0 loops=1)

9. 0.038 0.038 ↑ 1.0 1 1

Index Scan using users_email_key on users (cost=0.00..9.12 rows=1 width=4) (actual time=0.037..0.038 rows=1 loops=1)

  • Index Cond: ((email)::text = 'mjolkkon@gmail.com'::text)
10. 0.350 0.350 ↓ 0.0 0 1

Index Scan using index_ads_user_id on ads (cost=0.00..8.27 rows=1 width=16) (actual time=0.350..0.350 rows=0 loops=1)

  • Index Cond: (user_id = public.users.user_id)
11. 0.000 0.000 ↓ 0.0 0

Index Scan using index_ad_actions_ad_id on ad_actions (cost=0.00..0.68 rows=1 width=12) (never executed)

  • Index Cond: (ad_id = blocket_2009.ads.ad_id)
  • Filter: (state = 'refused'::enum_action_states_state)
12. 0.000 0.000 ↓ 0.0 0

Index Scan using index_action_states_state_ad_id on action_states (cost=0.00..0.57 rows=1 width=12) (never executed)

  • Index Cond: ((state = 'refused'::enum_action_states_state) AND (ad_id = blocket_2009.ads.ad_id))
13. 0.000 0.000 ↓ 0.0 0

Index Scan using action_params_pkey on action_params (cost=0.00..48.79 rows=1 width=8) (never executed)

  • Index Cond: ((ad_id = blocket_2009.ads.ad_id) AND ((name)::text = 'prev_action_id'::text))
14. 0.000 0.386 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=116.28..116.30 rows=1 width=0) (actual time=0.386..0.386 rows=0 loops=1)

15. 0.002 0.386 ↓ 0.0 0 1

HashAggregate (cost=116.28..116.29 rows=1 width=16) (actual time=0.386..0.386 rows=0 loops=1)

16. 0.001 0.384 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.00..116.27 rows=1 width=16) (actual time=0.384..0.384 rows=0 loops=1)

  • Join Filter: (public.action_params.value = (blocket_2010.ad_actions.action_id)::text)
17. 0.001 0.383 ↓ 0.0 0 1

Nested Loop (cost=0.00..18.67 rows=1 width=16) (actual time=0.383..0.383 rows=0 loops=1)

  • Join Filter: ((blocket_2010.ad_actions.current_state = blocket_2010.action_states.state_id) AND (blocket_2010.ad_actions.action_id = blocket_2010.action_states.action_id))
18. 0.001 0.382 ↓ 0.0 0 1

Nested Loop (cost=0.00..18.09 rows=1 width=24) (actual time=0.382..0.382 rows=0 loops=1)

19. 0.004 0.381 ↓ 0.0 0 1

Nested Loop (cost=0.00..17.40 rows=1 width=12) (actual time=0.381..0.381 rows=0 loops=1)

20. 0.011 0.011 ↑ 1.0 1 1

Index Scan using users_email_key on users (cost=0.00..9.12 rows=1 width=4) (actual time=0.010..0.011 rows=1 loops=1)

  • Index Cond: ((email)::text = 'mjolkkon@gmail.com'::text)
21. 0.366 0.366 ↓ 0.0 0 1

Index Scan using index_ads_user_id on ads (cost=0.00..8.27 rows=1 width=16) (actual time=0.366..0.366 rows=0 loops=1)

  • Index Cond: (user_id = public.users.user_id)
22. 0.000 0.000 ↓ 0.0 0

Index Scan using index_ad_actions_ad_id on ad_actions (cost=0.00..0.68 rows=1 width=12) (never executed)

  • Index Cond: (ad_id = blocket_2010.ads.ad_id)
  • Filter: (state = 'refused'::enum_action_states_state)
23. 0.000 0.000 ↓ 0.0 0

Index Scan using index_action_states_state_ad_id on action_states (cost=0.00..0.57 rows=1 width=12) (never executed)

  • Index Cond: ((state = 'refused'::enum_action_states_state) AND (ad_id = blocket_2010.ads.ad_id))
24. 0.000 0.000 ↓ 0.0 0

Index Scan using action_params_pkey on action_params (cost=0.00..48.79 rows=1 width=8) (never executed)

  • Index Cond: ((ad_id = blocket_2010.ads.ad_id) AND ((name)::text = 'prev_action_id'::text))
25. 0.001 0.622 ↓ 0.0 0 1

Subquery Scan on *SELECT* 3 (cost=116.28..116.30 rows=1 width=0) (actual time=0.622..0.622 rows=0 loops=1)

26. 0.001 0.621 ↓ 0.0 0 1

HashAggregate (cost=116.28..116.29 rows=1 width=16) (actual time=0.621..0.621 rows=0 loops=1)

27. 0.001 0.620 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.00..116.27 rows=1 width=16) (actual time=0.620..0.620 rows=0 loops=1)

  • Join Filter: (public.action_params.value = (blocket_2011.ad_actions.action_id)::text)
28. 0.001 0.619 ↓ 0.0 0 1

Nested Loop (cost=0.00..18.67 rows=1 width=16) (actual time=0.619..0.619 rows=0 loops=1)

  • Join Filter: ((blocket_2011.ad_actions.current_state = blocket_2011.action_states.state_id) AND (blocket_2011.ad_actions.action_id = blocket_2011.action_states.action_id))
29. 0.001 0.618 ↓ 0.0 0 1

Nested Loop (cost=0.00..18.09 rows=1 width=24) (actual time=0.618..0.618 rows=0 loops=1)

30. 0.003 0.617 ↓ 0.0 0 1

Nested Loop (cost=0.00..17.40 rows=1 width=12) (actual time=0.617..0.617 rows=0 loops=1)

31. 0.009 0.009 ↑ 1.0 1 1

Index Scan using users_email_key on users (cost=0.00..9.12 rows=1 width=4) (actual time=0.008..0.009 rows=1 loops=1)

  • Index Cond: ((email)::text = 'mjolkkon@gmail.com'::text)
32. 0.605 0.605 ↓ 0.0 0 1

Index Scan using index_ads_user_id on ads (cost=0.00..8.27 rows=1 width=16) (actual time=0.605..0.605 rows=0 loops=1)

  • Index Cond: (user_id = public.users.user_id)
33. 0.000 0.000 ↓ 0.0 0

Index Scan using index_ad_actions_ad_id on ad_actions (cost=0.00..0.68 rows=1 width=12) (never executed)

  • Index Cond: (ad_id = blocket_2011.ads.ad_id)
  • Filter: (state = 'refused'::enum_action_states_state)
34. 0.000 0.000 ↓ 0.0 0

Index Scan using index_action_states_state_ad_id on action_states (cost=0.00..0.57 rows=1 width=12) (never executed)

  • Index Cond: ((state = 'refused'::enum_action_states_state) AND (ad_id = blocket_2011.ads.ad_id))
35. 0.000 0.000 ↓ 0.0 0

Index Scan using action_params_pkey on action_params (cost=0.00..48.79 rows=1 width=8) (never executed)

  • Index Cond: ((ad_id = blocket_2011.ads.ad_id) AND ((name)::text = 'prev_action_id'::text))
36. 0.001 0.018 ↓ 0.0 0 1

Subquery Scan on *SELECT* 4 (cost=116.21..116.23 rows=1 width=0) (actual time=0.018..0.018 rows=0 loops=1)

37. 0.001 0.017 ↓ 0.0 0 1

HashAggregate (cost=116.21..116.22 rows=1 width=16) (actual time=0.017..0.017 rows=0 loops=1)

38. 0.002 0.016 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.00..116.20 rows=1 width=16) (actual time=0.016..0.016 rows=0 loops=1)

  • Join Filter: (public.action_params.value = (blocket_2012.ad_actions.action_id)::text)
39. 0.000 0.014 ↓ 0.0 0 1

Nested Loop (cost=0.00..18.60 rows=1 width=16) (actual time=0.014..0.014 rows=0 loops=1)

  • Join Filter: ((blocket_2012.ad_actions.current_state = blocket_2012.action_states.state_id) AND (blocket_2012.ad_actions.action_id = blocket_2012.action_states.action_id))
40. 0.001 0.014 ↓ 0.0 0 1

Nested Loop (cost=0.00..17.99 rows=1 width=24) (actual time=0.014..0.014 rows=0 loops=1)

41. 0.003 0.013 ↓ 0.0 0 1

Nested Loop (cost=0.00..17.40 rows=1 width=12) (actual time=0.013..0.013 rows=0 loops=1)

42. 0.008 0.008 ↑ 1.0 1 1

Index Scan using users_email_key on users (cost=0.00..9.12 rows=1 width=4) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: ((email)::text = 'mjolkkon@gmail.com'::text)
43. 0.002 0.002 ↓ 0.0 0 1

Index Scan using index_ads_user_id on ads (cost=0.00..8.27 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (user_id = public.users.user_id)
44. 0.000 0.000 ↓ 0.0 0

Index Scan using index_ad_actions_ad_id on ad_actions (cost=0.00..0.59 rows=1 width=12) (never executed)

  • Index Cond: (ad_id = blocket_2012.ads.ad_id)
  • Filter: (state = 'refused'::enum_action_states_state)
45. 0.000 0.000 ↓ 0.0 0

Index Scan using index_action_states_state_ad_id on action_states (cost=0.00..0.59 rows=1 width=12) (never executed)

  • Index Cond: ((state = 'refused'::enum_action_states_state) AND (ad_id = blocket_2012.ads.ad_id))
46. 0.000 0.000 ↓ 0.0 0

Index Scan using action_params_pkey on action_params (cost=0.00..48.79 rows=1 width=8) (never executed)

  • Index Cond: ((ad_id = blocket_2012.ads.ad_id) AND ((name)::text = 'prev_action_id'::text))
47. 0.001 0.015 ↓ 0.0 0 1

Subquery Scan on *SELECT* 5 (cost=116.17..116.19 rows=1 width=0) (actual time=0.015..0.015 rows=0 loops=1)

48. 0.001 0.014 ↓ 0.0 0 1

HashAggregate (cost=116.17..116.18 rows=1 width=16) (actual time=0.014..0.014 rows=0 loops=1)

49. 0.001 0.013 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.00..116.16 rows=1 width=16) (actual time=0.013..0.013 rows=0 loops=1)

  • Join Filter: (public.action_params.value = (blocket_2013.ad_actions.action_id)::text)
50. 0.001 0.012 ↓ 0.0 0 1

Nested Loop (cost=0.00..18.55 rows=1 width=16) (actual time=0.012..0.012 rows=0 loops=1)

  • Join Filter: ((blocket_2013.ad_actions.current_state = blocket_2013.action_states.state_id) AND (blocket_2013.ad_actions.action_id = blocket_2013.action_states.action_id))
51. 0.001 0.011 ↓ 0.0 0 1

Nested Loop (cost=0.00..17.97 rows=1 width=24) (actual time=0.011..0.011 rows=0 loops=1)

52. 0.002 0.010 ↓ 0.0 0 1

Nested Loop (cost=0.00..17.40 rows=1 width=12) (actual time=0.010..0.010 rows=0 loops=1)

53. 0.006 0.006 ↑ 1.0 1 1

Index Scan using users_email_key on users (cost=0.00..9.12 rows=1 width=4) (actual time=0.005..0.006 rows=1 loops=1)

  • Index Cond: ((email)::text = 'mjolkkon@gmail.com'::text)
54. 0.002 0.002 ↓ 0.0 0 1

Index Scan using index_ads_user_id on ads (cost=0.00..8.27 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (user_id = public.users.user_id)
55. 0.000 0.000 ↓ 0.0 0

Index Scan using index_ad_actions_ad_id on ad_actions (cost=0.00..0.57 rows=1 width=12) (never executed)

  • Index Cond: (ad_id = blocket_2013.ads.ad_id)
  • Filter: (state = 'refused'::enum_action_states_state)
56. 0.000 0.000 ↓ 0.0 0

Index Scan using index_action_states_state_ad_id on action_states (cost=0.00..0.57 rows=1 width=12) (never executed)

  • Index Cond: ((state = 'refused'::enum_action_states_state) AND (ad_id = blocket_2013.ads.ad_id))
57. 0.000 0.000 ↓ 0.0 0

Index Scan using action_params_pkey on action_params (cost=0.00..48.79 rows=1 width=8) (never executed)

  • Index Cond: ((ad_id = blocket_2013.ads.ad_id) AND ((name)::text = 'prev_action_id'::text))
58. 0.002 0.016 ↓ 0.0 0 1

Subquery Scan on *SELECT* 6 (cost=116.17..116.19 rows=1 width=0) (actual time=0.016..0.016 rows=0 loops=1)

59. 0.000 0.014 ↓ 0.0 0 1

HashAggregate (cost=116.17..116.18 rows=1 width=16) (actual time=0.014..0.014 rows=0 loops=1)

60. 0.002 0.014 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.00..116.16 rows=1 width=16) (actual time=0.014..0.014 rows=0 loops=1)

  • Join Filter: (public.action_params.value = (blocket_2014.ad_actions.action_id)::text)
61. 0.000 0.012 ↓ 0.0 0 1

Nested Loop (cost=0.00..18.55 rows=1 width=16) (actual time=0.012..0.012 rows=0 loops=1)

  • Join Filter: ((blocket_2014.ad_actions.current_state = blocket_2014.action_states.state_id) AND (blocket_2014.ad_actions.action_id = blocket_2014.action_states.action_id))
62. 0.001 0.012 ↓ 0.0 0 1

Nested Loop (cost=0.00..17.97 rows=1 width=24) (actual time=0.012..0.012 rows=0 loops=1)

63. 0.003 0.011 ↓ 0.0 0 1

Nested Loop (cost=0.00..17.40 rows=1 width=12) (actual time=0.011..0.011 rows=0 loops=1)

64. 0.006 0.006 ↑ 1.0 1 1

Index Scan using users_email_key on users (cost=0.00..9.12 rows=1 width=4) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: ((email)::text = 'mjolkkon@gmail.com'::text)
65. 0.002 0.002 ↓ 0.0 0 1

Index Scan using index_ads_user_id on ads (cost=0.00..8.27 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (user_id = public.users.user_id)
66. 0.000 0.000 ↓ 0.0 0

Index Scan using index_ad_actions_ad_id on ad_actions (cost=0.00..0.57 rows=1 width=12) (never executed)

  • Index Cond: (ad_id = blocket_2014.ads.ad_id)
  • Filter: (state = 'refused'::enum_action_states_state)
67. 0.000 0.000 ↓ 0.0 0

Index Scan using index_action_states_state_ad_id on action_states (cost=0.00..0.57 rows=1 width=12) (never executed)

  • Index Cond: ((state = 'refused'::enum_action_states_state) AND (ad_id = blocket_2014.ads.ad_id))
68. 0.000 0.000 ↓ 0.0 0

Index Scan using action_params_pkey on action_params (cost=0.00..48.79 rows=1 width=8) (never executed)

  • Index Cond: ((ad_id = blocket_2014.ads.ad_id) AND ((name)::text = 'prev_action_id'::text))
69. 0.002 0.016 ↓ 0.0 0 1

Subquery Scan on *SELECT* 7 (cost=116.17..116.19 rows=1 width=0) (actual time=0.016..0.016 rows=0 loops=1)

70. 0.000 0.014 ↓ 0.0 0 1

HashAggregate (cost=116.17..116.18 rows=1 width=16) (actual time=0.014..0.014 rows=0 loops=1)

71. 0.002 0.014 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.00..116.16 rows=1 width=16) (actual time=0.014..0.014 rows=0 loops=1)

  • Join Filter: (public.action_params.value = (blocket_2015.ad_actions.action_id)::text)
72. 0.001 0.012 ↓ 0.0 0 1

Nested Loop (cost=0.00..18.55 rows=1 width=16) (actual time=0.012..0.012 rows=0 loops=1)

  • Join Filter: ((blocket_2015.ad_actions.current_state = blocket_2015.action_states.state_id) AND (blocket_2015.ad_actions.action_id = blocket_2015.action_states.action_id))
73. 0.001 0.011 ↓ 0.0 0 1

Nested Loop (cost=0.00..17.97 rows=1 width=24) (actual time=0.011..0.011 rows=0 loops=1)

74. 0.002 0.010 ↓ 0.0 0 1

Nested Loop (cost=0.00..17.40 rows=1 width=12) (actual time=0.010..0.010 rows=0 loops=1)

75. 0.006 0.006 ↑ 1.0 1 1

Index Scan using users_email_key on users (cost=0.00..9.12 rows=1 width=4) (actual time=0.005..0.006 rows=1 loops=1)

  • Index Cond: ((email)::text = 'mjolkkon@gmail.com'::text)
76. 0.002 0.002 ↓ 0.0 0 1

Index Scan using index_ads_user_id on ads (cost=0.00..8.27 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (user_id = public.users.user_id)
77. 0.000 0.000 ↓ 0.0 0

Index Scan using index_ad_actions_ad_id on ad_actions (cost=0.00..0.57 rows=1 width=12) (never executed)

  • Index Cond: (ad_id = blocket_2015.ads.ad_id)
  • Filter: (state = 'refused'::enum_action_states_state)
78. 0.000 0.000 ↓ 0.0 0

Index Scan using index_action_states_state_ad_id on action_states (cost=0.00..0.57 rows=1 width=12) (never executed)

  • Index Cond: ((state = 'refused'::enum_action_states_state) AND (ad_id = blocket_2015.ads.ad_id))
79. 0.000 0.000 ↓ 0.0 0

Index Scan using action_params_pkey on action_params (cost=0.00..48.79 rows=1 width=8) (never executed)

  • Index Cond: ((ad_id = blocket_2015.ads.ad_id) AND ((name)::text = 'prev_action_id'::text))
80. 0.002 0.015 ↓ 0.0 0 1

Subquery Scan on *SELECT* 8 (cost=116.21..116.23 rows=1 width=0) (actual time=0.015..0.015 rows=0 loops=1)

81. 0.000 0.013 ↓ 0.0 0 1

HashAggregate (cost=116.21..116.22 rows=1 width=16) (actual time=0.013..0.013 rows=0 loops=1)

82. 0.002 0.013 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.00..116.20 rows=1 width=16) (actual time=0.013..0.013 rows=0 loops=1)

  • Join Filter: (public.action_params.value = (blocket_2016.ad_actions.action_id)::text)
83. 0.000 0.011 ↓ 0.0 0 1

Nested Loop (cost=0.00..18.60 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1)

  • Join Filter: ((blocket_2016.ad_actions.current_state = blocket_2016.action_states.state_id) AND (blocket_2016.ad_actions.action_id = blocket_2016.action_states.action_id))
84. 0.001 0.011 ↓ 0.0 0 1

Nested Loop (cost=0.00..17.99 rows=1 width=24) (actual time=0.011..0.011 rows=0 loops=1)

85. 0.001 0.010 ↓ 0.0 0 1

Nested Loop (cost=0.00..17.40 rows=1 width=12) (actual time=0.010..0.010 rows=0 loops=1)

86. 0.007 0.007 ↑ 1.0 1 1

Index Scan using users_email_key on users (cost=0.00..9.12 rows=1 width=4) (actual time=0.006..0.007 rows=1 loops=1)

  • Index Cond: ((email)::text = 'mjolkkon@gmail.com'::text)
87. 0.002 0.002 ↓ 0.0 0 1

Index Scan using index_ads_user_id on ads (cost=0.00..8.27 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (user_id = public.users.user_id)
88. 0.000 0.000 ↓ 0.0 0

Index Scan using index_ad_actions_ad_id on ad_actions (cost=0.00..0.59 rows=1 width=12) (never executed)

  • Index Cond: (ad_id = blocket_2016.ads.ad_id)
  • Filter: (state = 'refused'::enum_action_states_state)
89. 0.000 0.000 ↓ 0.0 0

Index Scan using index_action_states_state_ad_id on action_states (cost=0.00..0.59 rows=1 width=12) (never executed)

  • Index Cond: ((state = 'refused'::enum_action_states_state) AND (ad_id = blocket_2016.ads.ad_id))
90. 0.000 0.000 ↓ 0.0 0

Index Scan using action_params_pkey on action_params (cost=0.00..48.79 rows=1 width=8) (never executed)

  • Index Cond: ((ad_id = blocket_2016.ads.ad_id) AND ((name)::text = 'prev_action_id'::text))
91. 0.759 47,579.327 ↓ 612.0 612 1

Subquery Scan on *SELECT* 9 (cost=1,110.62..1,110.64 rows=1 width=0) (actual time=47,577.943..47,579.327 rows=612 loops=1)

92. 3.244 47,578.568 ↓ 612.0 612 1

HashAggregate (cost=1,110.62..1,110.63 rows=1 width=16) (actual time=47,577.941..47,578.568 rows=612 loops=1)

93. 2.873 47,575.324 ↓ 612.0 612 1

Nested Loop Anti Join (cost=0.00..1,110.61 rows=1 width=16) (actual time=30.814..47,575.324 rows=612 loops=1)

  • Join Filter: (public.action_params.value = (blocket_2017.ad_actions.action_id)::text)
94. 4.011 47,260.331 ↓ 612.0 612 1

Nested Loop (cost=0.00..1,066.26 rows=1 width=16) (actual time=29.976..47,260.331 rows=612 loops=1)

  • Join Filter: ((blocket_2017.ad_actions.current_state = blocket_2017.action_states.state_id) AND (blocket_2017.ad_actions.action_id = blocket_2017.action_states.action_id))
  • Rows Removed by Join Filter: 6
95. 138.131 46,835.264 ↓ 612.0 612 1

Nested Loop (cost=0.00..1,033.72 rows=1 width=24) (actual time=29.050..46,835.264 rows=612 loops=1)

96. 81.072 18,928.238 ↓ 6,557.0 45,899 1

Nested Loop (cost=0.00..913.92 rows=7 width=12) (actual time=1.252..18,928.238 rows=45,899 loops=1)

97. 0.007 0.007 ↑ 1.0 1 1

Index Scan using users_email_key on users (cost=0.00..9.12 rows=1 width=4) (actual time=0.005..0.007 rows=1 loops=1)

  • Index Cond: ((email)::text = 'mjolkkon@gmail.com'::text)
98. 18,847.159 18,847.159 ↓ 202.2 45,899 1

Index Scan using index_ads_user_id on ads (cost=0.00..902.53 rows=227 width=16) (actual time=1.244..18,847.159 rows=45,899 loops=1)

  • Index Cond: (user_id = public.users.user_id)
99. 27,768.895 27,768.895 ↓ 0.0 0 45,899

Index Scan using ad_actions_pkey on ad_actions (cost=0.00..17.10 rows=1 width=12) (actual time=0.605..0.605 rows=0 loops=45,899)

  • Index Cond: (ad_id = blocket_2017.ads.ad_id)
  • Filter: (state = 'refused'::enum_action_states_state)
  • Rows Removed by Filter: 5
100. 421.056 421.056 ↑ 3.0 1 612

Index Scan using index_action_states_state_ad_id on action_states (cost=0.00..32.49 rows=3 width=12) (actual time=0.685..0.688 rows=1 loops=612)

  • Index Cond: ((state = 'refused'::enum_action_states_state) AND (ad_id = blocket_2017.ads.ad_id))
101. 312.120 312.120 ↓ 0.0 0 612

Index Scan using index_action_params_ad_id_action_id2 on action_params (cost=0.00..22.17 rows=1 width=8) (actual time=0.510..0.510 rows=0 loops=612)

  • Index Cond: (ad_id = blocket_2017.ads.ad_id)
  • Filter: ((name)::text = 'prev_action_id'::text)
102. 0.229 46,054.323 ↓ 219.0 219 1

Subquery Scan on *SELECT* 10 (cost=924.36..924.38 rows=1 width=0) (actual time=46,053.920..46,054.323 rows=219 loops=1)

103. 1.116 46,054.094 ↓ 219.0 219 1

HashAggregate (cost=924.36..924.37 rows=1 width=16) (actual time=46,053.918..46,054.094 rows=219 loops=1)

104. 0.984 46,052.978 ↓ 219.0 219 1

Nested Loop Anti Join (cost=0.00..924.35 rows=1 width=16) (actual time=217.544..46,052.978 rows=219 loops=1)

  • Join Filter: (public.action_params.value = (blocket_2018.ad_actions.action_id)::text)
105. 1.520 45,941.837 ↓ 219.0 219 1

Nested Loop (cost=0.00..879.74 rows=1 width=16) (actual time=217.136..45,941.837 rows=219 loops=1)

  • Join Filter: ((blocket_2018.ad_actions.current_state = blocket_2018.action_states.state_id) AND (blocket_2018.ad_actions.action_id = blocket_2018.action_states.action_id))
  • Rows Removed by Join Filter: 2
106. 98.784 45,767.307 ↓ 219.0 219 1

Nested Loop (cost=0.00..858.40 rows=1 width=24) (actual time=215.969..45,767.307 rows=219 loops=1)

107. 83.784 18,516.189 ↓ 9,142.2 45,711 1

Nested Loop (cost=0.00..796.96 rows=5 width=12) (actual time=1.193..18,516.189 rows=45,711 loops=1)

108. 0.028 0.028 ↑ 1.0 1 1

Index Scan using users_email_key on users (cost=0.00..9.12 rows=1 width=4) (actual time=0.026..0.028 rows=1 loops=1)

  • Index Cond: ((email)::text = 'mjolkkon@gmail.com'::text)
109. 18,432.377 18,432.377 ↓ 233.2 45,711 1

Index Scan using index_ads_user_id on ads (cost=0.00..785.88 rows=196 width=16) (actual time=1.161..18,432.377 rows=45,711 loops=1)

  • Index Cond: (user_id = public.users.user_id)
110. 27,152.334 27,152.334 ↓ 0.0 0 45,711

Index Scan using ad_actions_pkey on ad_actions (cost=0.00..12.28 rows=1 width=12) (actual time=0.594..0.594 rows=0 loops=45,711)

  • Index Cond: (ad_id = blocket_2018.ads.ad_id)
  • Filter: (state = 'refused'::enum_action_states_state)
  • Rows Removed by Filter: 4
111. 173.010 173.010 ↑ 1.0 1 219

Index Scan using index_action_states_state_ad_id on action_states (cost=0.00..21.32 rows=1 width=12) (actual time=0.785..0.790 rows=1 loops=219)

  • Index Cond: ((state = 'refused'::enum_action_states_state) AND (ad_id = blocket_2018.ads.ad_id))
112. 110.157 110.157 ↓ 0.0 0 219

Index Scan using index_action_params_ad_id_action_id2 on action_params (cost=0.00..22.29 rows=1 width=8) (actual time=0.503..0.503 rows=0 loops=219)

  • Index Cond: (ad_id = blocket_2018.ads.ad_id)
  • Filter: ((name)::text = 'prev_action_id'::text)
113. 0.019 19,326.325 ↓ 15.0 15 1

Subquery Scan on *SELECT* 11 (cost=682.94..682.96 rows=1 width=0) (actual time=19,326.294..19,326.325 rows=15 loops=1)

114. 0.085 19,326.306 ↓ 15.0 15 1

HashAggregate (cost=682.94..682.95 rows=1 width=16) (actual time=19,326.292..19,326.306 rows=15 loops=1)

115. 0.077 19,326.221 ↓ 15.0 15 1

Nested Loop Anti Join (cost=6.99..682.93 rows=1 width=16) (actual time=245.862..19,326.221 rows=15 loops=1)

  • Join Filter: (public.action_params.value = (blocket_2019.ad_actions.action_id)::text)
116. 0.105 19,316.304 ↓ 15.0 15 1

Nested Loop (cost=6.99..637.98 rows=1 width=16) (actual time=245.078..19,316.304 rows=15 loops=1)

  • Join Filter: ((blocket_2019.ad_actions.current_state = blocket_2019.action_states.state_id) AND (blocket_2019.ad_actions.action_id = blocket_2019.action_states.action_id))
117. 68.569 19,302.354 ↓ 15.0 15 1

Nested Loop (cost=6.99..617.07 rows=1 width=24) (actual time=243.310..19,302.354 rows=15 loops=1)

118. 53.022 668.233 ↓ 8,044.0 32,176 1

Nested Loop (cost=6.99..572.31 rows=4 width=12) (actual time=73.836..668.233 rows=32,176 loops=1)

119. 0.026 0.026 ↑ 1.0 1 1

Index Scan using users_email_key on users (cost=0.00..9.12 rows=1 width=4) (actual time=0.024..0.026 rows=1 loops=1)

  • Index Cond: ((email)::text = 'mjolkkon@gmail.com'::text)
120. 550.168 615.185 ↓ 229.8 32,176 1

Bitmap Heap Scan on ads (cost=6.99..561.79 rows=140 width=16) (actual time=73.805..615.185 rows=32,176 loops=1)

  • Recheck Cond: (user_id = public.users.user_id)
121. 65.017 65.017 ↓ 229.8 32,176 1

Bitmap Index Scan on index_ads_user_id (cost=0.00..6.96 rows=140 width=0) (actual time=65.017..65.017 rows=32,176 loops=1)

  • Index Cond: (user_id = public.users.user_id)
122. 18,565.552 18,565.552 ↓ 0.0 0 32,176

Index Scan using index_ad_actions_ad_id on ad_actions (cost=0.00..11.18 rows=1 width=12) (actual time=0.577..0.577 rows=0 loops=32,176)

  • Index Cond: (ad_id = blocket_2019.ads.ad_id)
  • Filter: (state = 'refused'::enum_action_states_state)
  • Rows Removed by Filter: 3
123. 13.845 13.845 ↑ 2.0 1 15

Index Scan using index_action_states_state_ad_id on action_states (cost=0.00..20.89 rows=2 width=12) (actual time=0.921..0.923 rows=1 loops=15)

  • Index Cond: ((state = 'refused'::enum_action_states_state) AND (ad_id = blocket_2019.ads.ad_id))
124. 9.840 9.840 ↓ 0.0 0 15

Index Scan using index_action_params_ad_id_action_id2 on action_params (cost=0.00..22.47 rows=1 width=8) (actual time=0.656..0.656 rows=0 loops=15)

  • Index Cond: (ad_id = blocket_2019.ads.ad_id)
  • Filter: ((name)::text = 'prev_action_id'::text)
125. 0.002 2,169.251 ↓ 0.0 0 1

Subquery Scan on *SELECT* 12 (cost=164.00..164.02 rows=1 width=0) (actual time=2,169.251..2,169.251 rows=0 loops=1)

126. 0.003 2,169.249 ↓ 0.0 0 1

HashAggregate (cost=164.00..164.01 rows=1 width=16) (actual time=2,169.249..2,169.249 rows=0 loops=1)

127. 0.002 2,169.246 ↓ 0.0 0 1

Nested Loop Anti Join (cost=4.63..163.99 rows=1 width=16) (actual time=2,169.246..2,169.246 rows=0 loops=1)

  • Join Filter: (public.action_params.value = (blocket_2020.ad_actions.action_id)::text)
128. 0.002 2,169.244 ↓ 0.0 0 1

Nested Loop (cost=4.63..110.34 rows=1 width=16) (actual time=2,169.244..2,169.244 rows=0 loops=1)

  • Join Filter: ((blocket_2020.ad_actions.current_state = blocket_2020.action_states.state_id) AND (blocket_2020.ad_actions.action_id = blocket_2020.action_states.action_id))
129. 9.670 2,169.242 ↓ 0.0 0 1

Nested Loop (cost=4.63..106.85 rows=1 width=24) (actual time=2,169.242..2,169.242 rows=0 loops=1)

130. 6.680 93.660 ↓ 3,676.0 3,676 1

Nested Loop (cost=4.63..104.96 rows=1 width=12) (actual time=7.677..93.660 rows=3,676 loops=1)

131. 0.025 0.025 ↑ 1.0 1 1

Index Scan using users_email_key on users (cost=0.00..9.12 rows=1 width=4) (actual time=0.022..0.025 rows=1 loops=1)

  • Index Cond: ((email)::text = 'mjolkkon@gmail.com'::text)
132. 80.238 86.955 ↓ 159.8 3,676 1

Bitmap Heap Scan on ads (cost=4.63..95.61 rows=23 width=16) (actual time=7.648..86.955 rows=3,676 loops=1)

  • Recheck Cond: (user_id = public.users.user_id)
133. 6.717 6.717 ↓ 159.8 3,676 1

Bitmap Index Scan on index_ads_user_id (cost=0.00..4.62 rows=23 width=0) (actual time=6.717..6.717 rows=3,676 loops=1)

  • Index Cond: (user_id = public.users.user_id)
134. 2,065.912 2,065.912 ↓ 0.0 0 3,676

Index Scan using index_ad_actions_ad_id on ad_actions (cost=0.00..1.88 rows=1 width=12) (actual time=0.562..0.562 rows=0 loops=3,676)

  • Index Cond: (ad_id = blocket_2020.ads.ad_id)
  • Filter: (state = 'refused'::enum_action_states_state)
  • Rows Removed by Filter: 4
135. 0.000 0.000 ↓ 0.0 0

Index Scan using index_action_states_state_ad_id on action_states (cost=0.00..3.47 rows=1 width=12) (never executed)

  • Index Cond: ((state = 'refused'::enum_action_states_state) AND (ad_id = blocket_2020.ads.ad_id))
136. 0.000 0.000 ↓ 0.0 0

Index Scan using index_action_params_ad_id_action_id2 on action_params (cost=0.00..26.82 rows=1 width=8) (never executed)

  • Index Cond: (ad_id = blocket_2020.ads.ad_id)
  • Filter: ((name)::text = 'prev_action_id'::text)
137. 0.001 1,294.962 ↓ 0.0 0 1

Subquery Scan on *SELECT* 13 (cost=616.83..616.85 rows=1 width=0) (actual time=1,294.962..1,294.962 rows=0 loops=1)

138. 0.003 1,294.961 ↓ 0.0 0 1

HashAggregate (cost=616.83..616.84 rows=1 width=16) (actual time=1,294.961..1,294.961 rows=0 loops=1)

139. 0.002 1,294.958 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.00..616.82 rows=1 width=16) (actual time=1,294.958..1,294.958 rows=0 loops=1)

  • Join Filter: (public.action_params.value = (public.ad_actions.action_id)::text)
140. 0.002 1,294.956 ↓ 0.0 0 1

Nested Loop (cost=0.00..571.21 rows=1 width=16) (actual time=1,294.956..1,294.956 rows=0 loops=1)

  • Join Filter: ((public.ad_actions.current_state = public.action_states.state_id) AND (public.ad_actions.action_id = public.action_states.action_id))
141. 14.282 1,294.954 ↓ 0.0 0 1

Nested Loop (cost=0.00..549.89 rows=1 width=24) (actual time=1,294.954..1,294.954 rows=0 loops=1)

142. 12.778 235.280 ↓ 4,506.0 9,012 1

Nested Loop (cost=0.00..516.24 rows=2 width=12) (actual time=0.743..235.280 rows=9,012 loops=1)

143. 0.024 0.024 ↑ 1.0 1 1

Index Scan using users_email_key on users (cost=0.00..9.12 rows=1 width=4) (actual time=0.023..0.024 rows=1 loops=1)

  • Index Cond: ((email)::text = 'mjolkkon@gmail.com'::text)
144. 222.478 222.478 ↓ 73.3 9,012 1

Index Scan using index_ads_user_id on ads (cost=0.00..505.89 rows=123 width=16) (actual time=0.715..222.478 rows=9,012 loops=1)

  • Index Cond: (user_id = public.users.user_id)
145. 1,045.392 1,045.392 ↓ 0.0 0 9,012

Index Scan using index_ad_actions_ad_id_2 on ad_actions (cost=0.00..16.82 rows=1 width=12) (actual time=0.116..0.116 rows=0 loops=9,012)

  • Index Cond: (ad_id = public.ads.ad_id)
  • Filter: ((state)::text = 'refused'::text)
  • Rows Removed by Filter: 3
146. 0.000 0.000 ↓ 0.0 0

Index Scan using index_action_states_ad on action_states (cost=0.00..21.31 rows=1 width=12) (never executed)

  • Index Cond: (ad_id = public.ads.ad_id)
  • Filter: ((state)::text = 'refused'::text)
147. 0.000 0.000 ↓ 0.0 0

Index Scan using index_action_params_ad_id_action_id2 on action_params (cost=0.00..22.80 rows=1 width=8) (never executed)

  • Index Cond: (ad_id = public.ads.ad_id)
  • Filter: ((name)::text = 'prev_action_id'::text)
Total runtime : 116,429.501 ms