explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KT5Z

Settings
# exclusive inclusive rows x rows loops node
1. 0.036 8,873.760 ↑ 28.6 7 1

GroupAggregate (cost=3,859,712.89..3,859,738.63 rows=200 width=47) (actual time=8,873.727..8,873.760 rows=7 loops=1)

  • Group Key: x.admin_user
2. 0.091 8,873.724 ↑ 18.8 161 1

Sort (cost=3,859,712.89..3,859,720.47 rows=3,033 width=47) (actual time=8,873.716..8,873.724 rows=161 loops=1)

  • Sort Key: x.admin_user
  • Sort Method: quicksort Memory: 37kB
3. 0.026 8,873.633 ↑ 18.8 161 1

Subquery Scan on x (cost=3,857,693.87..3,859,537.48 rows=3,033 width=47) (actual time=8,845.767..8,873.633 rows=161 loops=1)

4. 0.205 8,873.607 ↑ 18.8 161 1

GroupAggregate (cost=3,857,693.87..3,859,507.15 rows=3,033 width=51) (actual time=8,845.766..8,873.607 rows=161 loops=1)

  • Group Key: ((o.status_date)::date), osl.admin_user
5. 0.145 8,873.402 ↑ 66.7 455 1

Merge Append (cost=3,857,693.87..3,859,226.58 rows=30,332 width=27) (actual time=8,845.665..8,873.402 rows=455 loops=1)

  • Sort Key: ((o.status_date)::date), osl.admin_user
6. 0.000 8,183.807 ↑ 8.4 159 1

Finalize GroupAggregate (cost=3,764,780.77..3,764,975.62 rows=1,339 width=17) (actual time=8,181.955..8,183.807 rows=159 loops=1)

  • Group Key: ((o.status_date)::date), osl.admin_user
7. 16.748 8,183.939 ↑ 1.1 1,231 1

Gather Merge (cost=3,764,780.77..3,764,948.85 rows=1,337 width=17) (actual time=8,181.938..8,183.939 rows=1,231 loops=1)

  • Workers Planned: 7
  • Workers Launched: 7
8. 0.638 8,167.191 ↑ 1.2 154 8 / 8

Partial GroupAggregate (cost=3,763,780.65..3,763,784.95 rows=191 width=17) (actual time=8,166.337..8,167.191 rows=154 loops=8)

  • Group Key: ((o.status_date)::date), osl.admin_user
9. 2.725 8,166.553 ↓ 23.4 4,470 8 / 8

Sort (cost=3,763,780.65..3,763,781.13 rows=191 width=13) (actual time=8,166.327..8,166.553 rows=4,470 loops=8)

  • Sort Key: ((o.status_date)::date), osl.admin_user
  • Sort Method: quicksort Memory: 525kB
10. 85.629 8,163.828 ↓ 23.4 4,470 8 / 8

Nested Loop (cost=0.00..3,763,773.41 rows=191 width=13) (actual time=6,616.609..8,163.828 rows=4,470 loops=8)

11. 2,893.558 2,893.558 ↓ 21.7 34,796 8 / 8

Parallel Seq Scan on order_status_logs osl (cost=0.00..2,707,859.02 rows=1,602 width=9) (actual time=1,332.270..2,893.558 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: 21995773
12. 1,043.888 5,184.641 ↓ 0.0 0 278,370 / 8

Append (cost=0.00..658.37 rows=75 width=12) (actual time=0.149..0.149 rows=0 loops=278,370)

13. 1,183.072 1,183.072 ↓ 0.0 0 278,370 / 8

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

  • Filter: ((creation_date <= '2020-01-29 00:00:00'::timestamp without time zone) AND (status_date <= '2020-01-29 00:00:00'::timestamp without time zone) AND (osl.orderid = orderid) AND (creation_date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND (status_date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
14. 69.593 69.593 ↓ 0.0 0 278,370 / 8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: (orderid = osl.orderid)
  • Filter: ((creation_date <= '2020-01-29 00:00:00'::timestamp without time zone) AND (status_date <= '2020-01-29 00:00:00'::timestamp without time zone) AND (creation_date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date) AND (status_date >= (date_trunc('month'::text, (CURRENT_DATE)::timestamp with time zone))::date))
  • Rows Removed by Filter: 0
88. 14.681 621.111 ↑ 161.4 154 1

GroupAggregate (cost=66,132.78..66,757.97 rows=24,863 width=28) (actual time=602.440..621.111 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.706 606.430 ↓ 2.3 56,976 1

Sort (cost=66,132.78..66,195.66 rows=25,152 width=24) (actual time=602.358..606.430 rows=56,976 loops=1)

  • Sort Key: ((user_profile_photos.status_date)::date), user_profile_photos.admin_user
  • Sort Method: quicksort Memory: 5988kB
90. 6.676 583.724 ↓ 2.3 56,976 1

Gather (cost=1,000.00..64,294.37 rows=25,152 width=24) (actual time=1.743..583.724 rows=56,976 loops=1)

  • Workers Planned: 4
  • Workers Launched: 0
91. 577.048 577.048 ↓ 9.1 56,976 1

Parallel Seq Scan on user_profile_photos (cost=0.00..60,732.01 rows=6,288 width=24) (actual time=0.801..577.048 rows=56,976 loops=1)

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

GroupAggregate (cost=26,780.29..26,873.45 rows=4,130 width=23) (actual time=61.266..68.339 rows=142 loops=1)

  • Group Key: ((user_categories.modification_date)::date), user_categories.admin_user
93. 8.905 62.507 ↓ 5.7 23,667 1

Sort (cost=26,780.29..26,790.68 rows=4,153 width=19) (actual time=61.037..62.507 rows=23,667 loops=1)

  • Sort Key: ((user_categories.modification_date)::date), user_categories.admin_user
  • Sort Method: quicksort Memory: 2617kB
94. 3.883 53.602 ↓ 5.7 23,667 1

Gather (cost=1,000.00..26,530.70 rows=4,153 width=19) (actual time=0.973..53.602 rows=23,667 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
95. 49.719 49.719 ↓ 4.4 5,917 4 / 4

Parallel Seq Scan on user_categories (cost=0.00..25,108.37 rows=1,340 width=19) (actual time=0.149..49.719 rows=5,917 loops=4)

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