explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AQRL

Settings
# exclusive inclusive rows x rows loops node
1. 16.638 16,081.828 ↑ 1.0 1 1

Aggregate (cost=3,985,592.54..3,985,592.55 rows=1 width=8) (actual time=16,081.827..16,081.828 rows=1 loops=1)

2. 1,385.836 16,065.190 ↑ 21.5 261,870 1

Hash Left Join (cost=719,214.09..3,971,489.56 rows=5,641,189 width=0) (actual time=7,862.438..16,065.190 rows=261,870 loops=1)

  • Hash Cond: (sv.id = sl.shopify_order_id)
3. 32.441 6,823.318 ↑ 20.8 261,870 1

Subquery Scan on sv (cost=1,001.00..2,939,165.34 rows=5,441,063 width=24) (actual time=2.910..6,823.318 rows=261,870 loops=1)

4. 23.375 6,790.877 ↑ 20.8 261,870 1

Append (cost=1,001.00..2,884,754.71 rows=5,441,063 width=1,259) (actual time=2.909..6,790.877 rows=261,870 loops=1)

5. 151.684 6,767.500 ↑ 20.8 261,870 1

Result (cost=1,001.00..2,857,549.34 rows=5,441,062 width=1,259) (actual time=2.909..6,767.500 rows=261,870 loops=1)

6. 19.138 6,615.816 ↑ 20.8 261,870 1

Append (cost=1,001.00..2,775,933.41 rows=5,441,062 width=1,251) (actual time=2.905..6,615.816 rows=261,870 loops=1)

7. 0.000 6,415.261 ↑ 24.2 223,180 1

Gather (cost=1,001.00..2,604,308.26 rows=5,397,431 width=1,251) (actual time=2.905..6,415.261 rows=223,180 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
8. 25.532 6,772.635 ↑ 72.6 74,393 3 / 3

Result (cost=0.99..2,117,539.47 rows=5,397,431 width=1,251) (actual time=205.798..6,772.635 rows=74,393 loops=3)

9. 6.563 6,747.103 ↑ 72.6 74,393 3 / 3

Parallel Append (cost=0.99..2,050,071.58 rows=5,397,431 width=1,247) (actual time=205.795..6,747.103 rows=74,393 loops=3)

10. 0.312 329.039 ↑ 4.3 2,076 1 / 3

Subquery Scan on *SELECT* 2 (cost=4,678.52..398,139.85 rows=8,924 width=1,072) (actual time=617.283..987.118 rows=2,076 loops=1)

11. 1.180 328.727 ↑ 1.8 2,076 1 / 3

Nested Loop (cost=4,678.52..397,916.75 rows=3,718 width=1,048) (actual time=617.277..986.182 rows=2,076 loops=1)

12. 0.000 315.091 ↑ 1.8 2,076 1 / 3

Nested Loop (cost=4,678.52..304,924.81 rows=3,718 width=187) (actual time=617.111..945.273 rows=2,076 loops=1)

13. 30.028 36.384 ↓ 2.4 284,701 1 / 3

Parallel Bitmap Heap Scan on shopify_refund_line_items rl (cost=4,677.96..42,272.43 rows=117,298 width=36) (actual time=22.263..109.153 rows=284,701 loops=1)

  • Recheck Cond: ((created_at >= '2020-01-01 08:00:00'::timestamp without time zone) AND (created_at <= '2020-04-01 06:59:59'::timestamp without time zone))
14. 6.357 6.357 ↓ 1.0 288,552 1 / 3

Bitmap Index Scan on ix_sv_created_at (cost=0.00..4,607.58 rows=281,515 width=0) (actual time=19.070..19.070 rows=288,552 loops=1)

  • Index Cond: ((created_at >= '2020-01-01 08:00:00'::timestamp without time zone) AND (created_at <= '2020-04-01 06:59:59'::timestamp without time zone))
15. 284.701 284.701 ↓ 0.0 0 284,701 / 3

Index Scan using unique_line_item_id on shopify_line_items l (cost=0.56..2.24 rows=1 width=159) (actual time=0.003..0.003 rows=0 loops=284,701)

  • Index Cond: (id = rl.shopify_line_item_id)
  • Filter: (shop_id = 1,951)
  • Rows Removed by Filter: 1
16. 1.384 12.456 ↑ 17.0 1 2,076 / 3

Append (cost=0.00..24.82 rows=17 width=83) (actual time=0.012..0.018 rows=1 loops=2,076)

17. 0.000 0.000 ↓ 0.0 0 2,076 / 3

Seq Scan on shopify_orders o (cost=0.00..0.00 rows=1 width=80) (actual time=0.000..0.000 rows=0 loops=2,076)

  • Filter: ((test IS NOT TRUE) AND (l.shopify_order_id = id))
18. 0.692 0.692 ↓ 0.0 0 2,076 / 3

Index Scan using shopify_orders_2019_01_03_pkey on shopify_orders_2019_01_03 o_1 (cost=0.42..1.60 rows=1 width=83) (actual time=0.001..0.001 rows=0 loops=2,076)

  • Index Cond: (id = l.shopify_order_id)
  • Filter: (test IS NOT TRUE)
19. 0.692 0.692 ↓ 0.0 0 2,076 / 3

Index Scan using shopify_orders_2019_03_06_pkey on shopify_orders_2019_03_06 o_2 (cost=0.43..1.61 rows=1 width=96) (actual time=0.001..0.001 rows=0 loops=2,076)

  • Index Cond: (id = l.shopify_order_id)
  • Filter: (test IS NOT TRUE)
20. 0.692 0.692 ↓ 0.0 0 2,076 / 3

Index Scan using shopify_orders_2019_06_09_pkey on shopify_orders_2019_06_09 o_3 (cost=0.43..1.62 rows=1 width=85) (actual time=0.001..0.001 rows=0 loops=2,076)

  • Index Cond: (id = l.shopify_order_id)
  • Filter: (test IS NOT TRUE)
21. 0.692 0.692 ↓ 0.0 0 2,076 / 3

Index Scan using shopify_orders_2019_09_12_pkey on shopify_orders_2019_09_12 o_4 (cost=0.43..1.63 rows=1 width=82) (actual time=0.001..0.001 rows=0 loops=2,076)

  • Index Cond: (id = l.shopify_order_id)
  • Filter: (test IS NOT TRUE)
22. 0.692 0.692 ↓ 0.0 0 2,076 / 3

Index Scan using shopify_orders_2018_01_06_pkey on shopify_orders_2018_01_06 o_5 (cost=0.42..1.60 rows=1 width=75) (actual time=0.001..0.001 rows=0 loops=2,076)

  • Index Cond: (id = l.shopify_order_id)
  • Filter: (test IS NOT TRUE)
23. 0.692 0.692 ↓ 0.0 0 2,076 / 3

Index Scan using shopify_orders_2018_06_12_pkey on shopify_orders_2018_06_12 o_6 (cost=0.43..1.61 rows=1 width=79) (actual time=0.001..0.001 rows=0 loops=2,076)

  • Index Cond: (id = l.shopify_order_id)
  • Filter: (test IS NOT TRUE)
24. 0.692 0.692 ↓ 0.0 0 2,076 / 3

Index Scan using shopify_orders_2017_01_06_pkey on shopify_orders_2017_01_06 o_7 (cost=0.42..1.59 rows=1 width=72) (actual time=0.001..0.001 rows=0 loops=2,076)

  • Index Cond: (id = l.shopify_order_id)
  • Filter: (test IS NOT TRUE)
25. 0.692 0.692 ↓ 0.0 0 2,076 / 3

Index Scan using shopify_orders_2017_06_12_pkey on shopify_orders_2017_06_12 o_8 (cost=0.43..1.60 rows=1 width=73) (actual time=0.001..0.001 rows=0 loops=2,076)

  • Index Cond: (id = l.shopify_order_id)
  • Filter: (test IS NOT TRUE)
26. 0.692 0.692 ↓ 0.0 0 2,076 / 3

Index Scan using shopify_orders_2016_01_12_pkey on shopify_orders_2016_01_12 o_9 (cost=0.42..1.59 rows=1 width=70) (actual time=0.001..0.001 rows=0 loops=2,076)

  • Index Cond: (id = l.shopify_order_id)
  • Filter: (test IS NOT TRUE)
27. 0.692 0.692 ↓ 0.0 0 2,076 / 3

Index Scan using shopify_orders_2015_01_12_pkey on shopify_orders_2015_01_12 o_10 (cost=0.42..1.58 rows=1 width=71) (actual time=0.001..0.001 rows=0 loops=2,076)

  • Index Cond: (id = l.shopify_order_id)
  • Filter: (test IS NOT TRUE)
28. 0.692 0.692 ↓ 0.0 0 2,076 / 3

Index Scan using shopify_orders_2014_01_12_pkey on shopify_orders_2014_01_12 o_11 (cost=0.42..1.58 rows=1 width=70) (actual time=0.001..0.001 rows=0 loops=2,076)

  • Index Cond: (id = l.shopify_order_id)
  • Filter: (test IS NOT TRUE)
29. 0.692 0.692 ↓ 0.0 0 2,076 / 3

Index Scan using shopify_orders_2013_pkey on shopify_orders_2013 o_12 (cost=0.42..1.58 rows=1 width=70) (actual time=0.001..0.001 rows=0 loops=2,076)

  • Index Cond: (id = l.shopify_order_id)
  • Filter: (test IS NOT TRUE)
30. 1.384 1.384 ↑ 1.0 1 2,076 / 3

Index Scan using shopify_orders_shopify_orders_2020_01_03_pkey on shopify_orders_2020_01_03 o_13 (cost=0.43..1.62 rows=1 width=83) (actual time=0.002..0.002 rows=1 loops=2,076)

  • Index Cond: (id = l.shopify_order_id)
  • Filter: (test IS NOT TRUE)
31. 0.692 0.692 ↓ 0.0 0 2,076 / 3

Index Scan using shopify_orders_2020_03_06_pkey on shopify_orders_2020_03_06 o_14 (cost=0.43..1.63 rows=1 width=87) (actual time=0.001..0.001 rows=0 loops=2,076)

  • Index Cond: (id = l.shopify_order_id)
  • Filter: (test IS NOT TRUE)
32. 0.692 0.692 ↓ 0.0 0 2,076 / 3

Index Scan using shopify_orders_shopify_orders_2020_06_09_pkey on shopify_orders_2020_06_09 o_15 (cost=0.43..1.62 rows=1 width=84) (actual time=0.001..0.001 rows=0 loops=2,076)

  • Index Cond: (id = l.shopify_order_id)
  • Filter: (test IS NOT TRUE)
33. 0.000 0.000 ↓ 0.0 0 2,076 / 3

Index Scan using shopify_orders_shopify_orders_2020_09_12_pkey on shopify_orders_2020_09_12 o_16 (cost=0.14..0.66 rows=1 width=177) (actual time=0.000..0.000 rows=0 loops=2,076)

  • Index Cond: (id = l.shopify_order_id)
  • Filter: (test IS NOT TRUE)
34. 25.444 6,411.501 ↑ 73.1 73,701 3 / 3

Subquery Scan on *SELECT* 1 (cost=0.99..1,624,944.57 rows=5,388,507 width=1,108) (actual time=0.046..6,411.501 rows=73,701 loops=3)

35. 45.163 6,386.057 ↑ 30.5 73,701 3 / 3

Nested Loop (cost=0.99..1,557,588.23 rows=2,245,211 width=1,104) (actual time=0.043..6,386.057 rows=73,701 loops=3)

36. 1.717 2,090.164 ↑ 1.4 12,881 3 / 3

Parallel Append (cost=0.43..40,045.31 rows=18,040 width=746) (actual time=0.020..2,090.164 rows=12,881 loops=3)

37. 1.980 1.980 ↓ 1.2 4,520 1 / 3

Parallel Index Scan using shopify_orders_2020_03_06_ix_shop_id_created_at on shopify_orders_2020_03_06 o_19 (cost=0.56..7,807.05 rows=3,775 width=615) (actual time=0.028..5.939 rows=4,520 loops=1)

  • Index Cond: ((shop_id = 1,951) AND (created_at >= '2020-01-01 08:00:00'::timestamp without time zone) AND (created_at <= '2020-04-01 06:59:59'::timestamp without time zone))
  • Filter: (test IS NOT TRUE)
38. 2,086.467 2,086.467 ↑ 1.3 11,374 3 / 3

Parallel Index Scan using shopify_orders_2020_01_03_shop_id on shopify_orders_2020_01_03 o_18 (cost=0.43..32,148.06 rows=14,264 width=781) (actual time=0.015..2,086.467 rows=11,374 loops=3)

  • Index Cond: (shop_id = 1,951)
  • Filter: ((test IS NOT TRUE) AND (created_at >= '2020-01-01 08:00:00'::timestamp without time zone) AND (created_at <= '2020-04-01 06:59:59'::timestamp without time zone))
  • Rows Removed by Filter: 8
39. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on shopify_orders o_17 (cost=0.00..0.00 rows=1 width=644) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ((test IS NOT TRUE) AND (created_at >= '2020-01-01 08:00:00'::timestamp without time zone) AND (created_at <= '2020-04-01 06:59:59'::timestamp without time zone) AND (shop_id = 1,951))
40. 4,250.730 4,250.730 ↑ 20.7 6 38,643 / 3

Index Scan using index_shopify_line_items_on_shopify_order_id_2 on shopify_line_items l_1 (cost=0.56..81.33 rows=124 width=222) (actual time=0.097..0.330 rows=6 loops=38,643)

  • Index Cond: (shopify_order_id = o_19.id)
41. 0.000 18.978 ↓ 1.2 397 1

Subquery Scan on *SELECT* 3 (cost=1,048.55..10,258.20 rows=337 width=1,157) (actual time=3.129..18.978 rows=397 loops=1)

42. 4.784 19.014 ↓ 1.2 397 1

Gather (cost=1,048.55..10,248.09 rows=337 width=1,125) (actual time=3.122..19.014 rows=397 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
43. 0.222 14.230 ↑ 1.0 198 2 / 2

Nested Loop (cost=48.55..9,214.39 rows=198 width=1,125) (actual time=0.758..14.230 rows=198 loops=2)

44. 2.748 3.289 ↑ 1.0 198 2 / 2

Parallel Bitmap Heap Scan on shopify_order_adjustments a (cost=48.55..1,966.19 rows=198 width=48) (actual time=0.665..3.289 rows=198 loops=2)

  • Recheck Cond: (shop_id = 1,951)
  • Filter: ((created_at >= '2020-01-01 08:00:00'::timestamp without time zone) AND (created_at <= '2020-04-01 06:59:59'::timestamp without time zone))
  • Rows Removed by Filter: 774
  • Heap Blocks: exact=578
45. 0.540 0.540 ↑ 1.0 1,944 1 / 2

Bitmap Index Scan on index_shopify_order_adjustments_on_shop_id (cost=0.00..48.46 rows=2,005 width=0) (actual time=1.081..1.081 rows=1,944 loops=1)

  • Index Cond: (shop_id = 1,951)
46. 0.993 10.719 ↑ 17.0 1 397 / 2

Append (cost=0.00..36.43 rows=17 width=83) (actual time=0.041..0.054 rows=1 loops=397)

47. 0.000 0.000 ↓ 0.0 0 397 / 2

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

  • Filter: ((test IS NOT TRUE) AND (a.shopify_order_id = id))
48. 0.199 0.199 ↓ 0.0 0 397 / 2

Index Scan using shopify_orders_2019_01_03_pkey on shopify_orders_2019_01_03 o_21 (cost=0.42..2.42 rows=1 width=83) (actual time=0.001..0.001 rows=0 loops=397)

  • Index Cond: (id = a.shopify_order_id)
  • Filter: (test IS NOT TRUE)
49. 0.199 0.199 ↓ 0.0 0 397 / 2

Index Scan using shopify_orders_2019_03_06_pkey on shopify_orders_2019_03_06 o_22 (cost=0.43..2.44 rows=1 width=96) (actual time=0.001..0.001 rows=0 loops=397)

  • Index Cond: (id = a.shopify_order_id)
  • Filter: (test IS NOT TRUE)
50. 0.199 0.199 ↓ 0.0 0 397 / 2

Index Scan using shopify_orders_2019_06_09_pkey on shopify_orders_2019_06_09 o_23 (cost=0.43..2.44 rows=1 width=85) (actual time=0.001..0.001 rows=0 loops=397)

  • Index Cond: (id = a.shopify_order_id)
  • Filter: (test IS NOT TRUE)
51. 0.596 0.596 ↓ 0.0 0 397 / 2

Index Scan using shopify_orders_2019_09_12_pkey on shopify_orders_2019_09_12 o_24 (cost=0.43..2.44 rows=1 width=82) (actual time=0.003..0.003 rows=0 loops=397)

  • Index Cond: (id = a.shopify_order_id)
  • Filter: (test IS NOT TRUE)
52. 0.199 0.199 ↓ 0.0 0 397 / 2

Index Scan using shopify_orders_2018_01_06_pkey on shopify_orders_2018_01_06 o_25 (cost=0.42..2.43 rows=1 width=75) (actual time=0.001..0.001 rows=0 loops=397)

  • Index Cond: (id = a.shopify_order_id)
  • Filter: (test IS NOT TRUE)
53. 0.199 0.199 ↓ 0.0 0 397 / 2

Index Scan using shopify_orders_2018_06_12_pkey on shopify_orders_2018_06_12 o_26 (cost=0.43..2.44 rows=1 width=79) (actual time=0.001..0.001 rows=0 loops=397)

  • Index Cond: (id = a.shopify_order_id)
  • Filter: (test IS NOT TRUE)
54. 0.199 0.199 ↓ 0.0 0 397 / 2

Index Scan using shopify_orders_2017_01_06_pkey on shopify_orders_2017_01_06 o_27 (cost=0.42..2.39 rows=1 width=72) (actual time=0.001..0.001 rows=0 loops=397)

  • Index Cond: (id = a.shopify_order_id)
  • Filter: (test IS NOT TRUE)
55. 0.199 0.199 ↓ 0.0 0 397 / 2

Index Scan using shopify_orders_2017_06_12_pkey on shopify_orders_2017_06_12 o_28 (cost=0.43..2.43 rows=1 width=73) (actual time=0.001..0.001 rows=0 loops=397)

  • Index Cond: (id = a.shopify_order_id)
  • Filter: (test IS NOT TRUE)
56. 0.199 0.199 ↓ 0.0 0 397 / 2

Index Scan using shopify_orders_2016_01_12_pkey on shopify_orders_2016_01_12 o_29 (cost=0.42..2.40 rows=1 width=70) (actual time=0.001..0.001 rows=0 loops=397)

  • Index Cond: (id = a.shopify_order_id)
  • Filter: (test IS NOT TRUE)
57. 0.199 0.199 ↓ 0.0 0 397 / 2

Index Scan using shopify_orders_2015_01_12_pkey on shopify_orders_2015_01_12 o_30 (cost=0.42..2.31 rows=1 width=71) (actual time=0.001..0.001 rows=0 loops=397)

  • Index Cond: (id = a.shopify_order_id)
  • Filter: (test IS NOT TRUE)
58. 0.199 0.199 ↓ 0.0 0 397 / 2

Index Scan using shopify_orders_2014_01_12_pkey on shopify_orders_2014_01_12 o_31 (cost=0.42..2.30 rows=1 width=70) (actual time=0.001..0.001 rows=0 loops=397)

  • Index Cond: (id = a.shopify_order_id)
  • Filter: (test IS NOT TRUE)
59. 0.199 0.199 ↓ 0.0 0 397 / 2

Index Scan using shopify_orders_2013_pkey on shopify_orders_2013 o_32 (cost=0.42..2.29 rows=1 width=70) (actual time=0.001..0.001 rows=0 loops=397)

  • Index Cond: (id = a.shopify_order_id)
  • Filter: (test IS NOT TRUE)
60. 3.176 3.176 ↑ 1.0 1 397 / 2

Index Scan using shopify_orders_shopify_orders_2020_01_03_pkey on shopify_orders_2020_01_03 o_33 (cost=0.43..2.44 rows=1 width=83) (actual time=0.016..0.016 rows=1 loops=397)

  • Index Cond: (id = a.shopify_order_id)
  • Filter: (test IS NOT TRUE)
61. 3.176 3.176 ↓ 0.0 0 397 / 2

Index Scan using shopify_orders_2020_03_06_pkey on shopify_orders_2020_03_06 o_34 (cost=0.43..2.45 rows=1 width=87) (actual time=0.016..0.016 rows=0 loops=397)

  • Index Cond: (id = a.shopify_order_id)
  • Filter: (test IS NOT TRUE)
62. 0.596 0.596 ↓ 0.0 0 397 / 2

Index Scan using shopify_orders_shopify_orders_2020_06_09_pkey on shopify_orders_2020_06_09 o_35 (cost=0.43..2.44 rows=1 width=84) (actual time=0.003..0.003 rows=0 loops=397)

  • Index Cond: (id = a.shopify_order_id)
  • Filter: (test IS NOT TRUE)
63. 0.000 0.000 ↓ 0.0 0 397 / 2

Index Scan using shopify_orders_shopify_orders_2020_09_12_pkey on shopify_orders_2020_09_12 o_36 (cost=0.14..0.29 rows=1 width=177) (actual time=0.000..0.000 rows=0 loops=397)

  • Index Cond: (id = a.shopify_order_id)
  • Filter: (test IS NOT TRUE)
64. 15.240 162.439 ↑ 1.1 38,293 1

Subquery Scan on *SELECT* 4 (cost=126,946.24..134,161.64 rows=43,294 width=1,158) (actual time=102.133..162.439 rows=38,293 loops=1)

65. 27.476 147.199 ↑ 1.1 38,293 1

Finalize GroupAggregate (cost=126,946.24..132,646.35 rows=43,294 width=1,118) (actual time=102.126..147.199 rows=38,293 loops=1)

  • Group Key: o_39.id
66. 14.796 119.723 ↓ 1.0 38,293 1

Gather Merge (cost=126,946.24..131,637.63 rows=37,404 width=116) (actual time=102.111..119.723 rows=38,293 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
67. 6.026 104.927 ↑ 1.5 12,764 3 / 3

Partial GroupAggregate (cost=125,946.21..126,320.25 rows=18,702 width=116) (actual time=96.286..104.927 rows=12,764 loops=3)

  • Group Key: o_39.id
68. 16.313 98.901 ↑ 1.0 17,875 3 / 3

Sort (cost=125,946.21..125,992.97 rows=18,702 width=116) (actual time=96.277..98.901 rows=17,875 loops=3)

  • Sort Key: o_39.id
  • Sort Method: external merge Disk: 3,776kB
  • Worker 0: Sort Method: external merge Disk: 3,184kB
  • Worker 1: Sort Method: external merge Disk: 2,528kB
69. 6.927 82.588 ↑ 1.0 17,875 3 / 3

Nested Loop Left Join (cost=1.30..124,619.22 rows=18,702 width=116) (actual time=0.723..82.588 rows=17,875 loops=3)

70. 6.818 50.132 ↑ 1.5 12,764 3 / 3

Nested Loop (cost=0.86..79,960.27 rows=18,702 width=116) (actual time=0.370..50.132 rows=12,764 loops=3)

71. 1.084 17.552 ↑ 1.4 12,881 3 / 3

Parallel Append (cost=0.43..40,045.31 rows=18,040 width=100) (actual time=0.021..17.552 rows=12,881 loops=3)

72. 1.941 1.941 ↓ 1.2 4,520 1 / 3

Parallel Index Scan using shopify_orders_2020_03_06_ix_shop_id_created_at on shopify_orders_2020_03_06 o_39 (cost=0.56..7,807.05 rows=3,775 width=103) (actual time=0.022..5.823 rows=4,520 loops=1)

  • Index Cond: ((shop_id = 1,951) AND (created_at >= '2020-01-01 08:00:00'::timestamp without time zone) AND (created_at <= '2020-04-01 06:59:59'::timestamp without time zone))
  • Filter: (test IS NOT TRUE)
73. 14.527 14.527 ↑ 1.3 11,374 3 / 3

Parallel Index Scan using shopify_orders_2020_01_03_shop_id on shopify_orders_2020_01_03 o_38 (cost=0.43..32,148.06 rows=14,264 width=99) (actual time=0.017..14.527 rows=11,374 loops=3)

  • Index Cond: (shop_id = 1,951)
  • Filter: ((test IS NOT TRUE) AND (created_at >= '2020-01-01 08:00:00'::timestamp without time zone) AND (created_at <= '2020-04-01 06:59:59'::timestamp without time zone))
  • Rows Removed by Filter: 8
74. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on shopify_orders o_37 (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-01-01 08:00:00'::timestamp without time zone) AND (created_at <= '2020-04-01 06:59:59'::timestamp without time zone) AND (shop_id = 1,951))
75. 25.762 25.762 ↑ 1.0 1 38,643 / 3

Index Scan using index_shopify_shipping_lines_on_shopify_order_id on shopify_shipping_lines sl_1 (cost=0.43..2.20 rows=1 width=24) (actual time=0.002..0.002 rows=1 loops=38,643)

  • Index Cond: (shopify_order_id = o_39.id)
76. 25.529 25.529 ↑ 5.0 1 38,293 / 3

Index Scan using index_shopify_shipping_tax_lines_on_shopify_shipping_line_id on shopify_shipping_tax_lines s (cost=0.43..2.34 rows=5 width=16) (actual time=0.002..0.002 rows=1 loops=38,293)

  • Index Cond: (sl_1.id = shopify_shipping_line_id)
77. 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)

78. 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
79. 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
80. 2,605.013 7,856.036 ↓ 1.0 16,585,936 1

Hash (cost=446,431.43..446,431.43 rows=16,565,733 width=8) (actual time=7,856.036..7,856.036 rows=16,585,936 loops=1)

  • Buckets: 131,072 Batches: 256 Memory Usage: 3,557kB
81. 5,251.023 5,251.023 ↓ 1.0 16,585,936 1

Index Only Scan using index_shopify_shipping_lines_on_shopify_order_id on shopify_shipping_lines sl (cost=0.43..446,431.43 rows=16,565,733 width=8) (actual time=0.010..5,251.023 rows=16,585,936 loops=1)

  • Heap Fetches: 5,988,531
Planning time : 7.300 ms
Execution time : 16,084.549 ms