explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OPcY

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 250,966.925 ↑ 1.0 1 1

Aggregate (cost=172,033,587.02..172,033,587.03 rows=1 width=8) (actual time=250,966.925..250,966.925 rows=1 loops=1)

2. 0.026 250,966.921 ↓ 22.0 22 1

GroupAggregate (cost=172,022,654.83..172,033,587.01 rows=1 width=208) (actual time=250,966.894..250,966.921 rows=22 loops=1)

  • Group Key: rp_discount_code_titles.title_1
  • Filter: (CASE WHEN (GROUPING(rp_discount_code_titles.title_1) = 0) THEN 1 ELSE 0 END = 1)
3. 0.297 250,966.895 ↑ 10,264.4 213 1

Sort (cost=172,022,654.83..172,028,120.64 rows=2,186,324 width=32) (actual time=250,966.886..250,966.895 rows=213 loops=1)

  • Sort Key: rp_discount_code_titles.title_1
  • Sort Method: quicksort Memory: 35kB
4. 160.045 250,966.598 ↑ 10,264.4 213 1

Nested Loop (cost=76,172.48..171,732,650.09 rows=2,186,324 width=32) (actual time=7,612.777..250,966.598 rows=213 loops=1)

5. 30.251 227,779.944 ↑ 70.7 154,541 1

Append (cost=76,172.23..7,539,687.40 rows=10,931,622 width=1,259) (actual time=1,946.763..227,779.944 rows=154,541 loops=1)

6. 90.839 227,749.691 ↑ 70.7 154,541 1

Result (cost=76,172.23..7,485,029.24 rows=10,931,621 width=1,259) (actual time=1,946.763..227,749.691 rows=154,541 loops=1)

7. 24.144 227,658.852 ↑ 70.7 154,541 1

Append (cost=76,172.23..7,321,054.92 rows=10,931,621 width=1,251) (actual time=1,946.757..227,658.852 rows=154,541 loops=1)

8. 70.538 227,111.843 ↑ 98.1 110,524 1

Result (cost=76,172.23..6,851,301.53 rows=10,847,505 width=1,251) (actual time=1,946.757..227,111.843 rows=110,524 loops=1)

9. 20.933 227,041.305 ↑ 98.1 110,524 1

Append (cost=76,172.23..6,715,707.71 rows=10,847,505 width=1,247) (actual time=1,946.751..227,041.305 rows=110,524 loops=1)

10. 88.839 225,817.857 ↑ 98.5 110,060 1

Subquery Scan on *SELECT* 1 (cost=76,172.23..6,042,718.50 rows=10,844,060 width=968) (actual time=1,946.750..225,817.857 rows=110,060 loops=1)

11. 120,565.425 225,729.018 ↑ 98.5 110,060 1

Hash Join (cost=76,172.23..5,907,167.75 rows=10,844,060 width=964) (actual time=1,946.745..225,729.018 rows=110,060 loops=1)

  • Hash Cond: (l.shopify_order_id = o.id)
12. 105,008.446 105,008.446 ↑ 1.0 44,979,705 1

Seq Scan on shopify_line_items l (cost=0.00..2,683,171.76 rows=45,061,976 width=219) (actual time=0.007..105,008.446 rows=44,979,705 loops=1)

13. 98.359 155.147 ↑ 1.9 44,046 1

Hash (cost=68,633.11..68,633.11 rows=84,090 width=608) (actual time=155.147..155.147 rows=44,046 loops=1)

  • Buckets: 8,192 Batches: 16 Memory Usage: 1,452kB
14. 3.600 56.788 ↑ 1.9 44,046 1

Append (cost=0.00..68,633.11 rows=84,090 width=608) (actual time=0.017..56.788 rows=44,046 loops=1)

15. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on shopify_orders o (cost=0.00..0.00 rows=1 width=644) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((test IS NOT TRUE) AND (created_at >= '2020-05-10 14:00:00'::timestamp without time zone) AND (created_at <= '2020-06-30 13:59:59'::timestamp without time zone) AND (shop_id = 845))
16. 39.615 39.615 ↑ 2.2 33,229 1

Index Scan using shopify_orders_2020_03_06_ix_shop_id_created_at on shopify_orders_2020_03_06 o_1 (cost=0.56..56,574.73 rows=72,531 width=610) (actual time=0.015..39.615 rows=33,229 loops=1)

  • Index Cond: ((shop_id = 845) AND (created_at >= '2020-05-10 14:00:00'::timestamp without time zone) AND (created_at <= '2020-06-30 13:59:59'::timestamp without time zone))
  • Filter: (test IS NOT TRUE)
17. 13.572 13.572 ↑ 1.1 10,817 1

Index Scan using shopify_orders_shopify_orders_2020_06_09_shop_id on shopify_orders_2020_06_09 o_2 (cost=0.43..11,637.92 rows=11,558 width=593) (actual time=0.032..13.572 rows=10,817 loops=1)

  • Index Cond: (shop_id = 845)
  • Filter: ((test IS NOT TRUE) AND (created_at >= '2020-05-10 14:00:00'::timestamp without time zone) AND (created_at <= '2020-06-30 13:59:59'::timestamp without time zone))
  • Rows Removed by Filter: 317
18. 0.845 1,202.515 ↑ 7.4 464 1

Subquery Scan on *SELECT* 2 (cost=3,642.52..618,751.69 rows=3,445 width=1,069) (actual time=35.681..1,202.515 rows=464 loops=1)

19. 2.290 1,201.670 ↑ 7.4 464 1

Nested Loop (cost=3,642.52..618,656.95 rows=3,445 width=1,041) (actual time=35.672..1,201.670 rows=464 loops=1)

20. 0.000 1,176.180 ↑ 7.4 464 1

Nested Loop (cost=3,642.52..535,193.96 rows=3,445 width=176) (actual time=35.539..1,176.180 rows=464 loops=1)

21. 114.917 135.088 ↑ 1.0 216,502 1

Bitmap Heap Scan on shopify_refund_line_items rl (cost=3,641.96..42,282.83 rows=217,125 width=36) (actual time=23.293..135.088 rows=216,502 loops=1)

  • Recheck Cond: ((created_at >= '2020-05-10 14:00:00'::timestamp without time zone) AND (created_at <= '2020-06-30 13:59:59'::timestamp without time zone))
  • Heap Blocks: exact=19,224
22. 20.171 20.171 ↓ 1.0 219,234 1

Bitmap Index Scan on ix_sv_created_at (cost=0.00..3,587.68 rows=217,125 width=0) (actual time=20.171..20.171 rows=219,234 loops=1)

  • Index Cond: ((created_at >= '2020-05-10 14:00:00'::timestamp without time zone) AND (created_at <= '2020-06-30 13:59:59'::timestamp without time zone))
23. 1,082.510 1,082.510 ↓ 0.0 0 216,502

Index Scan using unique_line_item_id on shopify_line_items l_1 (cost=0.56..2.27 rows=1 width=148) (actual time=0.005..0.005 rows=0 loops=216,502)

  • Index Cond: (id = rl.shopify_line_item_id)
  • Filter: (shop_id = 845)
  • Rows Removed by Filter: 1
24. 6.496 23.200 ↑ 16.0 1 464

Append (cost=0.00..24.05 rows=16 width=83) (actual time=0.047..0.050 rows=1 loops=464)

25. 0.000 0.000 ↓ 0.0 0 464

Seq Scan on shopify_orders o_3 (cost=0.00..0.00 rows=1 width=80) (actual time=0.000..0.000 rows=0 loops=464)

  • Filter: ((test IS NOT TRUE) AND (l_1.shopify_order_id = id))
26. 0.928 0.928 ↓ 0.0 0 464

Index Scan using shopify_orders_2019_01_03_pkey on shopify_orders_2019_01_03 o_4 (cost=0.42..1.58 rows=1 width=83) (actual time=0.002..0.002 rows=0 loops=464)

  • Index Cond: (id = l_1.shopify_order_id)
  • Filter: (test IS NOT TRUE)
27. 0.928 0.928 ↓ 0.0 0 464

Index Scan using shopify_orders_2019_03_06_pkey on shopify_orders_2019_03_06 o_5 (cost=0.43..1.60 rows=1 width=95) (actual time=0.002..0.002 rows=0 loops=464)

  • Index Cond: (id = l_1.shopify_order_id)
  • Filter: (test IS NOT TRUE)
28. 0.928 0.928 ↓ 0.0 0 464

Index Scan using shopify_orders_2019_06_09_pkey on shopify_orders_2019_06_09 o_6 (cost=0.43..1.63 rows=1 width=85) (actual time=0.002..0.002 rows=0 loops=464)

  • Index Cond: (id = l_1.shopify_order_id)
  • Filter: (test IS NOT TRUE)
29. 0.928 0.928 ↓ 0.0 0 464

Index Scan using shopify_orders_2019_09_12_pkey on shopify_orders_2019_09_12 o_7 (cost=0.43..1.64 rows=1 width=82) (actual time=0.002..0.002 rows=0 loops=464)

  • Index Cond: (id = l_1.shopify_order_id)
  • Filter: (test IS NOT TRUE)
30. 0.928 0.928 ↓ 0.0 0 464

Index Scan using shopify_orders_2018_01_06_pkey on shopify_orders_2018_01_06 o_8 (cost=0.42..1.59 rows=1 width=75) (actual time=0.002..0.002 rows=0 loops=464)

  • Index Cond: (id = l_1.shopify_order_id)
  • Filter: (test IS NOT TRUE)
31. 0.928 0.928 ↓ 0.0 0 464

Index Scan using shopify_orders_2018_06_12_pkey on shopify_orders_2018_06_12 o_9 (cost=0.43..1.61 rows=1 width=79) (actual time=0.002..0.002 rows=0 loops=464)

  • Index Cond: (id = l_1.shopify_order_id)
  • Filter: (test IS NOT TRUE)
32. 0.928 0.928 ↓ 0.0 0 464

Index Scan using shopify_orders_2017_01_06_pkey on shopify_orders_2017_01_06 o_10 (cost=0.42..1.57 rows=1 width=72) (actual time=0.002..0.002 rows=0 loops=464)

  • Index Cond: (id = l_1.shopify_order_id)
  • Filter: (test IS NOT TRUE)
33. 0.928 0.928 ↓ 0.0 0 464

Index Scan using shopify_orders_2017_06_12_pkey on shopify_orders_2017_06_12 o_11 (cost=0.43..1.59 rows=1 width=73) (actual time=0.002..0.002 rows=0 loops=464)

  • Index Cond: (id = l_1.shopify_order_id)
  • Filter: (test IS NOT TRUE)
34. 0.928 0.928 ↓ 0.0 0 464

Index Scan using shopify_orders_2016_01_12_pkey on shopify_orders_2016_01_12 o_12 (cost=0.42..1.57 rows=1 width=71) (actual time=0.002..0.002 rows=0 loops=464)

  • Index Cond: (id = l_1.shopify_order_id)
  • Filter: (test IS NOT TRUE)
35. 0.928 0.928 ↓ 0.0 0 464

Index Scan using shopify_orders_2015_01_12_pkey on shopify_orders_2015_01_12 o_13 (cost=0.42..1.56 rows=1 width=71) (actual time=0.002..0.002 rows=0 loops=464)

  • Index Cond: (id = l_1.shopify_order_id)
  • Filter: (test IS NOT TRUE)
36. 0.928 0.928 ↓ 0.0 0 464

Index Scan using shopify_orders_2014_01_12_pkey on shopify_orders_2014_01_12 o_14 (cost=0.41..1.56 rows=1 width=70) (actual time=0.002..0.002 rows=0 loops=464)

  • Index Cond: (id = l_1.shopify_order_id)
  • Filter: (test IS NOT TRUE)
37. 0.928 0.928 ↓ 0.0 0 464

Index Scan using shopify_orders_2013_pkey on shopify_orders_2013 o_15 (cost=0.41..1.56 rows=1 width=70) (actual time=0.002..0.002 rows=0 loops=464)

  • Index Cond: (id = l_1.shopify_order_id)
  • Filter: (test IS NOT TRUE)
38. 0.928 0.928 ↓ 0.0 0 464

Index Scan using shopify_orders_shopify_orders_2020_01_03_pkey on shopify_orders_2020_01_03 o_16 (cost=0.43..1.63 rows=1 width=83) (actual time=0.002..0.002 rows=0 loops=464)

  • Index Cond: (id = l_1.shopify_order_id)
  • Filter: (test IS NOT TRUE)
39. 2.320 2.320 ↑ 1.0 1 464

Index Scan using shopify_orders_2020_03_06_pkey on shopify_orders_2020_03_06 o_17 (cost=0.43..1.65 rows=1 width=86) (actual time=0.005..0.005 rows=1 loops=464)

  • Index Cond: (id = l_1.shopify_order_id)
  • Filter: (test IS NOT TRUE)
40. 2.320 2.320 ↓ 0.0 0 464

Index Scan using shopify_orders_shopify_orders_2020_06_09_pkey on shopify_orders_2020_06_09 o_18 (cost=0.43..1.60 rows=1 width=83) (actual time=0.005..0.005 rows=0 loops=464)

  • Index Cond: (id = l_1.shopify_order_id)
  • Filter: (test IS NOT TRUE)
41. 0.177 5.108 ↓ 5.1 132 1

Subquery Scan on *SELECT* 3 (cost=0.42..1,110.83 rows=26 width=1,157) (actual time=0.123..5.108 rows=132 loops=1)

42. 0.459 4.931 ↓ 5.1 132 1

Nested Loop (cost=0.42..1,110.05 rows=26 width=1,125) (actual time=0.116..4.931 rows=132 loops=1)

43. 0.248 0.248 ↓ 5.1 132 1

Index Scan using index_shopify_order_adjustments_on_shop_id on shopify_order_adjustments a (cost=0.42..151.10 rows=26 width=48) (actual time=0.016..0.248 rows=132 loops=1)

  • Index Cond: (shop_id = 845)
  • Filter: ((created_at >= '2020-05-10 14:00:00'::timestamp without time zone) AND (created_at <= '2020-06-30 13:59:59'::timestamp without time zone))
  • Rows Removed by Filter: 40
44. 0.924 4.224 ↑ 16.0 1 132

Append (cost=0.00..36.72 rows=16 width=83) (actual time=0.030..0.032 rows=1 loops=132)

45. 0.000 0.000 ↓ 0.0 0 132

Seq Scan on shopify_orders o_19 (cost=0.00..0.00 rows=1 width=80) (actual time=0.000..0.000 rows=0 loops=132)

  • Filter: ((test IS NOT TRUE) AND (a.shopify_order_id = id))
46. 0.264 0.264 ↓ 0.0 0 132

Index Scan using shopify_orders_2019_01_03_pkey on shopify_orders_2019_01_03 o_20 (cost=0.42..2.44 rows=1 width=83) (actual time=0.002..0.002 rows=0 loops=132)

  • Index Cond: (id = a.shopify_order_id)
  • Filter: (test IS NOT TRUE)
47. 0.264 0.264 ↓ 0.0 0 132

Index Scan using shopify_orders_2019_03_06_pkey on shopify_orders_2019_03_06 o_21 (cost=0.43..2.45 rows=1 width=95) (actual time=0.002..0.002 rows=0 loops=132)

  • Index Cond: (id = a.shopify_order_id)
  • Filter: (test IS NOT TRUE)
48. 0.132 0.132 ↓ 0.0 0 132

Index Scan using shopify_orders_2019_06_09_pkey on shopify_orders_2019_06_09 o_22 (cost=0.43..2.45 rows=1 width=85) (actual time=0.001..0.001 rows=0 loops=132)

  • Index Cond: (id = a.shopify_order_id)
  • Filter: (test IS NOT TRUE)
49. 0.132 0.132 ↓ 0.0 0 132

Index Scan using shopify_orders_2019_09_12_pkey on shopify_orders_2019_09_12 o_23 (cost=0.43..2.45 rows=1 width=82) (actual time=0.001..0.001 rows=0 loops=132)

  • Index Cond: (id = a.shopify_order_id)
  • Filter: (test IS NOT TRUE)
50. 0.132 0.132 ↓ 0.0 0 132

Index Scan using shopify_orders_2018_01_06_pkey on shopify_orders_2018_01_06 o_24 (cost=0.42..2.44 rows=1 width=75) (actual time=0.001..0.001 rows=0 loops=132)

  • Index Cond: (id = a.shopify_order_id)
  • Filter: (test IS NOT TRUE)
51. 0.132 0.132 ↓ 0.0 0 132

Index Scan using shopify_orders_2018_06_12_pkey on shopify_orders_2018_06_12 o_25 (cost=0.43..2.45 rows=1 width=79) (actual time=0.001..0.001 rows=0 loops=132)

  • Index Cond: (id = a.shopify_order_id)
  • Filter: (test IS NOT TRUE)
52. 0.264 0.264 ↓ 0.0 0 132

Index Scan using shopify_orders_2017_01_06_pkey on shopify_orders_2017_01_06 o_26 (cost=0.42..2.44 rows=1 width=72) (actual time=0.002..0.002 rows=0 loops=132)

  • Index Cond: (id = a.shopify_order_id)
  • Filter: (test IS NOT TRUE)
53. 0.132 0.132 ↓ 0.0 0 132

Index Scan using shopify_orders_2017_06_12_pkey on shopify_orders_2017_06_12 o_27 (cost=0.43..2.45 rows=1 width=73) (actual time=0.001..0.001 rows=0 loops=132)

  • Index Cond: (id = a.shopify_order_id)
  • Filter: (test IS NOT TRUE)
54. 0.132 0.132 ↓ 0.0 0 132

Index Scan using shopify_orders_2016_01_12_pkey on shopify_orders_2016_01_12 o_28 (cost=0.42..2.44 rows=1 width=71) (actual time=0.001..0.001 rows=0 loops=132)

  • Index Cond: (id = a.shopify_order_id)
  • Filter: (test IS NOT TRUE)
55. 0.132 0.132 ↓ 0.0 0 132

Index Scan using shopify_orders_2015_01_12_pkey on shopify_orders_2015_01_12 o_29 (cost=0.42..2.44 rows=1 width=71) (actual time=0.001..0.001 rows=0 loops=132)

  • Index Cond: (id = a.shopify_order_id)
  • Filter: (test IS NOT TRUE)
56. 0.132 0.132 ↓ 0.0 0 132

Index Scan using shopify_orders_2014_01_12_pkey on shopify_orders_2014_01_12 o_30 (cost=0.41..2.43 rows=1 width=70) (actual time=0.001..0.001 rows=0 loops=132)

  • Index Cond: (id = a.shopify_order_id)
  • Filter: (test IS NOT TRUE)
57. 0.132 0.132 ↓ 0.0 0 132

Index Scan using shopify_orders_2013_pkey on shopify_orders_2013 o_31 (cost=0.41..2.43 rows=1 width=70) (actual time=0.001..0.001 rows=0 loops=132)

  • Index Cond: (id = a.shopify_order_id)
  • Filter: (test IS NOT TRUE)
58. 0.264 0.264 ↓ 0.0 0 132

Index Scan using shopify_orders_shopify_orders_2020_01_03_pkey on shopify_orders_2020_01_03 o_32 (cost=0.43..2.45 rows=1 width=83) (actual time=0.002..0.002 rows=0 loops=132)

  • Index Cond: (id = a.shopify_order_id)
  • Filter: (test IS NOT TRUE)
59. 0.528 0.528 ↓ 0.0 0 132

Index Scan using shopify_orders_2020_03_06_pkey on shopify_orders_2020_03_06 o_33 (cost=0.43..2.45 rows=1 width=86) (actual time=0.004..0.004 rows=0 loops=132)

  • Index Cond: (id = a.shopify_order_id)
  • Filter: (test IS NOT TRUE)
60. 0.528 0.528 ↑ 1.0 1 132

Index Scan using shopify_orders_shopify_orders_2020_06_09_pkey on shopify_orders_2020_06_09 o_34 (cost=0.43..2.45 rows=1 width=83) (actual time=0.004..0.004 rows=1 loops=132)

  • Index Cond: (id = a.shopify_order_id)
  • Filter: (test IS NOT TRUE)
61. 53.082 517.757 ↑ 1.9 43,885 1

Subquery Scan on *SELECT* 4 (cost=408,728.84..413,984.46 rows=84,090 width=1,160) (actual time=332.867..517.757 rows=43,885 loops=1)

62. 107.668 464.675 ↑ 1.9 43,885 1

GroupAggregate (cost=408,728.84..411,041.31 rows=84,090 width=1,120) (actual time=332.861..464.675 rows=43,885 loops=1)

  • Group Key: o_35.id
63. 60.542 357.007 ↑ 1.9 43,885 1

Sort (cost=408,728.84..408,939.06 rows=84,090 width=118) (actual time=332.844..357.007 rows=43,885 loops=1)

  • Sort Key: o_35.id
  • Sort Method: external merge Disk: 5,784kB
64. 12.413 296.465 ↑ 1.9 43,885 1

Nested Loop Left Join (cost=0.87..398,892.43 rows=84,090 width=118) (actual time=0.568..296.465 rows=43,885 loops=1)

65. 40.731 196.282 ↑ 1.9 43,885 1

Nested Loop (cost=0.43..238,182.73 rows=84,090 width=118) (actual time=0.560..196.282 rows=43,885 loops=1)

66. 5.589 67.459 ↑ 1.9 44,046 1

Append (cost=0.00..68,633.11 rows=84,090 width=102) (actual time=0.549..67.459 rows=44,046 loops=1)

67. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on shopify_orders o_35 (cost=0.00..0.00 rows=1 width=96) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((test IS NOT TRUE) AND (created_at >= '2020-05-10 14:00:00'::timestamp without time zone) AND (created_at <= '2020-06-30 13:59:59'::timestamp without time zone) AND (shop_id = 845))
68. 48.240 48.240 ↑ 2.2 33,229 1

Index Scan using shopify_orders_2020_03_06_ix_shop_id_created_at on shopify_orders_2020_03_06 o_36 (cost=0.56..56,574.73 rows=72,531 width=102) (actual time=0.547..48.240 rows=33,229 loops=1)

  • Index Cond: ((shop_id = 845) AND (created_at >= '2020-05-10 14:00:00'::timestamp without time zone) AND (created_at <= '2020-06-30 13:59:59'::timestamp without time zone))
  • Filter: (test IS NOT TRUE)
69. 13.629 13.629 ↑ 1.1 10,817 1

Index Scan using shopify_orders_shopify_orders_2020_06_09_shop_id on shopify_orders_2020_06_09 o_37 (cost=0.43..11,637.92 rows=11,558 width=99) (actual time=0.028..13.629 rows=10,817 loops=1)

  • Index Cond: (shop_id = 845)
  • Filter: ((test IS NOT TRUE) AND (created_at >= '2020-05-10 14:00:00'::timestamp without time zone) AND (created_at <= '2020-06-30 13:59:59'::timestamp without time zone))
  • Rows Removed by Filter: 317
70. 88.092 88.092 ↑ 1.0 1 44,046

Index Scan using index_shopify_shipping_lines_on_shopify_order_id on shopify_shipping_lines sl (cost=0.43..2.01 rows=1 width=24) (actual time=0.002..0.002 rows=1 loops=44,046)

  • Index Cond: (shopify_order_id = o_35.id)
71. 87.770 87.770 ↓ 0.0 0 43,885

Index Scan using index_shopify_shipping_tax_lines_on_shopify_shipping_line_id on shopify_shipping_tax_lines s (cost=0.43..1.87 rows=4 width=16) (actual time=0.002..0.002 rows=0 loops=43,885)

  • Index Cond: (sl.id = shopify_shipping_line_id)
72. 0.000 0.002 ↓ 0.0 0 1

Subquery Scan on *SELECT* 5 (cost=0.00..0.05 rows=1 width=1,164) (actual time=0.002..0.002 rows=0 loops=1)

73. 0.001 0.002 ↓ 0.0 0 1

HashAggregate (cost=0.00..0.01 rows=1 width=1,112) (actual time=0.002..0.002 rows=0 loops=1)

  • Group Key: id
74. 0.001 0.001 ↓ 0.0 0 1

Result (cost=0.00..0.00 rows=0 width=105) (actual time=0.001..0.001 rows=0 loops=1)

  • One-Time Filter: false
75. 23,026.609 23,026.609 ↓ 0.0 0 154,541

Function Scan on rp_discount_code_titles (cost=0.25..15.25 rows=1 width=40) (actual time=0.149..0.149 rows=0 loops=154,541)

  • Filter: (((title_1)::text ~* '(tw5)'::text) AND ("*SELECT* 1".id = shopify_order_id))
  • Rows Removed by Filter: 0
Planning time : 9.426 ms
Execution time : 250,989.504 ms