explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rWoG

Settings
# exclusive inclusive rows x rows loops node
1. 0.115 209,410.930 ↑ 1.0 500 1

Limit (cost=24,267,901.98..24,267,903.23 rows=500 width=1,383) (actual time=209,410.767..209,410.930 rows=500 loops=1)

2. 362.389 209,410.815 ↑ 6,103.1 500 1

Sort (cost=24,267,901.98..24,275,530.90 rows=3,051,568 width=1,383) (actual time=209,410.766..209,410.815 rows=500 loops=1)

  • Sort Key: sv.name
  • Sort Method: top-N heapsort Memory: 580kB
3. 80,454.003 209,048.426 ↑ 33.3 91,701 1

Hash Left Join (cost=3,119,856.97..24,085,329.95 rows=3,051,568 width=1,383) (actual time=119,167.548..209,048.426 rows=91,701 loops=1)

  • Hash Cond: (sv.shipping_address_id = sa.id)
4. 7,522.036 97,438.280 ↑ 33.3 91,701 1

Hash Left Join (cost=1,776,437.49..6,482,955.95 rows=3,051,568 width=644) (actual time=87,846.810..97,438.280 rows=91,701 loops=1)

  • Hash Cond: (sv.billing_address_id = ba.id)
5. 2,292.363 56,734.320 ↑ 33.3 91,701 1

Hash Left Join (cost=433,018.01..4,373,487.10 rows=3,051,568 width=568) (actual time=6,422.666..56,734.320 rows=91,701 loops=1)

  • Hash Cond: (sv.id = sl.shopify_order_id)
6. 31.555 48,082.893 ↑ 33.3 91,701 1

Subquery Scan on sv (cost=0.56..3,388,472.37 rows=3,051,568 width=543) (actual time=1.075..48,082.893 rows=91,701 loops=1)

7. 11.902 48,051.338 ↑ 33.3 91,701 1

Append (cost=0.56..3,357,956.69 rows=3,051,568 width=1,259) (actual time=1.073..48,051.338 rows=91,701 loops=1)

8. 31.243 46,122.970 ↑ 47.0 64,384 1

Result (cost=0.56..3,248,077.31 rows=3,027,761 width=1,259) (actual time=1.072..46,122.970 rows=64,384 loops=1)

9. 8.160 46,091.727 ↑ 47.0 64,384 1

Append (cost=0.56..3,202,660.89 rows=3,027,761 width=1,251) (actual time=1.068..46,091.727 rows=64,384 loops=1)

10. 30.498 45,342.494 ↑ 47.6 62,837 1

Result (cost=0.56..3,121,736.77 rows=2,993,329 width=1,251) (actual time=1.068..45,342.494 rows=62,837 loops=1)

11. 8.030 45,311.996 ↑ 47.6 62,837 1

Append (cost=0.56..3,084,320.16 rows=2,993,329 width=1,247) (actual time=1.064..45,311.996 rows=62,837 loops=1)

12. 28.872 5,989.413 ↑ 49.9 57,888 1

Subquery Scan on *SELECT* 1 (cost=0.56..1,908,735.74 rows=2,887,164 width=1,045) (actual time=1.063..5,989.413 rows=57,888 loops=1)

13. 60.137 5,960.541 ↑ 49.9 57,888 1

Nested Loop (cost=0.56..1,872,646.19 rows=2,887,164 width=1,041) (actual time=1.060..5,960.541 rows=57,888 loops=1)

14. 4.125 1,963.185 ↓ 1.2 27,533 1

Append (cost=0.00..22,280.33 rows=23,806 width=683) (actual time=1.032..1,963.185 rows=27,533 loops=1)

15. 0.003 0.003 ↓ 0.0 0 1

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

  • Filter: ((test IS NOT TRUE) AND (created_at >= '2019-06-30 23:00:00'::timestamp without time zone) AND (created_at <= '2020-03-10 23:59:59'::timestamp without time zone) AND (shop_id = ANY ('{362,364,363}'::bigint[])))
16. 689.243 689.243 ↓ 1.2 4,833 1

Index Scan using shopify_orders_2019_06_09_ix_shop_id_created_at on shopify_orders_2019_06_09 o_1 (cost=0.43..3,598.98 rows=4,138 width=727) (actual time=1.028..689.243 rows=4,833 loops=1)

  • Index Cond: ((shop_id = ANY ('{362,364,363}'::bigint[])) AND (created_at >= '2019-06-30 23:00:00'::timestamp without time zone) AND (created_at <= '2020-03-10 23:59:59'::timestamp without time zone))
  • Filter: (test IS NOT TRUE)
  • Rows Removed by Filter: 1
17. 856.028 856.028 ↓ 1.3 16,192 1

Index Scan using shopify_orders_2019_09_12_on_shop_id on shopify_orders_2019_09_12 o_2 (cost=0.43..11,293.76 rows=12,457 width=639) (actual time=1.302..856.028 rows=16,192 loops=1)

  • Index Cond: (shop_id = ANY ('{362,364,363}'::bigint[]))
  • Filter: ((test IS NOT TRUE) AND (created_at >= '2019-06-30 23:00:00'::timestamp without time zone) AND (created_at <= '2020-03-10 23:59:59'::timestamp without time zone))
18. 399.567 399.567 ↓ 1.1 5,476 1

Index Scan using shopify_orders_2020_01_03_shop_id on shopify_orders_2020_01_03 o_3 (cost=0.43..5,126.05 rows=5,094 width=792) (actual time=0.941..399.567 rows=5,476 loops=1)

  • Index Cond: (shop_id = ANY ('{362,364,363}'::bigint[]))
  • Filter: ((test IS NOT TRUE) AND (created_at >= '2019-06-30 23:00:00'::timestamp without time zone) AND (created_at <= '2020-03-10 23:59:59'::timestamp without time zone))
19. 14.219 14.219 ↑ 2.1 1,032 1

Index Scan using shopify_orders_2020_03_06_ix_shop_id_created_at on shopify_orders_2020_03_06 o_4 (cost=0.42..2,142.51 rows=2,116 width=598) (actual time=0.058..14.219 rows=1,032 loops=1)

  • Index Cond: ((shop_id = ANY ('{362,364,363}'::bigint[])) AND (created_at >= '2019-06-30 23:00:00'::timestamp without time zone) AND (created_at <= '2020-03-10 23:59:59'::timestamp without time zone))
  • Filter: (test IS NOT TRUE)
20. 3,937.219 3,937.219 ↑ 60.5 2 27,533

Index Scan using index_shopify_line_items_on_shopify_order_id_2 on shopify_line_items l (cost=0.56..76.21 rows=121 width=248) (actual time=0.116..0.143 rows=2 loops=27,533)

  • Index Cond: (shopify_order_id = o.id)
21. 4.349 39,314.553 ↑ 21.5 4,949 1

Subquery Scan on *SELECT* 2 (cost=45,795.99..1,160,617.77 rows=106,165 width=1,121) (actual time=2,148.340..39,314.553 rows=4,949 loops=1)

22. 557.074 39,310.204 ↑ 21.5 4,949 1

Hash Join (cost=45,795.99..1,157,698.23 rows=106,165 width=1,093) (actual time=2,148.330..39,310.204 rows=4,949 loops=1)

  • Hash Cond: (l_1.shopify_order_id = o_5.id)
23. 777.777 36,954.890 ↑ 1.1 521,726 1

Nested Loop (cost=0.44..1,077,890.99 rows=563,619 width=180) (actual time=0.399..36,954.890 rows=521,726 loops=1)

24. 625.032 625.032 ↓ 1.0 582,821 1

Seq Scan on shopify_refund_line_items rl (cost=0.00..41,740.34 rows=563,619 width=44) (actual time=0.029..625.032 rows=582,821 loops=1)

  • Filter: ((created_at >= '2019-06-30 23:00:00'::timestamp without time zone) AND (created_at <= '2020-03-10 23:59:59'::timestamp without time zone))
  • Rows Removed by Filter: 663117
25. 35,552.081 35,552.081 ↑ 1.0 1 582,821

Index Scan using unique_line_item_id on shopify_line_items l_1 (cost=0.44..1.84 rows=1 width=144) (actual time=0.061..0.061 rows=1 loops=582,821)

  • Index Cond: (id = rl.shopify_line_item_id)
26. 34.580 1,798.240 ↓ 1.1 51,781 1

Hash (cost=44,561.18..44,561.18 rows=48,990 width=75) (actual time=1,798.239..1,798.240 rows=51,781 loops=1)

  • Buckets: 65536 Batches: 2 Memory Usage: 3166kB
27. 6.180 1,763.660 ↓ 1.1 51,781 1

Append (cost=0.00..44,561.18 rows=48,990 width=75) (actual time=1.191..1,763.660 rows=51,781 loops=1)

28. 0.034 0.034 ↓ 0.0 0 1

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

  • Filter: ((test IS NOT TRUE) AND (shop_id = ANY ('{362,364,363}'::bigint[])))
29. 230.398 230.398 ↑ 1.2 2,877 1

Index Scan using shopify_orders_2019_01_03_on_shop_id on shopify_orders_2019_01_03 o_6 (cost=0.42..2,975.01 rows=3,315 width=75) (actual time=1.156..230.398 rows=2,877 loops=1)

  • Index Cond: (shop_id = ANY ('{362,364,363}'::bigint[]))
  • Filter: (test IS NOT TRUE)
30. 220.242 220.242 ↓ 1.1 6,144 1

Index Scan using shopify_orders_2019_03_06_on_shop_id on shopify_orders_2019_03_06 o_7 (cost=0.42..4,934.14 rows=5,625 width=76) (actual time=2.028..220.242 rows=6,144 loops=1)

  • Index Cond: (shop_id = ANY ('{362,364,363}'::bigint[]))
  • Filter: (test IS NOT TRUE)
31. 110.713 110.713 ↓ 1.2 5,968 1

Index Scan using shopify_orders_2019_06_09_on_shop_id on shopify_orders_2019_06_09 o_8 (cost=0.43..3,653.84 rows=4,981 width=77) (actual time=1.082..110.713 rows=5,968 loops=1)

  • Index Cond: (shop_id = ANY ('{362,364,363}'::bigint[]))
  • Filter: (test IS NOT TRUE)
  • Rows Removed by Filter: 1
32. 20.446 20.446 ↓ 1.3 16,192 1

Index Scan using shopify_orders_2019_09_12_on_shop_id on shopify_orders_2019_09_12 o_9 (cost=0.43..11,231.47 rows=12,457 width=76) (actual time=0.034..20.446 rows=16,192 loops=1)

  • Index Cond: (shop_id = ANY ('{362,364,363}'::bigint[]))
  • Filter: (test IS NOT TRUE)
33. 283.096 283.096 ↑ 1.2 2,501 1

Index Scan using shopify_orders_2018_01_06_on_shop_id on shopify_orders_2018_01_06 o_10 (cost=0.42..2,795.96 rows=2,976 width=68) (actual time=2.429..283.096 rows=2,501 loops=1)

  • Index Cond: (shop_id = ANY ('{362,364,363}'::bigint[]))
  • Filter: (test IS NOT TRUE)
34. 766.236 766.236 ↓ 1.1 8,997 1

Index Scan using shopify_orders_2018_06_12_on_shop_id on shopify_orders_2018_06_12 o_11 (cost=0.43..7,336.71 rows=8,198 width=72) (actual time=1.449..766.236 rows=8,997 loops=1)

  • Index Cond: (shop_id = ANY ('{362,364,363}'::bigint[]))
  • Filter: (test IS NOT TRUE)
35. 13.621 13.621 ↑ 1.2 280 1

Index Scan using shopify_orders_2017_01_06_on_shop_id on shopify_orders_2017_01_06 o_12 (cost=0.42..345.15 rows=336 width=65) (actual time=1.911..13.621 rows=280 loops=1)

  • Index Cond: (shop_id = ANY ('{362,364,363}'::bigint[]))
  • Filter: (test IS NOT TRUE)
36. 67.857 67.857 ↑ 1.1 1,663 1

Index Scan using shopify_orders_2017_06_12_on_shop_id on shopify_orders_2017_06_12 o_13 (cost=0.42..1,761.92 rows=1,781 width=66) (actual time=2.058..67.857 rows=1,663 loops=1)

  • Index Cond: (shop_id = ANY ('{362,364,363}'::bigint[]))
  • Filter: (test IS NOT TRUE)
37. 5.468 5.468 ↑ 2.0 72 1

Index Scan using shopify_orders_2016_01_12_on_shop_id on shopify_orders_2016_01_12 o_14 (cost=0.42..150.89 rows=146 width=64) (actual time=2.161..5.468 rows=72 loops=1)

  • Index Cond: (shop_id = ANY ('{362,364,363}'::bigint[]))
  • Filter: (test IS NOT TRUE)
38. 2.141 2.141 ↓ 0.0 0 1

Index Scan using shopify_orders_2015_01_12_on_shop_id on shopify_orders_2015_01_12 o_15 (cost=0.42..23.96 rows=20 width=64) (actual time=2.141..2.141 rows=0 loops=1)

  • Index Cond: (shop_id = ANY ('{362,364,363}'::bigint[]))
  • Filter: (test IS NOT TRUE)
39. 1.047 1.047 ↓ 0.0 0 1

Index Scan using shopify_orders_2014_01_12_ix_shop_id_created_at on shopify_orders_2014_01_12 o_16 (cost=0.29..10.98 rows=7 width=62) (actual time=1.047..1.047 rows=0 loops=1)

  • Index Cond: (shop_id = ANY ('{362,364,363}'::bigint[]))
  • Filter: (test IS NOT TRUE)
40. 2.081 2.081 ↓ 0.0 0 1

Index Scan using shopify_orders_2013_on_shop_id on shopify_orders_2013 o_17 (cost=0.41..7.33 rows=4 width=62) (actual time=2.081..2.081 rows=0 loops=1)

  • Index Cond: (shop_id = ANY ('{362,364,363}'::bigint[]))
  • Filter: (test IS NOT TRUE)
41. 6.190 6.190 ↓ 1.1 5,476 1

Index Scan using shopify_orders_2020_01_03_shop_id on shopify_orders_2020_01_03 o_18 (cost=0.43..5,100.57 rows=5,094 width=76) (actual time=0.027..6.190 rows=5,476 loops=1)

  • Index Cond: (shop_id = ANY ('{362,364,363}'::bigint[]))
  • Filter: (test IS NOT TRUE)
42. 27.910 27.910 ↑ 2.5 1,611 1

Index Scan using shopify_orders_2020_03_06_shop_id on shopify_orders_2020_03_06 o_19 (cost=0.42..3,988.30 rows=4,049 width=84) (actual time=0.037..27.910 rows=1,611 loops=1)

  • Index Cond: (shop_id = ANY ('{362,364,363}'::bigint[]))
  • Filter: (test IS NOT TRUE)
43. 1.218 741.073 ↑ 22.3 1,547 1

Subquery Scan on *SELECT* 3 (cost=45,795.98..65,785.32 rows=34,432 width=1,181) (actual time=134.787..741.073 rows=1,547 loops=1)

44. 75.372 739.855 ↑ 22.3 1,547 1

Hash Join (cost=45,795.98..64,752.36 rows=34,432 width=1,149) (actual time=134.778..739.855 rows=1,547 loops=1)

  • Hash Cond: (a.shopify_order_id = o_20.id)
45. 568.079 568.079 ↑ 1.0 171,241 1

Index Scan using ix_oa_created_at on shopify_order_adjustments a (cost=0.42..13,811.40 rows=179,489 width=56) (actual time=0.596..568.079 rows=171,241 loops=1)

  • Index Cond: ((created_at >= '2019-06-30 23:00:00'::timestamp without time zone) AND (created_at <= '2020-03-10 23:59:59'::timestamp without time zone))
46. 25.299 96.404 ↓ 1.1 51,781 1

Hash (cost=44,561.18..44,561.18 rows=48,990 width=75) (actual time=96.404..96.404 rows=51,781 loops=1)

  • Buckets: 65536 Batches: 2 Memory Usage: 3166kB
47. 5.358 71.105 ↓ 1.1 51,781 1

Append (cost=0.00..44,561.18 rows=48,990 width=75) (actual time=0.029..71.105 rows=51,781 loops=1)

48. 0.003 0.003 ↓ 0.0 0 1

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

  • Filter: ((test IS NOT TRUE) AND (shop_id = ANY ('{362,364,363}'::bigint[])))
49. 3.938 3.938 ↑ 1.2 2,877 1

Index Scan using shopify_orders_2019_01_03_on_shop_id on shopify_orders_2019_01_03 o_21 (cost=0.42..2,975.01 rows=3,315 width=75) (actual time=0.025..3.938 rows=2,877 loops=1)

  • Index Cond: (shop_id = ANY ('{362,364,363}'::bigint[]))
  • Filter: (test IS NOT TRUE)
50. 8.318 8.318 ↓ 1.1 6,144 1

Index Scan using shopify_orders_2019_03_06_on_shop_id on shopify_orders_2019_03_06 o_22 (cost=0.42..4,934.14 rows=5,625 width=76) (actual time=0.026..8.318 rows=6,144 loops=1)

  • Index Cond: (shop_id = ANY ('{362,364,363}'::bigint[]))
  • Filter: (test IS NOT TRUE)
51. 8.470 8.470 ↓ 1.2 5,968 1

Index Scan using shopify_orders_2019_06_09_on_shop_id on shopify_orders_2019_06_09 o_23 (cost=0.43..3,653.84 rows=4,981 width=77) (actual time=0.027..8.470 rows=5,968 loops=1)

  • Index Cond: (shop_id = ANY ('{362,364,363}'::bigint[]))
  • Filter: (test IS NOT TRUE)
  • Rows Removed by Filter: 1
52. 19.413 19.413 ↓ 1.3 16,192 1

Index Scan using shopify_orders_2019_09_12_on_shop_id on shopify_orders_2019_09_12 o_24 (cost=0.43..11,231.47 rows=12,457 width=76) (actual time=0.025..19.413 rows=16,192 loops=1)

  • Index Cond: (shop_id = ANY ('{362,364,363}'::bigint[]))
  • Filter: (test IS NOT TRUE)
53. 3.171 3.171 ↑ 1.2 2,501 1

Index Scan using shopify_orders_2018_01_06_on_shop_id on shopify_orders_2018_01_06 o_25 (cost=0.42..2,795.96 rows=2,976 width=68) (actual time=0.028..3.171 rows=2,501 loops=1)

  • Index Cond: (shop_id = ANY ('{362,364,363}'::bigint[]))
  • Filter: (test IS NOT TRUE)
54. 12.915 12.915 ↓ 1.1 8,997 1

Index Scan using shopify_orders_2018_06_12_on_shop_id on shopify_orders_2018_06_12 o_26 (cost=0.43..7,336.71 rows=8,198 width=72) (actual time=0.026..12.915 rows=8,997 loops=1)

  • Index Cond: (shop_id = ANY ('{362,364,363}'::bigint[]))
  • Filter: (test IS NOT TRUE)
55. 0.266 0.266 ↑ 1.2 280 1

Index Scan using shopify_orders_2017_01_06_on_shop_id on shopify_orders_2017_01_06 o_27 (cost=0.42..345.15 rows=336 width=65) (actual time=0.028..0.266 rows=280 loops=1)

  • Index Cond: (shop_id = ANY ('{362,364,363}'::bigint[]))
  • Filter: (test IS NOT TRUE)
56. 1.475 1.475 ↑ 1.1 1,663 1

Index Scan using shopify_orders_2017_06_12_on_shop_id on shopify_orders_2017_06_12 o_28 (cost=0.42..1,761.92 rows=1,781 width=66) (actual time=0.027..1.475 rows=1,663 loops=1)

  • Index Cond: (shop_id = ANY ('{362,364,363}'::bigint[]))
  • Filter: (test IS NOT TRUE)
57. 0.089 0.089 ↑ 2.0 72 1

Index Scan using shopify_orders_2016_01_12_on_shop_id on shopify_orders_2016_01_12 o_29 (cost=0.42..150.89 rows=146 width=64) (actual time=0.022..0.089 rows=72 loops=1)

  • Index Cond: (shop_id = ANY ('{362,364,363}'::bigint[]))
  • Filter: (test IS NOT TRUE)
58. 0.013 0.013 ↓ 0.0 0 1

Index Scan using shopify_orders_2015_01_12_on_shop_id on shopify_orders_2015_01_12 o_30 (cost=0.42..23.96 rows=20 width=64) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (shop_id = ANY ('{362,364,363}'::bigint[]))
  • Filter: (test IS NOT TRUE)
59. 0.011 0.011 ↓ 0.0 0 1

Index Scan using shopify_orders_2014_01_12_ix_shop_id_created_at on shopify_orders_2014_01_12 o_31 (cost=0.29..10.98 rows=7 width=62) (actual time=0.010..0.011 rows=0 loops=1)

  • Index Cond: (shop_id = ANY ('{362,364,363}'::bigint[]))
  • Filter: (test IS NOT TRUE)
60. 0.015 0.015 ↓ 0.0 0 1

Index Scan using shopify_orders_2013_on_shop_id on shopify_orders_2013 o_32 (cost=0.41..7.33 rows=4 width=62) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (shop_id = ANY ('{362,364,363}'::bigint[]))
  • Filter: (test IS NOT TRUE)
61. 5.659 5.659 ↓ 1.1 5,476 1

Index Scan using shopify_orders_2020_01_03_shop_id on shopify_orders_2020_01_03 o_33 (cost=0.43..5,100.57 rows=5,094 width=76) (actual time=0.020..5.659 rows=5,476 loops=1)

  • Index Cond: (shop_id = ANY ('{362,364,363}'::bigint[]))
  • Filter: (test IS NOT TRUE)
62. 1.991 1.991 ↑ 2.5 1,611 1

Index Scan using shopify_orders_2020_03_06_shop_id on shopify_orders_2020_03_06 o_34 (cost=0.42..3,988.30 rows=4,049 width=84) (actual time=0.026..1.991 rows=1,611 loops=1)

  • Index Cond: (shop_id = ANY ('{362,364,363}'::bigint[]))
  • Filter: (test IS NOT TRUE)
63. 14.665 1,916.463 ↓ 1.1 27,317 1

Subquery Scan on *SELECT* 4 (cost=93,133.62..94,621.49 rows=23,806 width=1,191) (actual time=1,865.502..1,916.463 rows=27,317 loops=1)

64. 30.305 1,901.798 ↓ 1.1 27,317 1

GroupAggregate (cost=93,133.62..93,788.28 rows=23,806 width=1,151) (actual time=1,865.493..1,901.798 rows=27,317 loops=1)

  • Group Key: o_35.id
65. 37.125 1,871.493 ↓ 1.1 27,317 1

Sort (cost=93,133.62..93,193.13 rows=23,806 width=125) (actual time=1,865.472..1,871.493 rows=27,317 loops=1)

  • Sort Key: o_35.id
  • Sort Method: external merge Disk: 3032kB
66. 5.570 1,834.368 ↓ 1.1 27,317 1

Nested Loop Left Join (cost=0.86..91,403.04 rows=23,806 width=125) (actual time=0.356..1,834.368 rows=27,317 loops=1)

67. 31.899 790.752 ↓ 1.1 27,317 1

Nested Loop (cost=0.43..75,096.09 rows=23,806 width=125) (actual time=0.310..790.752 rows=27,317 loops=1)

68. 3.352 42.995 ↓ 1.2 27,533 1

Append (cost=0.00..22,280.33 rows=23,806 width=85) (actual time=0.267..42.995 rows=27,533 loops=1)

69. 0.004 0.004 ↓ 0.0 0 1

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

  • Filter: ((test IS NOT TRUE) AND (created_at >= '2019-06-30 23:00:00'::timestamp without time zone) AND (created_at <= '2020-03-10 23:59:59'::timestamp without time zone) AND (shop_id = ANY ('{362,364,363}'::bigint[])))
70. 7.860 7.860 ↓ 1.2 4,833 1

Index Scan using shopify_orders_2019_06_09_ix_shop_id_created_at on shopify_orders_2019_06_09 o_36 (cost=0.43..3,598.98 rows=4,138 width=85) (actual time=0.261..7.860 rows=4,833 loops=1)

  • Index Cond: ((shop_id = ANY ('{362,364,363}'::bigint[])) AND (created_at >= '2019-06-30 23:00:00'::timestamp without time zone) AND (created_at <= '2020-03-10 23:59:59'::timestamp without time zone))
  • Filter: (test IS NOT TRUE)
  • Rows Removed by Filter: 1
71. 23.056 23.056 ↓ 1.3 16,192 1

Index Scan using shopify_orders_2019_09_12_on_shop_id on shopify_orders_2019_09_12 o_37 (cost=0.43..11,293.76 rows=12,457 width=84) (actual time=0.028..23.056 rows=16,192 loops=1)

  • Index Cond: (shop_id = ANY ('{362,364,363}'::bigint[]))
  • Filter: ((test IS NOT TRUE) AND (created_at >= '2019-06-30 23:00:00'::timestamp without time zone) AND (created_at <= '2020-03-10 23:59:59'::timestamp without time zone))
72. 7.098 7.098 ↓ 1.1 5,476 1

Index Scan using shopify_orders_2020_01_03_shop_id on shopify_orders_2020_01_03 o_38 (cost=0.43..5,126.05 rows=5,094 width=84) (actual time=0.027..7.098 rows=5,476 loops=1)

  • Index Cond: (shop_id = ANY ('{362,364,363}'::bigint[]))
  • Filter: ((test IS NOT TRUE) AND (created_at >= '2019-06-30 23:00:00'::timestamp without time zone) AND (created_at <= '2020-03-10 23:59:59'::timestamp without time zone))
73. 1.625 1.625 ↑ 2.1 1,032 1

Index Scan using shopify_orders_2020_03_06_ix_shop_id_created_at on shopify_orders_2020_03_06 o_39 (cost=0.42..2,142.51 rows=2,116 width=92) (actual time=0.028..1.625 rows=1,032 loops=1)

  • Index Cond: ((shop_id = ANY ('{362,364,363}'::bigint[])) AND (created_at >= '2019-06-30 23:00:00'::timestamp without time zone) AND (created_at <= '2020-03-10 23:59:59'::timestamp without time zone))
  • Filter: (test IS NOT TRUE)
74. 715.858 715.858 ↑ 1.0 1 27,533

Index Scan using index_shopify_shipping_lines_on_shopify_order_id on shopify_shipping_lines sl_1 (cost=0.43..2.21 rows=1 width=48) (actual time=0.026..0.026 rows=1 loops=27,533)

  • Index Cond: (shopify_order_id = o_35.id)
75. 1,038.046 1,038.046 ↓ 0.0 0 27,317

Index Scan using index_shopify_shipping_tax_lines_on_shopify_shipping_line_id on shopify_shipping_tax_lines s (cost=0.43..0.65 rows=3 width=16) (actual time=0.037..0.038 rows=0 loops=27,317)

  • Index Cond: (sl_1.id = shopify_shipping_line_id)
76. 0.000 0.003 ↓ 0.0 0 1

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

77. 0.002 0.003 ↓ 0.0 0 1

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

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

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

  • One-Time Filter: false
79. 2,730.521 6,359.064 ↑ 1.0 7,476,436 1

Hash (cost=276,578.20..276,578.20 rows=7,701,620 width=33) (actual time=6,359.064..6,359.064 rows=7,476,436 loops=1)

  • Buckets: 65536 Batches: 256 Memory Usage: 2495kB
80. 3,628.543 3,628.543 ↑ 1.0 7,476,436 1

Seq Scan on shopify_shipping_lines sl (cost=0.00..276,578.20 rows=7,701,620 width=33) (actual time=0.014..3,628.543 rows=7,476,436 loops=1)

81. 19,910.789 33,181.924 ↓ 1.0 21,683,960 1

Hash (cost=755,929.88..755,929.88 rows=21,639,888 width=92) (actual time=33,181.924..33,181.924 rows=21,683,960 loops=1)

  • Buckets: 32768 Batches: 1024 Memory Usage: 2964kB
82. 13,271.135 13,271.135 ↓ 1.0 21,683,960 1

Seq Scan on shopify_customer_addresses ba (cost=0.00..755,929.88 rows=21,639,888 width=92) (actual time=1.127..13,271.135 rows=21,683,960 loops=1)

83. 20,020.842 31,156.143 ↓ 1.0 21,683,960 1

Hash (cost=755,929.88..755,929.88 rows=21,639,888 width=91) (actual time=31,156.143..31,156.143 rows=21,683,960 loops=1)

  • Buckets: 32768 Batches: 1024 Memory Usage: 2964kB
84. 11,135.301 11,135.301 ↓ 1.0 21,683,960 1

Seq Scan on shopify_customer_addresses sa (cost=0.00..755,929.88 rows=21,639,888 width=91) (actual time=0.025..11,135.301 rows=21,683,960 loops=1)

Planning time : 27.025 ms
Execution time : 209,414.489 ms