explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mGF8

Settings
# exclusive inclusive rows x rows loops node
1. 0.036 9,291.343 ↑ 28.6 7 1

GroupAggregate (cost=3,862,799.25..3,862,803.75 rows=200 width=48) (actual time=9,291.310..9,291.343 rows=7 loops=1)

  • Group Key: x.admin_user
2. 0.082 9,291.307 ↑ 1.2 161 1

Sort (cost=3,862,799.25..3,862,799.75 rows=200 width=48) (actual time=9,291.299..9,291.307 rows=161 loops=1)

  • Sort Key: x.admin_user
  • Sort Method: quicksort Memory: 37kB
3. 0.022 9,291.225 ↑ 1.2 161 1

Subquery Scan on x (cost=3,862,695.52..3,862,791.61 rows=200 width=48) (actual time=9,259.020..9,291.225 rows=161 loops=1)

4. 0.187 9,291.203 ↑ 1.2 161 1

GroupAggregate (cost=3,862,695.52..3,862,789.61 rows=200 width=52) (actual time=9,259.019..9,291.203 rows=161 loops=1)

  • Group Key: ((o.status_date)::date), osl.admin_user
5. 0.148 9,291.016 ↑ 3.8 455 1

Merge Append (cost=3,862,695.52..3,862,773.22 rows=1,719 width=28) (actual time=9,258.881..9,291.016 rows=455 loops=1)

  • Sort Key: ((o.status_date)::date), osl.admin_user
6. 4.942 9,062.337 ↓ 159.0 159 1

GroupAggregate (cost=3,770,758.83..3,770,758.85 rows=1 width=17) (actual time=9,055.122..9,062.337 rows=159 loops=1)

  • Group Key: ((o.status_date)::date), osl.admin_user
7. 16.748 9,057.395 ↓ 35,756.0 35,756 1

Sort (cost=3,770,758.83..3,770,758.83 rows=1 width=13) (actual time=9,055.076..9,057.395 rows=35,756 loops=1)

  • Sort Key: ((o.status_date)::date), osl.admin_user
  • Sort Method: quicksort Memory: 4330kB
8. 13.791 9,040.647 ↓ 35,756.0 35,756 1

Gather (cost=1,000.00..3,770,758.82 rows=1 width=13) (actual time=7,380.869..9,040.647 rows=35,756 loops=1)

  • Workers Planned: 7
  • Workers Launched: 7
9. 90.527 9,026.856 ↓ 4,470.0 4,470 8 / 8

Nested Loop (cost=0.00..3,769,758.72 rows=1 width=13) (actual time=7,363.521..9,026.856 rows=4,470 loops=8)

10. 3,055.805 3,055.805 ↓ 21.7 34,796 8 / 8

Parallel Seq Scan on order_status_logs osl (cost=0.00..2,707,844.22 rows=1,602 width=9) (actual time=1,517.412..3,055.805 rows=34,796 loops=8)

  • Filter: ((status_in = 2) AND (lower((admin_user)::text) <> ALL ('{ts,auto,""""}'::text[])) AND ((admin_user)::text = ANY ('{denis.ferreira,rodrigo.henrique,emily.fernandes,frederico.eduardo,emanuelle.batista,gleicy.goncalves,hugo.saladini}'::text[])))
  • Rows Removed by Filter: 21995711
11. 1,113.472 5,880.524 ↓ 0.0 0 278,368 / 8

Append (cost=0.00..662.11 rows=76 width=12) (actual time=0.169..0.169 rows=0 loops=278,368)

12. 1,809.392 1,809.392 ↓ 0.0 0 278,368 / 8

Seq Scan on orders o (cost=0.00..108.00 rows=1 width=12) (actual time=0.052..0.052 rows=0 loops=278,368)

  • Filter: ((osl.orderid = orderid) AND ((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
13. 69.592 69.592 ↓ 0.0 0 278,368 / 8

Index Scan using orders_history_pkey on orders_history o_1 (cost=0.43..7.54 rows=1 width=12) (actual time=0.002..0.002 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
14. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2014_01_pkey on orders_2014_01 o_2 (cost=0.42..6.55 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
15. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2014_11_pkey on orders_2014_11 o_3 (cost=0.42..6.94 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
16. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2014_02_pkey on orders_2014_02 o_4 (cost=0.42..6.55 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
17. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2014_03_pkey on orders_2014_03 o_5 (cost=0.42..6.63 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
18. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2014_08_pkey on orders_2014_08 o_6 (cost=0.42..6.80 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
19. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2014_05_pkey on orders_2014_05 o_7 (cost=0.42..6.72 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
20. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2014_10_pkey on orders_2014_10 o_8 (cost=0.42..6.98 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
21. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2014_09_pkey on orders_2014_09 o_9 (cost=0.42..6.86 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
22. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2014_12_pkey on orders_2014_12 o_10 (cost=0.42..7.05 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
23. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2014_07_pkey on orders_2014_07 o_11 (cost=0.42..6.74 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
24. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2014_06_pkey on orders_2014_06 o_12 (cost=0.42..6.72 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
25. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2014_04_pkey on orders_2014_04 o_13 (cost=0.42..6.68 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
26. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2015_06_pkey on orders_2015_06 o_14 (cost=0.43..7.23 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
27. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2015_01_pkey on orders_2015_01 o_15 (cost=0.43..7.10 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
28. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2015_04_pkey on orders_2015_04 o_16 (cost=0.43..7.26 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
29. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2015_02_pkey on orders_2015_02 o_17 (cost=0.43..7.14 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
30. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2015_05_pkey on orders_2015_05 o_18 (cost=0.43..7.28 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
31. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2015_07_pkey on orders_2015_07 o_19 (cost=0.43..7.23 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
32. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2015_03_pkey on orders_2015_03 o_20 (cost=0.43..7.21 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
33. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2015_08_pkey on orders_2015_08 o_21 (cost=0.43..7.23 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
34. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2015_09_pkey on orders_2015_09 o_22 (cost=0.43..7.25 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
35. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2015_10_pkey on orders_2015_10 o_23 (cost=0.43..7.25 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
36. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2015_11_pkey on orders_2015_11 o_24 (cost=0.43..7.26 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
37. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2015_12_pkey on orders_2015_12 o_25 (cost=0.43..7.27 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
38. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2016_01_pkey on orders_2016_01 o_26 (cost=0.43..7.28 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
39. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2016_02_pkey on orders_2016_02 o_27 (cost=0.43..7.29 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
40. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2016_03_pkey on orders_2016_03 o_28 (cost=0.43..7.31 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
41. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2016_04_pkey on orders_2016_04 o_29 (cost=0.43..7.30 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
42. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2016_05_pkey on orders_2016_05 o_30 (cost=0.43..7.31 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
43. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2016_06_pkey on orders_2016_06 o_31 (cost=0.43..7.31 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
44. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2016_07_pkey on orders_2016_07 o_32 (cost=0.43..7.33 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
45. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2016_08_pkey on orders_2016_08 o_33 (cost=0.43..7.34 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
46. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2016_09_pkey on orders_2016_09 o_34 (cost=0.43..7.32 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
47. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2016_10_pkey on orders_2016_10 o_35 (cost=0.43..7.31 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
48. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2016_11_pkey on orders_2016_11 o_36 (cost=0.43..7.31 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
49. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2016_12_pkey on orders_2016_12 o_37 (cost=0.43..7.32 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
50. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2017_01_pkey on orders_2017_01 o_38 (cost=0.43..7.33 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
51. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2017_02_pkey on orders_2017_02 o_39 (cost=0.43..7.33 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
52. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2017_03_pkey on orders_2017_03 o_40 (cost=0.43..7.33 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
53. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2017_04_pkey on orders_2017_04 o_41 (cost=0.43..7.33 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
54. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2017_05_pkey on orders_2017_05 o_42 (cost=0.43..7.36 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
55. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2017_06_pkey on orders_2017_06 o_43 (cost=0.43..7.35 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
56. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2017_07_pkey on orders_2017_07 o_44 (cost=0.43..7.37 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
57. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2017_08_pkey on orders_2017_08 o_45 (cost=0.43..7.39 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
58. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2017_09_pkey on orders_2017_09 o_46 (cost=0.43..7.40 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
59. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2017_10_pkey on orders_2017_10 o_47 (cost=0.43..7.41 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
60. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2017_11_pkey on orders_2017_11 o_48 (cost=0.43..7.40 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
61. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2017_12_pkey on orders_2017_12 o_49 (cost=0.43..7.45 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
62. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2018_01_pkey on orders_2018_01 o_50 (cost=0.43..7.42 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
63. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2018_02_pkey on orders_2018_02 o_51 (cost=0.43..7.40 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
64. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2018_03_pkey on orders_2018_03 o_52 (cost=0.43..7.41 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
65. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2018_04_pkey on orders_2018_04 o_53 (cost=0.43..7.41 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
66. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2018_05_pkey on orders_2018_05 o_54 (cost=0.43..7.42 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
67. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2018_06_pkey on orders_2018_06 o_55 (cost=0.43..7.44 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
68. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2018_07_pkey on orders_2018_07 o_56 (cost=0.43..7.48 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
69. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2018_08_pkey on orders_2018_08 o_57 (cost=0.43..7.50 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
70. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2018_09_pkey on orders_2018_09 o_58 (cost=0.43..7.50 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
71. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2018_10_pkey on orders_2018_10 o_59 (cost=0.43..7.54 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
72. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2018_11_pkey on orders_2018_11 o_60 (cost=0.43..7.89 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
73. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2018_12_pkey on orders_2018_12 o_61 (cost=0.43..8.15 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
74. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2019_01_pkey on orders_2019_01 o_62 (cost=0.43..8.16 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
75. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2019_02_pkey on orders_2019_02 o_63 (cost=0.43..8.21 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
  • Rows Removed by Filter: 0
76. 34.796 34.796 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2019_03_pkey on orders_2019_03 o_64 (cost=0.43..8.26 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
  • Rows Removed by Filter: 0
77. 69.592 69.592 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2019_04_pkey on orders_2019_04 o_65 (cost=0.43..8.20 rows=1 width=12) (actual time=0.002..0.002 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
  • Rows Removed by Filter: 0
78. 69.592 69.592 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2019_05_pkey on orders_2019_05 o_66 (cost=0.56..8.40 rows=1 width=12) (actual time=0.002..0.002 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
  • Rows Removed by Filter: 0
79. 69.592 69.592 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2019_06_pkey on orders_2019_06 o_67 (cost=0.56..8.45 rows=1 width=12) (actual time=0.002..0.002 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
  • Rows Removed by Filter: 0
80. 69.592 69.592 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2019_07_pkey on orders_2019_07 o_68 (cost=0.56..8.44 rows=1 width=12) (actual time=0.002..0.002 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
  • Rows Removed by Filter: 0
81. 69.592 69.592 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2019_08_pkey on orders_2019_08 o_69 (cost=0.56..8.43 rows=1 width=12) (actual time=0.002..0.002 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
  • Rows Removed by Filter: 0
82. 69.592 69.592 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2019_09_pkey on orders_2019_09 o_70 (cost=0.56..8.45 rows=1 width=12) (actual time=0.002..0.002 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
  • Rows Removed by Filter: 0
83. 69.592 69.592 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2019_10_pkey on orders_2019_10 o_71 (cost=0.56..8.47 rows=1 width=12) (actual time=0.002..0.002 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
  • Rows Removed by Filter: 0
84. 69.592 69.592 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2019_11_pkey on orders_2019_11 o_72 (cost=0.56..8.48 rows=1 width=12) (actual time=0.002..0.002 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
  • Rows Removed by Filter: 0
85. 69.592 69.592 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2019_12_pkey on orders_2019_12 o_73 (cost=0.56..8.48 rows=1 width=12) (actual time=0.002..0.002 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
  • Rows Removed by Filter: 0
86. 69.592 69.592 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2020_01_pkey on orders_2020_01 o_74 (cost=0.56..8.46 rows=1 width=12) (actual time=0.002..0.002 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
  • Rows Removed by Filter: 0
87. 0.000 0.000 ↓ 0.0 0 278,368 / 8

Index Scan using orders_2020_02_pkey on orders_2020_02 o_75 (cost=0.14..3.00 rows=1 width=12) (actual time=0.000..0.000 rows=0 loops=278,368)

  • Index Cond: (orderid = osl.orderid)
  • Filter: (((creation_date)::date <= '2020-01-28'::date) AND ((status_date)::date <= '2020-01-28'::date) AND ((creation_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
88. 14.200 159.483 ↑ 10.1 154 1

GroupAggregate (cost=64,516.84..64,555.77 rows=1,557 width=28) (actual time=141.378..159.483 rows=154 loops=1)

  • Group Key: ((user_profile_photos.status_date)::date), user_profile_photos.admin_user
  • Filter: (count(DISTINCT user_profile_photos.userid) > 5)
  • Rows Removed by Filter: 1
89. 22.262 145.283 ↓ 36.6 56,977 1

Sort (cost=64,516.84..64,520.73 rows=1,558 width=24) (actual time=141.297..145.283 rows=56,977 loops=1)

  • Sort Key: ((user_profile_photos.status_date)::date), user_profile_photos.admin_user
  • Sort Method: quicksort Memory: 5988kB
90. 2.233 123.021 ↓ 36.6 56,977 1

Gather (cost=1,000.00..64,434.22 rows=1,558 width=24) (actual time=1.703..123.021 rows=56,977 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
91. 120.788 120.788 ↓ 29.2 11,395 5 / 5

Parallel Seq Scan on user_profile_photos (cost=0.00..63,275.50 rows=390 width=24) (actual time=0.749..120.788 rows=11,395 loops=5)

  • Filter: (((type)::text ~~ '%_ID'::text) AND (status = ANY ('{1,2}'::integer[])) AND ((status_date)::date <= '2020-01-28'::date) AND ((admin_user)::text = ANY ('{denis.ferreira,rodrigo.henrique,emily.fernandes,frederico.eduardo,emanuelle.batista,gleicy.goncalves,hugo.saladini}'::text[])) AND ((status_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
  • Rows Removed by Filter: 392199
92. 5.540 69.048 ↑ 1.1 142 1

GroupAggregate (cost=27,419.84..27,423.46 rows=161 width=23) (actual time=62.378..69.048 rows=142 loops=1)

  • Group Key: ((user_categories.modification_date)::date), user_categories.admin_user
93. 8.737 63.508 ↓ 147.0 23,667 1

Sort (cost=27,419.84..27,420.24 rows=161 width=19) (actual time=62.142..63.508 rows=23,667 loops=1)

  • Sort Key: ((user_categories.modification_date)::date), user_categories.admin_user
  • Sort Method: quicksort Memory: 2617kB
94. 3.549 54.771 ↓ 147.0 23,667 1

Gather (cost=1,000.00..27,413.94 rows=161 width=19) (actual time=1.010..54.771 rows=23,667 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
95. 51.222 51.222 ↓ 113.8 5,917 4 / 4

Parallel Seq Scan on user_categories (cost=0.00..26,397.56 rows=52 width=19) (actual time=0.148..51.222 rows=5,917 loops=4)

  • Filter: (((category)::text ~~ '%manually_reviewed%'::text) AND ((modification_date)::date <= '2020-01-28'::date) AND ((admin_user)::text = ANY ('{denis.ferreira,rodrigo.henrique,emily.fernandes,frederico.eduardo,emanuelle.batista,gleicy.goncalves,hugo.saladini}'::text[])) AND ((modification_date)::date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
  • Rows Removed by Filter: 194376
Planning time : 24.904 ms
Execution time : 9,293.712 ms