explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CMTd

Settings
# exclusive inclusive rows x rows loops node
1. 0.069 302,770.446 ↑ 1.0 500 1

Limit (cost=215,799,064.45..215,799,065.70 rows=500 width=1,679) (actual time=302,770.342..302,770.446 rows=500 loops=1)

2. 1,665.159 302,770.377 ↑ 50,227.1 500 1

Sort (cost=215,799,064.45..215,861,848.32 rows=25,113,549 width=1,679) (actual time=302,770.341..302,770.377 rows=500 loops=1)

  • Sort Key: sv.name
  • Sort Method: top-N heapsort Memory: 686kB
3. 165,569.172 301,105.218 ↑ 41.3 607,695 1

Hash Left Join (cost=3,360,304.50..214,296,547.90 rows=25,113,549 width=1,679) (actual time=100,208.933..301,105.218 rows=607,695 loops=1)

  • Hash Cond: (sv.shipping_address_id = sa.id)
4. 8,360.927 115,080.543 ↑ 41.3 607,695 1

Hash Left Join (cost=2,031,251.22..18,674,406.97 rows=25,113,549 width=644) (actual time=79,741.104..115,080.543 rows=607,695 loops=1)

  • Hash Cond: (sv.billing_address_id = ba.id)
5. 2,750.199 85,233.824 ↑ 41.3 607,695 1

Hash Left Join (cost=702,197.94..13,338,410.62 rows=25,113,549 width=568) (actual time=5,239.595..85,233.824 rows=607,695 loops=1)

  • Hash Cond: (sv.id = sl.shopify_order_id)
6. 142.076 77,912.452 ↑ 40.0 607,695 1

Subquery Scan on sv (cost=280,228.51..8,961,583.29 rows=24,321,992 width=543) (actual time=661.479..77,912.452 rows=607,695 loops=1)

7. 53.246 77,770.376 ↑ 40.0 607,695 1

Append (cost=280,228.51..8,718,363.37 rows=24,321,992 width=1,259) (actual time=661.478..77,770.376 rows=607,695 loops=1)

8. 91.457 73,588.923 ↑ 88.3 271,816 1

Result (cost=280,228.51..7,744,054.33 rows=23,989,815 width=1,259) (actual time=661.477..73,588.923 rows=271,816 loops=1)

9. 22.220 73,497.466 ↑ 88.3 271,816 1

Append (cost=280,228.51..7,384,207.11 rows=23,989,815 width=1,251) (actual time=661.473..73,497.466 rows=271,816 loops=1)

10. 82.235 72,657.402 ↑ 91.1 261,057 1

Result (cost=280,228.51..6,785,176.61 rows=23,780,242 width=1,251) (actual time=661.472..72,657.402 rows=261,057 loops=1)

11. 20.842 72,575.167 ↑ 91.1 261,057 1

Append (cost=280,228.51..6,487,923.59 rows=23,780,242 width=1,247) (actual time=661.468..72,575.167 rows=261,057 loops=1)

12. 85.803 63,638.501 ↑ 91.1 254,088 1

Subquery Scan on *SELECT* 1 (cost=280,228.51..4,655,734.34 rows=23,147,660 width=1,003) (actual time=661.468..63,638.501 rows=254,088 loops=1)

13. 27,722.510 63,552.698 ↑ 91.1 254,088 1

Hash Join (cost=280,228.51..4,366,388.59 rows=23,147,660 width=999) (actual time=661.464..63,552.698 rows=254,088 loops=1)

  • Hash Cond: (l.shopify_order_id = o.id)
14. 35,173.973 35,173.973 ↓ 1.0 23,252,828 1

Seq Scan on shopify_line_items l (cost=0.00..2,145,935.60 rows=23,147,660 width=247) (actual time=0.014..35,173.973 rows=23,252,828 loops=1)

15. 408.066 656.215 ↓ 1.0 346,084 1

Hash (cost=249,151.31..249,151.31 rows=332,176 width=640) (actual time=656.214..656.215 rows=346,084 loops=1)

  • Buckets: 8192 Batches: 64 Memory Usage: 3239kB
16. 25.836 248.149 ↓ 1.0 346,084 1

Append (cost=0.00..249,151.31 rows=332,176 width=640) (actual time=0.029..248.149 rows=346,084 loops=1)

17. 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 >= '2019-01-01 08:00:00'::timestamp without time zone) AND (created_at <= '2020-01-01 07:59:59'::timestamp without time zone) AND (shop_id = 868))
18. 41.590 41.590 ↓ 1.0 65,211 1

Index Scan using shopify_orders_2019_01_03_on_shop_id on shopify_orders_2019_01_03 o_1 (cost=0.42..41,557.18 rows=62,564 width=584) (actual time=0.028..41.590 rows=65,211 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: ((test IS NOT TRUE) AND (created_at >= '2019-01-01 08:00:00'::timestamp without time zone) AND (created_at <= '2020-01-01 07:59:59'::timestamp without time zone))
  • Rows Removed by Filter: 195
19. 59.741 59.741 ↓ 1.0 92,949 1

Index Scan using shopify_orders_2019_03_06_on_shop_id on shopify_orders_2019_03_06 o_2 (cost=0.42..63,426.43 rows=90,710 width=617) (actual time=0.024..59.741 rows=92,949 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: ((test IS NOT TRUE) AND (created_at >= '2019-01-01 08:00:00'::timestamp without time zone) AND (created_at <= '2020-01-01 07:59:59'::timestamp without time zone))
20. 48.540 48.540 ↓ 1.0 74,773 1

Index Scan using shopify_orders_2019_06_09_on_shop_id on shopify_orders_2019_06_09 o_3 (cost=0.43..49,345.48 rows=72,081 width=726) (actual time=0.023..48.540 rows=74,773 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: ((test IS NOT TRUE) AND (created_at >= '2019-01-01 08:00:00'::timestamp without time zone) AND (created_at <= '2020-01-01 07:59:59'::timestamp without time zone))
21. 72.233 72.233 ↓ 1.1 112,911 1

Index Scan using shopify_orders_2019_09_12_on_shop_id on shopify_orders_2019_09_12 o_4 (cost=0.43..92,958.59 rows=106,625 width=635) (actual time=0.026..72.233 rows=112,911 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: ((test IS NOT TRUE) AND (created_at >= '2019-01-01 08:00:00'::timestamp without time zone) AND (created_at <= '2020-01-01 07:59:59'::timestamp without time zone))
22. 0.208 0.208 ↓ 1.2 240 1

Index Scan using shopify_orders_2020_01_03_ix_shop_id_created_at on shopify_orders_2020_01_03 o_5 (cost=0.43..202.75 rows=195 width=798) (actual time=0.026..0.208 rows=240 loops=1)

  • Index Cond: ((shop_id = 868) AND (created_at >= '2019-01-01 08:00:00'::timestamp without time zone) AND (created_at <= '2020-01-01 07:59:59'::timestamp without time zone))
  • Filter: (test IS NOT TRUE)
23. 2.919 8,915.824 ↑ 90.8 6,969 1

Subquery Scan on *SELECT* 2 (cost=446,474.09..1,713,288.04 rows=632,582 width=1,120) (actual time=8,504.904..8,915.824 rows=6,969 loops=1)

24. 535.659 8,912.905 ↑ 90.8 6,969 1

Hash Join (cost=446,474.09..1,695,892.03 rows=632,582 width=1,092) (actual time=8,504.892..8,912.905 rows=6,969 loops=1)

  • Hash Cond: (l_1.shopify_order_id = o_6.id)
25. 489.612 7,825.142 ↑ 1.1 557,948 1

Nested Loop (cost=0.44..1,191,800.65 rows=632,582 width=179) (actual time=0.045..7,825.142 rows=557,948 loops=1)

26. 369.549 369.549 ↓ 1.0 633,271 1

Seq Scan on shopify_refund_line_items rl (cost=0.00..42,182.84 rows=632,582 width=44) (actual time=0.025..369.549 rows=633,271 loops=1)

  • Filter: ((created_at >= '2019-01-01 08:00:00'::timestamp without time zone) AND (created_at <= '2020-01-01 07:59:59'::timestamp without time zone))
  • Rows Removed by Filter: 603236
27. 6,965.981 6,965.981 ↑ 1.0 1 633,271

Index Scan using unique_line_item_id on shopify_line_items l_1 (cost=0.44..1.82 rows=1 width=143) (actual time=0.011..0.011 rows=1 loops=633,271)

  • Index Cond: (id = rl.shopify_line_item_id)
28. 185.387 552.104 ↓ 1.0 581,635 1

Hash (cost=431,972.60..431,972.60 rows=575,524 width=75) (actual time=552.104..552.104 rows=581,635 loops=1)

  • Buckets: 65536 Batches: 32 Memory Usage: 2541kB
29. 39.252 366.717 ↓ 1.0 581,635 1

Append (cost=0.00..431,972.60 rows=575,524 width=75) (actual time=0.017..366.717 rows=581,635 loops=1)

30. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on shopify_orders o_6 (cost=0.00..0.00 rows=1 width=71) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((test IS NOT TRUE) AND (shop_id = 868))
31. 34.399 34.399 ↓ 1.0 65,406 1

Index Scan using shopify_orders_2019_01_03_on_shop_id on shopify_orders_2019_01_03 o_7 (cost=0.42..41,237.77 rows=63,008 width=75) (actual time=0.014..34.399 rows=65,406 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: (test IS NOT TRUE)
32. 50.030 50.030 ↓ 1.0 92,949 1

Index Scan using shopify_orders_2019_03_06_on_shop_id on shopify_orders_2019_03_06 o_8 (cost=0.42..62,972.88 rows=90,710 width=76) (actual time=0.024..50.030 rows=92,949 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: (test IS NOT TRUE)
33. 40.263 40.263 ↓ 1.0 74,773 1

Index Scan using shopify_orders_2019_06_09_on_shop_id on shopify_orders_2019_06_09 o_9 (cost=0.43..48,985.05 rows=72,081 width=77) (actual time=0.028..40.263 rows=74,773 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: (test IS NOT TRUE)
34. 59.515 59.515 ↓ 1.1 112,911 1

Index Scan using shopify_orders_2019_09_12_on_shop_id on shopify_orders_2019_09_12 o_10 (cost=0.43..92,425.46 rows=106,625 width=76) (actual time=0.022..59.515 rows=112,911 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: (test IS NOT TRUE)
35. 0.013 0.013 ↓ 0.0 0 1

Index Scan using shopify_orders_2018_01_06_on_shop_id on shopify_orders_2018_01_06 o_11 (cost=0.42..123.72 rows=130 width=68) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: (test IS NOT TRUE)
36. 92.103 92.103 ↑ 1.0 163,301 1

Index Scan using shopify_orders_2018_06_12_on_shop_id on shopify_orders_2018_06_12 o_12 (cost=0.43..111,310.63 rows=164,669 width=72) (actual time=0.020..92.103 rows=163,301 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: (test IS NOT TRUE)
37. 0.013 0.013 ↓ 0.0 0 1

Index Scan using shopify_orders_2017_01_06_on_shop_id on shopify_orders_2017_01_06 o_13 (cost=0.42..48.20 rows=46 width=64) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: (test IS NOT TRUE)
38. 0.009 0.009 ↓ 0.0 0 1

Index Scan using shopify_orders_2017_06_12_on_shop_id on shopify_orders_2017_06_12 o_14 (cost=0.42..100.00 rows=99 width=66) (actual time=0.008..0.009 rows=0 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: (test IS NOT TRUE)
39. 0.009 0.009 ↓ 0.0 0 1

Index Scan using shopify_orders_2016_01_12_on_shop_id on shopify_orders_2016_01_12 o_15 (cost=0.42..42.69 rows=41 width=64) (actual time=0.008..0.009 rows=0 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: (test IS NOT TRUE)
40. 0.009 0.009 ↓ 0.0 0 1

Index Scan using shopify_orders_2015_01_12_on_shop_id on shopify_orders_2015_01_12 o_16 (cost=0.41..5.20 rows=4 width=64) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: (test IS NOT TRUE)
41. 0.008 0.008 ↓ 0.0 0 1

Index Scan using shopify_orders_2014_01_12_ix_shop_id_created_at on shopify_orders_2014_01_12 o_17 (cost=0.29..2.31 rows=1 width=62) (actual time=0.007..0.008 rows=0 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: (test IS NOT TRUE)
42. 0.008 0.008 ↓ 0.0 0 1

Index Scan using shopify_orders_2013_ix_shop_id_created_at on shopify_orders_2013 o_18 (cost=0.41..2.43 rows=1 width=62) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: (test IS NOT TRUE)
43. 36.244 36.244 ↑ 1.0 53,553 1

Index Scan using shopify_orders_2020_01_03_ix_shop_id_created_at on shopify_orders_2020_01_03 o_19 (cost=0.43..51,914.31 rows=55,439 width=75) (actual time=0.016..36.244 rows=53,553 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: (test IS NOT TRUE)
44. 14.840 14.840 ↑ 1.2 18,742 1

Index Scan using shopify_orders_2020_03_06_shop_id on shopify_orders_2020_03_06 o_20 (cost=0.42..19,924.33 rows=22,669 width=79) (actual time=0.020..14.840 rows=18,742 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: (test IS NOT TRUE)
45. 4.664 817.844 ↑ 19.5 10,759 1

Subquery Scan on *SELECT* 3 (cost=19,378.91..479,081.42 rows=209,573 width=1,181) (actual time=207.594..817.844 rows=10,759 loops=1)

46. 250.176 813.180 ↑ 19.5 10,759 1

Hash Join (cost=19,378.91..472,794.23 rows=209,573 width=1,149) (actual time=207.587..813.180 rows=10,759 loops=1)

  • Hash Cond: (o_21.id = a.shopify_order_id)
47. 39.829 356.046 ↓ 1.0 581,635 1

Append (cost=0.00..432,500.37 rows=575,524 width=75) (actual time=0.030..356.046 rows=581,635 loops=1)

48. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on shopify_orders o_21 (cost=0.00..0.00 rows=1 width=71) (actual time=0.004..0.005 rows=0 loops=1)

  • Filter: ((test IS NOT TRUE) AND (shop_id = 868))
49. 34.064 34.064 ↓ 1.0 65,406 1

Index Scan using shopify_orders_2019_01_03_on_shop_id on shopify_orders_2019_01_03 o_22 (cost=0.42..41,602.68 rows=63,008 width=75) (actual time=0.024..34.064 rows=65,406 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: (test IS NOT TRUE)
50. 48.499 48.499 ↓ 1.0 92,949 1

Index Scan using shopify_orders_2019_03_06_on_shop_id on shopify_orders_2019_03_06 o_23 (cost=0.42..62,972.88 rows=90,710 width=76) (actual time=0.021..48.499 rows=92,949 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: (test IS NOT TRUE)
51. 39.215 39.215 ↓ 1.0 74,773 1

Index Scan using shopify_orders_2019_06_09_on_shop_id on shopify_orders_2019_06_09 o_24 (cost=0.43..48,985.05 rows=72,081 width=77) (actual time=0.027..39.215 rows=74,773 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: (test IS NOT TRUE)
52. 57.863 57.863 ↓ 1.1 112,911 1

Index Scan using shopify_orders_2019_09_12_on_shop_id on shopify_orders_2019_09_12 o_25 (cost=0.43..92,425.46 rows=106,625 width=76) (actual time=0.027..57.863 rows=112,911 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: (test IS NOT TRUE)
53. 0.022 0.022 ↓ 0.0 0 1

Index Scan using shopify_orders_2018_01_06_on_shop_id on shopify_orders_2018_01_06 o_26 (cost=0.42..123.72 rows=130 width=68) (actual time=0.022..0.022 rows=0 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: (test IS NOT TRUE)
54. 87.728 87.728 ↑ 1.0 163,301 1

Index Scan using shopify_orders_2018_06_12_on_shop_id on shopify_orders_2018_06_12 o_27 (cost=0.43..111,473.50 rows=164,669 width=72) (actual time=0.019..87.728 rows=163,301 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: (test IS NOT TRUE)
55. 0.019 0.019 ↓ 0.0 0 1

Index Scan using shopify_orders_2017_01_06_on_shop_id on shopify_orders_2017_01_06 o_28 (cost=0.42..48.20 rows=46 width=64) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: (test IS NOT TRUE)
56. 0.008 0.008 ↓ 0.0 0 1

Index Scan using shopify_orders_2017_06_12_on_shop_id on shopify_orders_2017_06_12 o_29 (cost=0.42..100.00 rows=99 width=66) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: (test IS NOT TRUE)
57. 0.013 0.013 ↓ 0.0 0 1

Index Scan using shopify_orders_2016_01_12_on_shop_id on shopify_orders_2016_01_12 o_30 (cost=0.42..42.69 rows=41 width=64) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: (test IS NOT TRUE)
58. 0.007 0.007 ↓ 0.0 0 1

Index Scan using shopify_orders_2015_01_12_on_shop_id on shopify_orders_2015_01_12 o_31 (cost=0.41..5.20 rows=4 width=64) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: (test IS NOT TRUE)
59. 0.007 0.007 ↓ 0.0 0 1

Index Scan using shopify_orders_2014_01_12_ix_shop_id_created_at on shopify_orders_2014_01_12 o_32 (cost=0.29..2.31 rows=1 width=62) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: (test IS NOT TRUE)
60. 0.009 0.009 ↓ 0.0 0 1

Index Scan using shopify_orders_2013_ix_shop_id_created_at on shopify_orders_2013 o_33 (cost=0.41..2.43 rows=1 width=62) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: (test IS NOT TRUE)
61. 35.101 35.101 ↑ 1.0 53,553 1

Index Scan using shopify_orders_2020_01_03_ix_shop_id_created_at on shopify_orders_2020_01_03 o_34 (cost=0.43..51,914.31 rows=55,439 width=75) (actual time=0.014..35.101 rows=53,553 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: (test IS NOT TRUE)
62. 13.657 13.657 ↑ 1.2 18,742 1

Index Scan using shopify_orders_2020_03_06_shop_id on shopify_orders_2020_03_06 o_35 (cost=0.42..19,924.33 rows=22,669 width=79) (actual time=0.023..13.657 rows=18,742 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: (test IS NOT TRUE)
63. 46.073 206.958 ↑ 1.1 191,875 1

Hash (cost=14,712.25..14,712.25 rows=209,573 width=56) (actual time=206.958..206.958 rows=191,875 loops=1)

  • Buckets: 65536 Batches: 8 Memory Usage: 2317kB
64. 160.885 160.885 ↑ 1.1 191,875 1

Seq Scan on shopify_order_adjustments a (cost=0.00..14,712.25 rows=209,573 width=56) (actual time=0.588..160.885 rows=191,875 loops=1)

  • Filter: ((created_at >= '2019-01-01 08:00:00'::timestamp without time zone) AND (created_at <= '2020-01-01 07:59:59'::timestamp without time zone))
  • Rows Removed by Filter: 151437
65. 128.906 4,128.204 ↓ 1.0 335,879 1

Subquery Scan on *SELECT* 4 (cost=831,748.83..852,699.03 rows=332,176 width=1,190) (actual time=3,568.957..4,128.204 rows=335,879 loops=1)

66. 315.373 3,999.298 ↓ 1.0 335,879 1

GroupAggregate (cost=831,748.83..841,072.87 rows=332,176 width=1,150) (actual time=3,568.949..3,999.298 rows=335,879 loops=1)

  • Group Key: o_36.id
67. 507.311 3,683.925 ↓ 1.9 640,856 1

Sort (cost=831,748.83..832,606.30 rows=342,987 width=124) (actual time=3,568.932..3,683.925 rows=640,856 loops=1)

  • Sort Key: o_36.id
  • Sort Method: external merge Disk: 80640kB
68. 1,080.963 3,176.614 ↓ 1.9 640,856 1

Hash Right Join (cost=657,266.15..787,484.96 rows=342,987 width=124) (actual time=1,881.577..3,176.614 rows=640,856 loops=1)

  • Hash Cond: (s.shopify_shipping_line_id = sl_1.id)
69. 771.565 771.565 ↓ 1.0 3,424,984 1

Seq Scan on shopify_shipping_tax_lines s (cost=0.00..77,596.30 rows=3,308,030 width=16) (actual time=0.566..771.565 rows=3,424,984 loops=1)

70. 148.776 1,324.086 ↑ 1.0 335,879 1

Hash (cost=646,613.81..646,613.81 rows=342,987 width=124) (actual time=1,324.086..1,324.086 rows=335,879 loops=1)

  • Buckets: 32768 Batches: 16 Memory Usage: 3324kB
71. 271.159 1,175.310 ↑ 1.0 335,879 1

Nested Loop (cost=0.43..646,613.81 rows=342,987 width=124) (actual time=0.059..1,175.310 rows=335,879 loops=1)

72. 25.323 211.983 ↓ 1.0 346,084 1

Append (cost=0.00..249,511.85 rows=332,176 width=84) (actual time=0.027..211.983 rows=346,084 loops=1)

73. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on shopify_orders o_36 (cost=0.00..0.00 rows=1 width=79) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: ((test IS NOT TRUE) AND (created_at >= '2019-01-01 08:00:00'::timestamp without time zone) AND (created_at <= '2020-01-01 07:59:59'::timestamp without time zone) AND (shop_id = 868))
74. 35.520 35.520 ↓ 1.0 65,211 1

Index Scan using shopify_orders_2019_01_03_on_shop_id on shopify_orders_2019_01_03 o_37 (cost=0.42..41,917.72 rows=62,564 width=83) (actual time=0.021..35.520 rows=65,211 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: ((test IS NOT TRUE) AND (created_at >= '2019-01-01 08:00:00'::timestamp without time zone) AND (created_at <= '2020-01-01 07:59:59'::timestamp without time zone))
  • Rows Removed by Filter: 195
75. 49.783 49.783 ↓ 1.0 92,949 1

Index Scan using shopify_orders_2019_03_06_on_shop_id on shopify_orders_2019_03_06 o_38 (cost=0.42..63,426.43 rows=90,710 width=84) (actual time=0.032..49.783 rows=92,949 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: ((test IS NOT TRUE) AND (created_at >= '2019-01-01 08:00:00'::timestamp without time zone) AND (created_at <= '2020-01-01 07:59:59'::timestamp without time zone))
76. 40.316 40.316 ↓ 1.0 74,773 1

Index Scan using shopify_orders_2019_06_09_on_shop_id on shopify_orders_2019_06_09 o_39 (cost=0.43..49,345.48 rows=72,081 width=85) (actual time=0.019..40.316 rows=74,773 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: ((test IS NOT TRUE) AND (created_at >= '2019-01-01 08:00:00'::timestamp without time zone) AND (created_at <= '2020-01-01 07:59:59'::timestamp without time zone))
77. 60.864 60.864 ↓ 1.1 112,911 1

Index Scan using shopify_orders_2019_09_12_on_shop_id on shopify_orders_2019_09_12 o_40 (cost=0.43..92,958.59 rows=106,625 width=84) (actual time=0.022..60.864 rows=112,911 loops=1)

  • Index Cond: (shop_id = 868)
  • Filter: ((test IS NOT TRUE) AND (created_at >= '2019-01-01 08:00:00'::timestamp without time zone) AND (created_at <= '2020-01-01 07:59:59'::timestamp without time zone))
78. 0.172 0.172 ↓ 1.2 240 1

Index Scan using shopify_orders_2020_01_03_ix_shop_id_created_at on shopify_orders_2020_01_03 o_41 (cost=0.43..202.75 rows=195 width=83) (actual time=0.019..0.172 rows=240 loops=1)

  • Index Cond: ((shop_id = 868) AND (created_at >= '2019-01-01 08:00:00'::timestamp without time zone) AND (created_at <= '2020-01-01 07:59:59'::timestamp without time zone))
  • Filter: (test IS NOT TRUE)
79. 692.168 692.168 ↑ 1.0 1 346,084

Index Scan using index_shopify_shipping_lines_on_shopify_order_id on shopify_shipping_lines sl_1 (cost=0.43..1.19 rows=1 width=48) (actual time=0.002..0.002 rows=1 loops=346,084)

  • Index Cond: (shopify_order_id = o_36.id)
80. 0.000 0.003 ↓ 0.0 0 1

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

81. 0.001 0.003 ↓ 0.0 0 1

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

  • Group Key: id
82. 0.002 0.002 ↓ 0.0 0 1

Result (cost=0.00..0.00 rows=0 width=87) (actual time=0.002..0.002 rows=0 loops=1)

  • One-Time Filter: false
83. 1,637.779 4,571.173 ↓ 1.0 7,358,961 1

Hash (cost=272,933.30..272,933.30 rows=7,337,130 width=33) (actual time=4,571.173..4,571.173 rows=7,358,961 loops=1)

  • Buckets: 65536 Batches: 256 Memory Usage: 2462kB
84. 2,933.394 2,933.394 ↓ 1.0 7,358,963 1

Seq Scan on shopify_shipping_lines sl (cost=0.00..272,933.30 rows=7,337,130 width=33) (actual time=0.011..2,933.394 rows=7,358,963 loops=1)

85. 12,459.654 21,485.792 ↓ 1.0 21,536,910 1

Hash (cost=752,062.68..752,062.68 rows=21,253,168 width=92) (actual time=21,485.792..21,485.792 rows=21,536,910 loops=1)

  • Buckets: 32768 Batches: 1024 Memory Usage: 2948kB
86. 9,026.138 9,026.138 ↓ 1.0 21,536,910 1

Seq Scan on shopify_customer_addresses ba (cost=0.00..752,062.68 rows=21,253,168 width=92) (actual time=0.015..9,026.138 rows=21,536,910 loops=1)

87. 12,480.054 20,455.503 ↓ 1.0 21,536,910 1

Hash (cost=752,062.68..752,062.68 rows=21,253,168 width=91) (actual time=20,455.503..20,455.503 rows=21,536,910 loops=1)

  • Buckets: 32768 Batches: 1024 Memory Usage: 2948kB
88. 7,975.449 7,975.449 ↓ 1.0 21,536,910 1

Seq Scan on shopify_customer_addresses sa (cost=0.00..752,062.68 rows=21,253,168 width=91) (actual time=0.025..7,975.449 rows=21,536,910 loops=1)

Planning time : 19.039 ms