explain.depesz.com

PostgreSQL's explain analyze made readable

Result: O4

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

Nested Loop (cost=13,092.70..13,118.61 rows=5 width=610) (actual rows= loops=)

  • Join Filter: ((("outer".contpartener)::character varying(255))::text ~~ (("inner".conts)::text || '%'::text))
2. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=11,823.68..11,824.01 rows=4 width=571) (actual rows= loops=)

  • Hash Cond: (("outer".moneda)::text = ("inner".valuta)::text)
3. 0.000 0.000 ↓ 0.0

Subquery Scan history_decontari1 (cost=11,821.53..11,821.83 rows=4 width=560) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Unique (cost=11,821.53..11,821.79 rows=4 width=759) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Sort (cost=11,821.53..11,821.54 rows=4 width=759) (actual rows= loops=)

  • Sort Key: tip, datdoc, tipdoc, nrdoc, expl, contpartener, valoare, totdecontat, restant, valoareref, totdecontatref, restantref, lastdecont, scadenta, contcoresp, agent, extrainfo, centru, unit, moneda, curs, restantmon, docdec, part_ref, part_pl
6. 0.000 0.000 ↓ 0.0

Append (cost=6,030.50..11,821.49 rows=4 width=759) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Subquery Scan "*SELECT* 1" (cost=6,030.50..6,032.75 rows=1 width=179) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=6,030.50..6,032.74 rows=1 width=179) (actual rows= loops=)

  • Join Filter: (("outer".docdec)::text = ("inner".nrdoc)::text)
  • Filter: (("inner".tipdoc)::text IS NULL)
9.          

Initplan (forNested Loop Left Join)

10. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=5) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
11. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=5) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
12. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=5) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
13. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=7) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
14. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=8) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
15. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=4) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
16. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,067.26..3,069.26 rows=1 width=179) (actual rows= loops=)

  • Hash Cond: (("outer".username)::text = ("inner".username)::text)
17. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,066.16..3,068.13 rows=4 width=189) (actual rows= loops=)

  • Hash Cond: (("outer".centruid)::text = ("inner".centru)::text)
18. 0.000 0.000 ↓ 0.0

Seq Scan on user_centre (cost=0.00..1.62 rows=62 width=20) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Hash (cost=3,066.16..3,066.16 rows=1 width=179) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Seq Scan on notecont (cost=0.00..3,066.16 rows=1 width=179) (actual rows= loops=)

  • Filter: (((CASE WHEN ((($18)::text = 'd'::text) = true) THEN concr ELSE condb END)::text ~~ ($19)::text) AND (datdoc <= $20) AND ((condb)::text !~~ '409%'::text) AND ((concr)::text !~~ '419%'::text) AND ((centru)::text ~~ ($21)::text))
21. 0.000 0.000 ↓ 0.0

Hash (cost=1.09..1.09 rows=1 width=10) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=10) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
23. 0.000 0.000 ↓ 0.0

Subquery Scan history_docs (cost=2,956.70..2,956.89 rows=3 width=64) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Unique (cost=2,956.70..2,956.86 rows=3 width=853) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Sort (cost=2,956.70..2,956.71 rows=3 width=853) (actual rows= loops=)

  • Sort Key: tip, datdoc, tipdoc, nrdoc, expl, contpartener, valoare, a_decontat, valoareref, a_decontatref, scadenta, agent, contcoresp, extrainfo, centru, unit, moneda, curs, part_ref, part_pl
26. 0.000 0.000 ↓ 0.0

Append (cost=113.95..2,956.68 rows=3 width=853) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Subquery Scan "*SELECT* 1" (cost=113.95..116.00 rows=2 width=478) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=113.95..115.98 rows=2 width=478) (actual rows= loops=)

  • Join Filter: ((("outer".tipdoc)::text = ("inner".tipd)::text) AND (("outer".nrdoc)::text = ("inner".nrd)::text))
29.          

Initplan (forNested Loop Left Join)

30. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=7) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
31. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=5) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
32. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=4) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
33. 0.000 0.000 ↓ 0.0

Hash Join (cost=110.68..112.68 rows=2 width=192) (actual rows= loops=)

  • Hash Cond: (("outer".username)::text = ("inner".username)::text)
34. 0.000 0.000 ↓ 0.0

Hash Join (cost=109.59..111.56 rows=4 width=202) (actual rows= loops=)

  • Hash Cond: (("outer".centruid)::text = ("inner".centru)::text)
35. 0.000 0.000 ↓ 0.0

Seq Scan on user_centre (cost=0.00..1.62 rows=62 width=20) (actual rows= loops=)

36. 0.000 0.000 ↓ 0.0

Hash (cost=109.59..109.59 rows=1 width=192) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Seq Scan on arh_history (cost=0.00..109.59 rows=1 width=192) (actual rows= loops=)

  • Filter: (((contpartener)::text ~~ ($30)::text) AND ((tip)::text = (CASE WHEN ((($31)::text = 'd'::text) = true) THEN 'v'::character varying ELSE 'c'::character varying END)::text) AND ((centru)::text ~~ ($32)::text))
38. 0.000 0.000 ↓ 0.0

Hash (cost=1.09..1.09 rows=1 width=10) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=10) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
40. 0.000 0.000 ↓ 0.0

Seq Scan on arh_docs_info (cost=0.00..0.00 rows=1 width=572) (actual rows= loops=)

41. 0.000 0.000 ↓ 0.0

Subquery Scan "*SELECT* 2" (cost=2,834.91..2,840.68 rows=1 width=853) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=2,834.91..2,840.67 rows=1 width=853) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Subquery Scan i (cost=2,834.91..2,834.97 rows=1 width=702) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

HashAggregate (cost=2,834.91..2,834.96 rows=1 width=174) (actual rows= loops=)

45.          

Initplan (forHashAggregate)

46. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=5) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
47. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=5) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
48. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=5) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
49. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=5) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
50. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=5) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
51. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=7) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
52. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=8) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
53. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=4) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
54. 0.000 0.000 ↓ 0.0

Hash Join (cost=2,824.14..2,826.15 rows=1 width=174) (actual rows= loops=)

  • Hash Cond: (("outer".username)::text = ("inner".username)::text)
55. 0.000 0.000 ↓ 0.0

Hash Join (cost=2,823.04..2,825.01 rows=4 width=184) (actual rows= loops=)

  • Hash Cond: (("outer".centruid)::text = ("inner".centru)::text)
56. 0.000 0.000 ↓ 0.0

Seq Scan on user_centre (cost=0.00..1.62 rows=62 width=20) (actual rows= loops=)

57. 0.000 0.000 ↓ 0.0

Hash (cost=2,823.04..2,823.04 rows=1 width=174) (actual rows= loops=)

58. 0.000 0.000 ↓ 0.0

Seq Scan on notecont (cost=0.00..2,823.04 rows=1 width=174) (actual rows= loops=)

  • Filter: (((CASE WHEN ((($26)::text = 'd'::text) = true) THEN condb ELSE concr END)::text ~~ ($27)::text) AND (datdoc <= $28) AND ((centru)::text ~~ ($29)::text))
59. 0.000 0.000 ↓ 0.0

Hash (cost=1.09..1.09 rows=1 width=10) (actual rows= loops=)

60. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=10) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
61. 0.000 0.000 ↓ 0.0

Index Scan using doc on docs_info (cost=0.00..5.68 rows=1 width=166) (actual rows= loops=)

  • Index Cond: ((("outer".tipdoc)::text = (docs_info.tipd)::text) AND (("outer".nrdoc)::text = (docs_info.nrd)::text))
62. 0.000 0.000 ↓ 0.0

Subquery Scan "*SELECT* 2" (cost=5,788.33..5,788.74 rows=3 width=759) (actual rows= loops=)

63. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=5,788.33..5,788.71 rows=3 width=759) (actual rows= loops=)

  • Hash Cond: ((("outer".contpartener)::text = ("inner".contpartener)::text) AND (("outer".nrdoc)::text = ("inner".docdec)::text))
  • Filter: ((abs("outer".valoare) >= 0.01) OR (abs(COALESCE(("inner".decontat)::double precision, 0::double precision)) >= 0.01::double precision) OR (abs(COALESCE("outer".a_decontat, 0::double precision)) >= 0.01::double precision))
64. 0.000 0.000 ↓ 0.0

Subquery Scan history_docs (cost=2,956.70..2,956.89 rows=3 width=544) (actual rows= loops=)

65. 0.000 0.000 ↓ 0.0

Unique (cost=2,956.70..2,956.86 rows=3 width=853) (actual rows= loops=)

66. 0.000 0.000 ↓ 0.0

Sort (cost=2,956.70..2,956.71 rows=3 width=853) (actual rows= loops=)

  • Sort Key: tip, datdoc, tipdoc, nrdoc, expl, contpartener, valoare, a_decontat, valoareref, a_decontatref, scadenta, agent, contcoresp, extrainfo, centru, unit, moneda, curs, part_ref, part_pl
67. 0.000 0.000 ↓ 0.0

Append (cost=113.95..2,956.68 rows=3 width=853) (actual rows= loops=)

68. 0.000 0.000 ↓ 0.0

Subquery Scan "*SELECT* 1" (cost=113.95..116.00 rows=2 width=478) (actual rows= loops=)

69. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=113.95..115.98 rows=2 width=478) (actual rows= loops=)

  • Join Filter: ((("outer".tipdoc)::text = ("inner".tipd)::text) AND (("outer".nrdoc)::text = ("inner".nrd)::text))
70.          

Initplan (forNested Loop Left Join)

71. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=7) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
72. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=5) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
73. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=4) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
74. 0.000 0.000 ↓ 0.0

Hash Join (cost=110.68..112.68 rows=2 width=192) (actual rows= loops=)

  • Hash Cond: (("outer".username)::text = ("inner".username)::text)
75. 0.000 0.000 ↓ 0.0

Hash Join (cost=109.59..111.56 rows=4 width=202) (actual rows= loops=)

  • Hash Cond: (("outer".centruid)::text = ("inner".centru)::text)
76. 0.000 0.000 ↓ 0.0

Seq Scan on user_centre (cost=0.00..1.62 rows=62 width=20) (actual rows= loops=)

77. 0.000 0.000 ↓ 0.0

Hash (cost=109.59..109.59 rows=1 width=192) (actual rows= loops=)

78. 0.000 0.000 ↓ 0.0

Seq Scan on arh_history (cost=0.00..109.59 rows=1 width=192) (actual rows= loops=)

  • Filter: (((contpartener)::text ~~ ($13)::text) AND ((tip)::text = (CASE WHEN ((($14)::text = 'd'::text) = true) THEN 'v'::character varying ELSE 'c'::character varying END)::text) AND ((centru)::text ~~ ($15)::text))
79. 0.000 0.000 ↓ 0.0

Hash (cost=1.09..1.09 rows=1 width=10) (actual rows= loops=)

80. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=10) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
81. 0.000 0.000 ↓ 0.0

Seq Scan on arh_docs_info (cost=0.00..0.00 rows=1 width=572) (actual rows= loops=)

82. 0.000 0.000 ↓ 0.0

Subquery Scan "*SELECT* 2" (cost=2,834.91..2,840.68 rows=1 width=853) (actual rows= loops=)

83. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=2,834.91..2,840.67 rows=1 width=853) (actual rows= loops=)

84. 0.000 0.000 ↓ 0.0

Subquery Scan i (cost=2,834.91..2,834.97 rows=1 width=702) (actual rows= loops=)

85. 0.000 0.000 ↓ 0.0

HashAggregate (cost=2,834.91..2,834.96 rows=1 width=174) (actual rows= loops=)

86.          

Initplan (forHashAggregate)

87. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=5) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
88. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=5) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
89. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=5) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
90. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=5) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
91. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=5) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
92. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=7) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
93. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=8) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
94. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=4) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
95. 0.000 0.000 ↓ 0.0

Hash Join (cost=2,824.14..2,826.15 rows=1 width=174) (actual rows= loops=)

  • Hash Cond: (("outer".username)::text = ("inner".username)::text)
96. 0.000 0.000 ↓ 0.0

Hash Join (cost=2,823.04..2,825.01 rows=4 width=184) (actual rows= loops=)

  • Hash Cond: (("outer".centruid)::text = ("inner".centru)::text)
97. 0.000 0.000 ↓ 0.0

Seq Scan on user_centre (cost=0.00..1.62 rows=62 width=20) (actual rows= loops=)

98. 0.000 0.000 ↓ 0.0

Hash (cost=2,823.04..2,823.04 rows=1 width=174) (actual rows= loops=)

99. 0.000 0.000 ↓ 0.0

Seq Scan on notecont (cost=0.00..2,823.04 rows=1 width=174) (actual rows= loops=)

  • Filter: (((CASE WHEN ((($9)::text = 'd'::text) = true) THEN condb ELSE concr END)::text ~~ ($10)::text) AND (datdoc <= $11) AND ((centru)::text ~~ ($12)::text))
100. 0.000 0.000 ↓ 0.0

Hash (cost=1.09..1.09 rows=1 width=10) (actual rows= loops=)

101. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=10) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
102. 0.000 0.000 ↓ 0.0

Index Scan using doc on docs_info (cost=0.00..5.68 rows=1 width=166) (actual rows= loops=)

  • Index Cond: ((("outer".tipdoc)::text = (docs_info.tipd)::text) AND (("outer".nrdoc)::text = (docs_info.nrd)::text))
103. 0.000 0.000 ↓ 0.0

Hash (cost=2,831.63..2,831.63 rows=1 width=247) (actual rows= loops=)

104. 0.000 0.000 ↓ 0.0

Subquery Scan history_decs (cost=2,831.60..2,831.63 rows=1 width=247) (actual rows= loops=)

105. 0.000 0.000 ↓ 0.0

HashAggregate (cost=2,831.60..2,831.62 rows=1 width=70) (actual rows= loops=)

106.          

Initplan (forHashAggregate)

107. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=5) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
108. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=5) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
109. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=7) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
110. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=8) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
111. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=4) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
112. 0.000 0.000 ↓ 0.0

Hash Join (cost=2,824.14..2,826.14 rows=1 width=70) (actual rows= loops=)

  • Hash Cond: (("outer".username)::text = ("inner".username)::text)
113. 0.000 0.000 ↓ 0.0

Hash Join (cost=2,823.04..2,825.01 rows=4 width=80) (actual rows= loops=)

  • Hash Cond: (("outer".centruid)::text = ("inner".centru)::text)
114. 0.000 0.000 ↓ 0.0

Seq Scan on user_centre (cost=0.00..1.62 rows=62 width=20) (actual rows= loops=)

115. 0.000 0.000 ↓ 0.0

Hash (cost=2,823.04..2,823.04 rows=1 width=81) (actual rows= loops=)

116. 0.000 0.000 ↓ 0.0

Seq Scan on notecont (cost=0.00..2,823.04 rows=1 width=81) (actual rows= loops=)

  • Filter: (((CASE WHEN ((($1)::text = 'd'::text) = true) THEN concr ELSE condb END)::text ~~ ($2)::text) AND (datdoc <= $3) AND ((centru)::text ~~ ($4)::text))
117. 0.000 0.000 ↓ 0.0

Hash (cost=1.09..1.09 rows=1 width=10) (actual rows= loops=)

118. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=10) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
119. 0.000 0.000 ↓ 0.0

Hash (cost=2.15..2.15 rows=1 width=18) (actual rows= loops=)

120. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.09..2.15 rows=1 width=18) (actual rows= loops=)

  • Hash Cond: (("outer".userid)::text = ("inner".username)::text)
121. 0.000 0.000 ↓ 0.0

Seq Scan on mymonede (cost=0.00..1.03 rows=3 width=27) (actual rows= loops=)

122. 0.000 0.000 ↓ 0.0

Hash (cost=1.09..1.09 rows=1 width=10) (actual rows= loops=)

123. 0.000 0.000 ↓ 0.0

Seq Scan on myvars (cost=0.00..1.09 rows=1 width=10) (actual rows= loops=)

  • Filter: (lower((username)::text) = lower((("current_user"())::character varying)::text))
124. 0.000 0.000 ↓ 0.0

Materialize (cost=1,269.02..1,271.14 rows=212 width=46) (actual rows= loops=)

125. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=1,257.07..1,269.02 rows=212 width=46) (actual rows= loops=)

  • Merge Cond: (("outer".conts)::text = "inner"."?column2?")
  • Filter: ("inner"."?column2?" IS NULL)
126. 0.000 0.000 ↓ 0.0

Index Scan using pkps on plancont_sint (cost=0.00..8.24 rows=212 width=46) (actual rows= loops=)

127. 0.000 0.000 ↓ 0.0

Sort (cost=1,257.07..1,257.60 rows=212 width=93) (actual rows= loops=)

  • Sort Key: (ps.conts)::text
128. 0.000 0.000 ↓ 0.0

Subquery Scan ps (cost=1,246.76..1,248.88 rows=212 width=93) (actual rows= loops=)

129. 0.000 0.000 ↓ 0.0

HashAggregate (cost=1,246.76..1,246.76 rows=212 width=7) (actual rows= loops=)

130. 0.000 0.000 ↓ 0.0

Nested Loop (cost=5.12..1,246.20 rows=224 width=7) (actual rows= loops=)

  • Join Filter: ((("outer".conts)::text ~~ (("inner".conts)::text || '%'::text)) AND (("outer".conts)::text <> ("inner".conts)::text))
131. 0.000 0.000 ↓ 0.0

Seq Scan on plancont_sint (cost=0.00..5.12 rows=212 width=7) (actual rows= loops=)

132. 0.000 0.000 ↓ 0.0

Materialize (cost=5.12..7.24 rows=212 width=7) (actual rows= loops=)

133. 0.000 0.000 ↓ 0.0

Seq Scan on plancont_sint ps (cost=0.00..5.12 rows=212 width=7) (actual rows= loops=)