explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ogde

Settings
# exclusive inclusive rows x rows loops node
1. 157.047 367,859.280 ↑ 1.2 201 1

GroupAggregate (cost=3,050,334.26..9,132,724.14 rows=238 width=2,632) (actual time=360,558.714..367,859.280 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))
  • JIT:
  • Functions: 779
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 105.894 ms, Inlining 87.285 ms, Optimization 7042.930 ms, Emission 4775.492 ms, Total 12011.601 ms
2. 87.344 360,527.337 ↓ 91.5 21,781 1

Sort (cost=3,050,334.26..3,050,334.86 rows=238 width=221) (actual time=360,518.503..360,527.337 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,624kB
3. 331.066 360,439.993 ↓ 91.5 21,781 1

Hash Left Join (cost=20,880.38..3,050,324.87 rows=238 width=221) (actual time=12,222.853..360,439.993 rows=21,781 loops=1)

  • Hash Cond: (orders.order_actions_id = order_actions.id)
4. 9.441 12,270.060 ↓ 91.5 21,781 1

Hash Left Join (cost=685.51..2,562.44 rows=238 width=99) (actual time=11,921.980..12,270.060 rows=21,781 loops=1)

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

Hash Left Join (cost=683.77..2,557.43 rows=238 width=99) (actual time=11,921.895..12,260.582 rows=21,781 loops=1)

  • Hash Cond: (orders.project_id = projects.id)
6. 12.002 12,251.822 ↓ 91.5 21,781 1

Nested Loop (cost=681.87..2,554.83 rows=238 width=99) (actual time=11,921.748..12,251.822 rows=21,781 loops=1)

7. 0.207 11,910.988 ↓ 28.0 56 1

Nested Loop (cost=4.28..12.45 rows=2 width=40) (actual time=11,910.572..11,910.988 rows=56 loops=1)

8. 11,910.367 11,910.367 ↓ 23.0 23 1

Seq Scan on advertiser (cost=0.00..1.27 rows=1 width=36) (actual time=11,910.331..11,910.367 rows=23 loops=1)

  • Filter: (network_id = 1)
9. 0.253 0.414 ↑ 1.0 2 23

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

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

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

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

Bitmap Heap Scan on orders (cost=677.59..1,269.67 rows=152 width=67) (actual time=4.694..5.872 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. 11.144 260.064 ↓ 0.0 0 56

BitmapAnd (cost=677.59..677.59 rows=153 width=0) (actual time=4.644..4.644 rows=0 loops=56)

13. 136.136 136.136 ↓ 7.2 39,945 56

Bitmap Index Scan on orders_timestamp_idx (cost=0.00..127.53 rows=5,510 width=0) (actual time=2.431..2.431 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. 112.784 112.784 ↑ 1.5 24,380 56

Bitmap Index Scan on orders_campaign_id_idx (cost=0.00..548.40 rows=36,806 width=0) (actual time=2.014..2.014 rows=24,380 loops=56)

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

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

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

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

17. 0.010 0.037 ↑ 1.0 33 1

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

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

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

19. 86.228 148.764 ↑ 1.0 474,060 1

Hash (cost=11,490.83..11,490.83 rows=474,083 width=22) (actual time=148.764..148.764 rows=474,060 loops=1)

  • Buckets: 65,536 Batches: 8 Memory Usage: 3,746kB
20. 62.536 62.536 ↑ 1.0 474,060 1

Seq Scan on order_actions (cost=0.00..11,490.83 rows=474,083 width=22) (actual time=0.022..62.536 rows=474,060 loops=1)

21.          

SubPlan (for Hash Left Join)

22. 152.467 347,210.921 ↑ 1.0 1 21,781

Limit (cost=12,676.32..12,684.35 rows=1 width=32) (actual time=15.941..15.941 rows=1 loops=21,781)

23.          

Initplan (for Limit)

24. 65.343 346,862.425 ↑ 1.0 1 21,781

Limit (cost=0.00..12,676.04 rows=1 width=7) (actual time=15.925..15.925 rows=1 loops=21,781)

25. 346,797.082 346,797.082 ↑ 1.0 1 21,781

Seq Scan on order_actions order_actions_1 (cost=0.00..12,676.04 rows=1 width=7) (actual time=15.922..15.922 rows=1 loops=21,781)

  • Filter: (id = orders.order_actions_id)
  • Rows Removed by Filter: 220,897
26. 196.029 196.029 ↑ 1.0 1 21,781

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

  • Index Cond: (id = ($1)::integer)
27. 43.562 479.182 ↑ 1.0 1 21,781

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

28. 196.029 435.620 ↑ 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.020..0.020 rows=1 loops=21,781)

  • Index Cond: ((type = 'pub'::text) AND (id = projects.publisher_id))
  • Heap Fetches: 9,071
29.          

SubPlan (for Index Only Scan)

30. 43.562 152.467 ↑ 1.0 1 21,781

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

31. 108.905 108.905 ↑ 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.005..0.005 rows=1 loops=21,781)

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

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

33. 65.343 65.343 ↑ 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.003..0.003 rows=1 loops=21,781)

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

SubPlan (for GroupAggregate)

35. 1.608 7,169.670 ↑ 1.0 1 201

Limit (cost=12,676.32..12,684.35 rows=1 width=32) (actual time=35.670..35.670 rows=1 loops=201)

36.          

Initplan (for Limit)

37. 0.603 7,166.253 ↑ 1.0 1 201

Limit (cost=0.00..12,676.04 rows=1 width=7) (actual time=35.653..35.653 rows=1 loops=201)

38. 7,165.650 7,165.650 ↑ 1.0 1 201

Seq Scan on order_actions order_actions_2 (cost=0.00..12,676.04 rows=1 width=7) (actual time=35.650..35.650 rows=1 loops=201)

  • Filter: (id = orders.order_actions_id)
  • Rows Removed by Filter: 438,495
39. 1.809 1.809 ↑ 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.009..0.009 rows=1 loops=201)

  • Index Cond: (id = ($6)::integer)
40. 0.603 5.226 ↑ 1.0 1 201

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

41. 2.211 4.623 ↑ 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.023..0.023 rows=1 loops=201)

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

SubPlan (for Index Only Scan)

43. 0.201 1.608 ↑ 1.0 1 201

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

44. 1.407 1.407 ↑ 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.007..0.007 rows=1 loops=201)

  • Index Cond: ((login_id = l_1.id) AND ((key)::text = 'surname'::text) AND ((type)::text = 'pub'::text))
45. 0.201 0.804 ↑ 1.0 1 201

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

46. 0.603 0.603 ↑ 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.003..0.003 rows=1 loops=201)

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

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

48. 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)
49. 0.000 0.000 ↓ 0.0 0

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

50. 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)
51. 0.000 0.000 ↓ 0.0 0

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

52. 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)
53. 0.000 0.000 ↓ 0.0 0

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

54. 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)
55. 0.000 0.000 ↓ 0.0 0

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

56. 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)
57. 0.000 0.000 ↓ 0.0 0

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

58. 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)
59. 0.000 0.000 ↓ 0.0 0

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

60. 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)
61. 0.000 0.000 ↓ 0.0 0

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

62. 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)
63. 0.000 0.000 ↓ 0.0 0

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

64. 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)
65. 0.000 0.000 ↓ 0.0 0

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

66. 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)
67. 0.000 0.000 ↓ 0.0 0

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

68. 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)
69. 0.000 0.000 ↓ 0.0 0

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

70. 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)
71. 0.000 0.000 ↓ 0.0 0

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

72. 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)
73. 0.000 0.000 ↓ 0.0 0

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

74. 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)
75. 0.000 0.000 ↓ 0.0 0

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

76. 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)
77. 0.000 0.000 ↓ 0.0 0

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

78. 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)
79. 0.000 0.000 ↓ 0.0 0

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

80. 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)
81. 0.000 0.000 ↓ 0.0 0

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

82. 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)
83. 0.000 0.000 ↓ 0.0 0

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

84. 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)
85. 0.000 0.000 ↓ 0.0 0

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

86. 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)
87. 0.000 0.000 ↓ 0.0 0

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

88. 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)
89. 0.000 0.000 ↓ 0.0 0

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

90. 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)
91. 0.000 0.000 ↓ 0.0 0

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

92. 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)
93. 0.000 0.000 ↓ 0.0 0

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

94. 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)
95. 0.000 0.000 ↓ 0.0 0

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

96. 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)
97. 0.000 0.000 ↓ 0.0 0

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

98. 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)
99. 0.000 0.000 ↓ 0.0 0

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

100. 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)
101. 0.000 0.000 ↓ 0.0 0

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

102. 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)
103. 0.000 0.000 ↓ 0.0 0

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

104. 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)
105. 0.000 0.000 ↓ 0.0 0

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

106. 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)
107. 0.000 0.000 ↓ 0.0 0

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

108. 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)
109. 0.000 0.000 ↓ 0.0 0

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

110. 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)
111. 0.000 0.000 ↓ 0.0 0

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

112. 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)
113. 0.000 0.000 ↓ 0.0 0

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

114. 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)
115. 0.000 0.000 ↓ 0.0 0

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

116. 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)
117. 0.000 0.000 ↓ 0.0 0

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

118. 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)
119. 0.000 0.000 ↓ 0.0 0

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

120. 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)
121. 0.000 0.000 ↓ 0.0 0

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

122. 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)
123. 0.000 0.000 ↓ 0.0 0

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

124. 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)
125. 0.000 0.000 ↓ 0.0 0

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

126. 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)
127. 0.000 0.000 ↓ 0.0 0

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

128. 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)
129. 0.000 0.000 ↓ 0.0 0

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

130. 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)
131. 0.000 0.000 ↓ 0.0 0

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

132. 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)
133. 0.000 0.000 ↓ 0.0 0

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

134. 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)
135. 0.000 0.000 ↓ 0.0 0

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

136. 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)
137. 0.000 0.000 ↓ 0.0 0

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

138. 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)
139. 0.000 0.000 ↓ 0.0 0

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

140. 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)
141. 0.000 0.000 ↓ 0.0 0

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

142. 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)
143. 0.000 0.000 ↓ 0.0 0

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

144. 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)
145. 0.000 0.000 ↓ 0.0 0

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

146. 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)
147. 0.000 0.000 ↓ 0.0 0

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

148. 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)
149. 0.000 0.000 ↓ 0.0 0

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

150. 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)
151. 0.000 0.000 ↓ 0.0 0

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

152. 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)
153. 0.000 0.000 ↓ 0.0 0

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

154. 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)
155. 0.000 0.000 ↓ 0.0 0

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

156. 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)
157. 0.000 0.000 ↓ 0.0 0

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

158. 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)
159. 0.000 0.000 ↓ 0.0 0

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

160. 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)
161. 0.000 0.000 ↓ 0.0 0

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

162. 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)
163. 0.000 0.000 ↓ 0.0 0

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

164. 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)
165. 0.000 0.000 ↓ 0.0 0

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

166. 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)
167. 0.000 0.000 ↓ 0.0 0

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

168. 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)
169. 0.000 0.000 ↓ 0.0 0

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

170. 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)
171. 0.000 0.000 ↓ 0.0 0

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

172. 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)
173. 0.000 0.000 ↓ 0.0 0

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

174. 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)
175. 0.000 0.000 ↓ 0.0 0

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

176. 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)
177. 0.000 0.000 ↓ 0.0 0

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

178. 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)
179. 0.000 0.000 ↓ 0.0 0

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

180. 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)
181. 0.000 0.000 ↓ 0.0 0

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

182. 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)
183. 0.000 0.000 ↓ 0.0 0

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

184. 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)
185. 0.000 0.000 ↓ 0.0 0

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

186. 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)
187. 0.000 0.000 ↓ 0.0 0

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

188. 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)
189. 0.000 0.000 ↓ 0.0 0

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

190. 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)
191. 0.000 0.000 ↓ 0.0 0

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

192. 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)
193. 0.000 0.000 ↓ 0.0 0

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

194. 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)
195. 0.000 0.000 ↓ 0.0 0

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

196. 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)
197. 0.000 0.000 ↓ 0.0 0

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

198. 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)
199. 0.000 0.000 ↓ 0.0 0

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

200. 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)
201. 0.000 0.000 ↓ 0.0 0

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

202. 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)
203. 0.000 0.000 ↓ 0.0 0

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

204. 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)
205. 0.000 0.000 ↓ 0.0 0

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

206. 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)
207. 0.000 0.000 ↓ 0.0 0

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

208. 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)
209. 0.000 0.000 ↓ 0.0 0

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

210. 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)
211. 0.000 0.000 ↓ 0.0 0

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

212. 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)
213. 0.000 0.000 ↓ 0.0 0

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

214. 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)
215. 0.000 0.000 ↓ 0.0 0

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

216. 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)
217. 0.000 0.000 ↓ 0.0 0

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

218. 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)
219. 0.000 0.000 ↓ 0.0 0

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

220. 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)
221. 0.000 0.000 ↓ 0.0 0

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

222. 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)
223. 0.000 0.000 ↓ 0.0 0

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

224. 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)
225. 0.000 0.000 ↓ 0.0 0

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

226. 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)
227. 0.000 0.000 ↓ 0.0 0

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

228. 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)
229. 0.000 0.000 ↓ 0.0 0

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

230. 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)
231. 0.000 0.000 ↓ 0.0 0

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

232. 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)
233. 0.000 0.000 ↓ 0.0 0

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

234. 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)
235. 0.000 0.000 ↓ 0.0 0

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

236. 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)
237. 0.000 0.000 ↓ 0.0 0

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

238. 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 : 8.947 ms
Execution time : 368,012.823 ms