explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lFH

Settings
# exclusive inclusive rows x rows loops node
1. 264.197 949.710 ↑ 1.2 201 1

GroupAggregate (cost=13,470.90..66,084.37 rows=238 width=2,632) (actual time=677.978..949.710 rows=201 loops=1)

  • Group Key: ((CASE WHEN (('admedia_id'::text = (order_actions.criteria)::text) AND (order_actions.data IS NOT NULL) AND (order_actions.data <> ALL ('{NONE,""}'::text[]))) THEN order_actions.data ELSE '-1234'::text END)::integer), ((SubPlan 2)), (((((advertiser.title)::text || ' (ID: '::text) || (advertiser.id)::text) || ')'::text)), ((orders."timestamp")::date), ((SubPlan 5))
2. 31.422 682.699 ↓ 91.5 21,781 1

Sort (cost=13,470.90..13,471.49 rows=238 width=221) (actual time=677.755..682.699 rows=21,781 loops=1)

  • Sort Key: ((CASE WHEN (('admedia_id'::text = (order_actions.criteria)::text) AND (order_actions.data IS NOT NULL) AND (order_actions.data <> ALL ('{NONE,""}'::text[]))) THEN order_actions.data ELSE '-1234'::text END)::integer),((SubPlan 2)), (((((advertiser.title)::text || ' (ID: '::text) || (advertiser.id)::text) || ')'::text)), ((orders."timestamp")::date), ((SubPlan 5))
  • Sort Method: external merge Disk: 4,616kB
3. 39.948 651.277 ↓ 91.5 21,781 1

Nested Loop Left Join (cost=685.89..13,461.50 rows=238 width=221) (actual time=11.794..651.277 rows=21,781 loops=1)

4. 8.174 349.957 ↓ 91.5 21,781 1

Hash Left Join (cost=685.47..2,562.37 rows=238 width=99) (actual time=11.697..349.957 rows=21,781 loops=1)

  • Hash Cond: ((orders.order_currency)::text = (currencies.currencycode)::text)
5. 7.396 341.761 ↓ 91.5 21,781 1

Hash Left Join (cost=683.73..2,557.35 rows=238 width=99) (actual time=11.661..341.761 rows=21,781 loops=1)

  • Hash Cond: (orders.project_id = projects.id)
6. 10.623 334.340 ↓ 91.5 21,781 1

Nested Loop (cost=681.83..2,554.76 rows=238 width=99) (actual time=11.627..334.340 rows=21,781 loops=1)

7. 0.084 0.317 ↓ 28.0 56 1

Nested Loop (cost=4.28..12.45 rows=2 width=40) (actual time=0.024..0.317 rows=56 loops=1)

8. 0.026 0.026 ↓ 23.0 23 1

Seq Scan on advertiser (cost=0.00..1.27 rows=1 width=36) (actual time=0.009..0.026 rows=23 loops=1)

  • Filter: (network_id = 1)
9. 0.138 0.207 ↑ 1.0 2 23

Bitmap Heap Scan on campaigns (cost=4.28..11.15 rows=2 width=8) (actual time=0.006..0.009 rows=2 loops=23)

  • Recheck Cond: (advertiser_id = advertiser.id)
  • Heap Blocks: exact=37
10. 0.069 0.069 ↑ 1.0 2 23

Bitmap Index Scan on campaigns_advertiser_id_idx (cost=0.00..4.28 rows=2 width=0) (actual time=0.003..0.003 rows=2 loops=23)

  • Index Cond: (advertiser_id = advertiser.id)
11. 58.408 323.400 ↓ 2.6 389 56

Bitmap Heap Scan on orders (cost=677.55..1,269.64 rows=152 width=67) (actual time=4.777..5.775 rows=389 loops=56)

  • Recheck Cond: (("timestamp" >= '2020-09-07 00:00:00+02'::timestamp with time zone) AND ("timestamp" <= '2020-09-08 23:59:59+02'::timestamp with time zone) AND (campaign_id = campaigns.id))
  • Filter: ((((campaign_id)::text || '_'::text) || (trigger_id)::text) <> '29_4'::text)
  • Heap Blocks: exact=10,826
12. 10.976 264.992 ↓ 0.0 0 56

BitmapAnd (cost=677.55..677.55 rows=153 width=0) (actual time=4.732..4.732 rows=0 loops=56)

13. 140.000 140.000 ↓ 7.3 39,945 56

Bitmap Index Scan on orders_timestamp_idx (cost=0.00..127.42 rows=5,499 width=0) (actual time=2.500..2.500 rows=39,945 loops=56)

  • Index Cond: (("timestamp" >= '2020-09-07 00:00:00+02'::timestamp with time zone) AND ("timestamp" <= '2020-09-08 23:59:59+02'::timestamp with time zone))
14. 114.016 114.016 ↑ 1.5 24,302 56

Bitmap Index Scan on orders_campaign_id_idx (cost=0.00..548.48 rows=36,816 width=0) (actual time=2.036..2.036 rows=24,302 loops=56)

  • Index Cond: (campaign_id = campaigns.id)
15. 0.008 0.025 ↑ 1.0 40 1

Hash (cost=1.40..1.40 rows=40 width=8) (actual time=0.025..0.025 rows=40 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
16. 0.017 0.017 ↑ 1.0 40 1

Seq Scan on projects (cost=0.00..1.40 rows=40 width=8) (actual time=0.010..0.017 rows=40 loops=1)

17. 0.006 0.022 ↑ 1.0 33 1

Hash (cost=1.33..1.33 rows=33 width=4) (actual time=0.022..0.022 rows=33 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
18. 0.016 0.016 ↑ 1.0 33 1

Seq Scan on currencies (cost=0.00..1.33 rows=33 width=4) (actual time=0.012..0.016 rows=33 loops=1)

19. 43.562 43.562 ↑ 1.0 1 21,781

Index Scan using order_actions_pkey on order_actions (cost=0.42..4.24 rows=1 width=22) (actual time=0.002..0.002 rows=1 loops=21,781)

  • Index Cond: (id = orders.order_actions_id)
20.          

SubPlan (for Nested Loop Left Join)

21. 21.781 87.124 ↑ 1.0 1 21,781

Limit (cost=8.72..16.75 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=21,781)

22.          

Initplan (for Limit)

23. 21.781 43.562 ↑ 1.0 1 21,781

Limit (cost=0.42..8.44 rows=1 width=7) (actual time=0.002..0.002 rows=1 loops=21,781)

24. 21.781 21.781 ↑ 1.0 1 21,781

Index Scan using order_actions_pkey on order_actions order_actions_1 (cost=0.42..8.44 rows=1 width=7) (actual time=0.001..0.001 rows=1 loops=21,781)

  • Index Cond: (id = orders.order_actions_id)
25. 21.781 21.781 ↑ 1.0 1 21,781

Index Scan using admedia_pkey on admedia (cost=0.28..8.31 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=21,781)

  • Index Cond: (id = ($1)::integer)
26. 0.000 130.686 ↑ 1.0 1 21,781

Limit (cost=0.14..24.78 rows=1 width=32) (actual time=0.006..0.006 rows=1 loops=21,781)

27. 43.562 130.686 ↑ 1.0 1 21,781

Index Only Scan using logins_pkey on logins l (cost=0.14..24.78 rows=1 width=32) (actual time=0.006..0.006 rows=1 loops=21,781)

  • Index Cond: ((type = 'pub'::text) AND (id = projects.publisher_id))
  • Heap Fetches: 21,781
28.          

SubPlan (for Index Only Scan)

29. 21.781 43.562 ↑ 1.0 1 21,781

Limit (cost=0.28..8.30 rows=1 width=9) (actual time=0.002..0.002 rows=1 loops=21,781)

30. 21.781 21.781 ↑ 1.0 1 21,781

Index Scan using login_settings_login_id_key_type_idx on login_settings (cost=0.28..8.30 rows=1 width=9) (actual time=0.001..0.001 rows=1 loops=21,781)

  • Index Cond: ((login_id = l.id) AND ((key)::text = 'surname'::text) AND ((type)::text = 'pub'::text))
31. 0.000 43.562 ↑ 1.0 1 21,781

Limit (cost=0.28..8.30 rows=1 width=9) (actual time=0.002..0.002 rows=1 loops=21,781)

32. 43.562 43.562 ↑ 1.0 1 21,781

Index Scan using login_settings_login_id_key_type_idx on login_settings login_settings_1 (cost=0.28..8.30 rows=1 width=9) (actual time=0.002..0.002 rows=1 loops=21,781)

  • Index Cond: ((login_id = l.id) AND ((key)::text = 'prename'::text) AND ((type)::text = 'pub'::text))
33.          

SubPlan (for GroupAggregate)

34. 0.201 1.407 ↑ 1.0 1 201

Limit (cost=8.72..16.75 rows=1 width=32) (actual time=0.007..0.007 rows=1 loops=201)

35.          

Initplan (for Limit)

36. 0.000 0.804 ↑ 1.0 1 201

Limit (cost=0.42..8.44 rows=1 width=7) (actual time=0.004..0.004 rows=1 loops=201)

37. 0.804 0.804 ↑ 1.0 1 201

Index Scan using order_actions_pkey on order_actions order_actions_2 (cost=0.42..8.44 rows=1 width=7) (actual time=0.004..0.004 rows=1 loops=201)

  • Index Cond: (id = orders.order_actions_id)
38. 0.402 0.402 ↑ 1.0 1 201

Index Scan using admedia_pkey on admedia admedia_1 (cost=0.28..8.31 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=201)

  • Index Cond: (id = ($6)::integer)
39. 0.201 1.407 ↑ 1.0 1 201

Limit (cost=0.14..24.78 rows=1 width=32) (actual time=0.007..0.007 rows=1 loops=201)

40. 0.402 1.206 ↑ 1.0 1 201

Index Only Scan using logins_pkey on logins l_1 (cost=0.14..24.78 rows=1 width=32) (actual time=0.006..0.006 rows=1 loops=201)

  • Index Cond: ((type = 'pub'::text) AND (id = projects.publisher_id))
  • Heap Fetches: 201
41.          

SubPlan (for Index Only Scan)

42. 0.000 0.402 ↑ 1.0 1 201

Limit (cost=0.28..8.30 rows=1 width=9) (actual time=0.002..0.002 rows=1 loops=201)

43. 0.402 0.402 ↑ 1.0 1 201

Index Scan using login_settings_login_id_key_type_idx on login_settings login_settings_2 (cost=0.28..8.30 rows=1 width=9) (actual time=0.002..0.002 rows=1 loops=201)

  • Index Cond: ((login_id = l_1.id) AND ((key)::text = 'surname'::text) AND ((type)::text = 'pub'::text))
44. 0.000 0.402 ↑ 1.0 1 201

Limit (cost=0.28..8.30 rows=1 width=9) (actual time=0.002..0.002 rows=1 loops=201)

45. 0.402 0.402 ↑ 1.0 1 201

Index Scan using login_settings_login_id_key_type_idx on login_settings login_settings_3 (cost=0.28..8.30 rows=1 width=9) (actual time=0.002..0.002 rows=1 loops=201)

  • Index Cond: ((login_id = l_1.id) AND ((key)::text = 'prename'::text) AND ((type)::text = 'pub'::text))
46. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

47. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_96 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
48. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

49. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_95 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
50. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

51. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_94 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
52. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

53. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_93 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
54. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

55. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_91 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
56. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

57. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_92 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
58. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

59. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_89 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
60. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

61. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_90 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
62. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

63. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_87 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
64. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

65. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_88 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
66. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

67. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_85 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
68. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

69. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_86 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
70. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

71. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_84 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
72. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

73. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_83 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
74. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

75. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_82 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
76. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

77. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_81 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
78. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

79. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_80 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
80. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

81. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_79 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
82. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

83. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_78 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
84. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

85. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_77 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
86. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

87. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_75 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
88. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

89. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_76 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
90. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

91. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_73 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
92. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

93. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_74 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
94. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

95. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_71 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
96. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

97. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_72 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
98. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

99. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_69 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
100. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

101. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_70 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
102. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

103. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_68 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
104. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

105. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_67 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
106. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

107. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_66 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
108. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

109. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_65 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
110. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

111. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_64 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
112. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

113. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_63 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
114. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

115. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_62 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
116. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

117. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_61 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
118. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

119. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_59 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
120. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

121. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_60 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
122. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

123. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_57 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
124. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

125. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_58 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
126. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

127. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_55 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
128. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

129. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_56 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
130. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

131. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_53 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
132. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

133. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_54 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
134. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

135. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_52 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
136. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

137. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_51 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
138. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

139. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_50 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
140. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

141. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_49 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
142. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

143. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_48 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
144. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

145. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_47 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
146. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

147. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_46 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
148. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

149. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_45 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
150. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

151. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_43 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
152. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

153. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_44 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
154. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

155. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_41 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
156. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

157. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_42 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
158. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

159. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_39 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
160. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

161. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_40 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
162. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

163. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_37 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
164. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

165. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_38 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
166. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

167. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_36 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
168. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

169. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_35 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
170. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

171. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_34 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
172. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

173. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_33 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
174. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

175. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_32 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
176. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

177. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_31 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
178. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

179. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_30 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
180. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

181. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_29 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
182. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

183. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_27 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
184. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

185. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_28 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
186. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

187. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_25 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
188. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

189. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_26 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
190. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

191. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_23 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
192. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

193. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_24 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
194. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

195. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_21 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
196. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

197. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_22 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
198. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

199. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_20 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
200. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

201. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_19 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
202. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

203. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_18 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
204. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

205. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_17 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
206. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

207. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_16 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
208. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

209. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_15 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
210. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

211. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_14 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
212. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

213. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_13 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
214. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

215. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_11 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
216. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

217. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_12 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
218. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

219. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_9 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
220. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

221. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_10 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
222. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

223. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_7 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
224. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

225. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_8 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
226. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

227. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_5 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
228. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

229. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_6 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
230. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

231. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_4 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
232. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

233. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_3 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
234. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

235. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_2 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
236. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.41 rows=1 width=8) (never executed)

237. 0.000 0.000 ↓ 0.0 0

Seq Scan on currencies currencies_1 (cost=0.00..1.41 rows=1 width=8) (never executed)

  • Filter: ((currencycode)::text = (orders.order_currency)::text)
Planning time : 7.625 ms
Execution time : 952.328 ms