explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6kR8

Settings
# exclusive inclusive rows x rows loops node
1. 41.775 5,703.193 ↓ 7.4 113,593 1

Gather (cost=1,000.86..472,676.98 rows=15,420 width=485) (actual time=30.011..5,703.193 rows=113,593 loops=1)

  • Workers Planned: 6
  • Workers Launched: 6
2. 60.580 5,661.418 ↓ 6.3 16,228 7 / 7

Nested Loop Anti Join (cost=0.86..470,096.43 rows=2,570 width=477) (actual time=59.793..5,661.418 rows=16,228 loops=7)

3. 17.528 5,155.582 ↓ 28.9 148,419 7 / 7

Append (cost=0.43..438,112.90 rows=5,144 width=477) (actual time=7.431..5,155.582 rows=148,419 loops=7)

4. 0.165 0.165 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2019_12_modify_date_idx on orders_2019_12 (cost=0.43..8.45 rows=1 width=483) (actual time=0.165..0.165 rows=0 loops=7)

  • Index Cond: (((modify_date)::date >= '2020-05-16'::date) AND ((modify_date)::date <= '2020-05-21'::date))
  • Filter: (creation_date >= '2019-12-01 00:00:00'::timestamp without time zone)
5. 0.104 0.104 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2020_01_modify_date_idx on orders_2020_01 (cost=0.43..8.45 rows=1 width=482) (actual time=0.104..0.104 rows=0 loops=7)

  • Index Cond: (((modify_date)::date >= '2020-05-16'::date) AND ((modify_date)::date <= '2020-05-21'::date))
  • Filter: (creation_date >= '2019-12-01 00:00:00'::timestamp without time zone)
6. 0.123 0.123 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2020_02_modify_date_idx on orders_2020_02 (cost=0.43..8.45 rows=1 width=522) (actual time=0.123..0.123 rows=0 loops=7)

  • Index Cond: (((modify_date)::date >= '2020-05-16'::date) AND ((modify_date)::date <= '2020-05-21'::date))
  • Filter: (creation_date >= '2019-12-01 00:00:00'::timestamp without time zone)
7. 0.162 0.162 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2020_03_modify_date_idx on orders_2020_03 (cost=0.43..8.45 rows=1 width=480) (actual time=0.162..0.162 rows=0 loops=7)

  • Index Cond: (((modify_date)::date >= '2020-05-16'::date) AND ((modify_date)::date <= '2020-05-21'::date))
  • Filter: (creation_date >= '2019-12-01 00:00:00'::timestamp without time zone)
8. 1.865 1.865 ↓ 0.0 0 7 / 7

Parallel Index Scan using orders_2020_04_modify_date_idx on orders_2020_04 (cost=0.43..8.45 rows=1 width=478) (actual time=1.865..1.865 rows=0 loops=7)

  • Index Cond: (((modify_date)::date >= '2020-05-16'::date) AND ((modify_date)::date <= '2020-05-21'::date))
  • Filter: (creation_date >= '2019-12-01 00:00:00'::timestamp without time zone)
9. 5,135.635 5,135.635 ↓ 28.9 148,419 7 / 7

Parallel Seq Scan on orders_2020_05 (cost=0.00..438,070.64 rows=5,139 width=477) (actual time=5.010..5,135.635 rows=148,419 loops=7)

  • Filter: ((creation_date >= '2019-12-01 00:00:00'::timestamp without time zone) AND ((modify_date)::date >= '2020-05-16'::date) AND ((modify_date)::date <= '2020-05-21'::date))
  • Rows Removed by Filter: 491339
10. 445.256 445.256 ↑ 1.0 1 1,038,930 / 7

Index Only Scan using fnc_trs_tmp_orders_orderid_idx on fnc_trs_tmp_orders tmp (cost=0.42..7.37 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=1,038,930)

  • Index Cond: (orderid = orders_2019_12.orderid)
  • Heap Fetches: 129647
Planning time : 115.872 ms
Execution time : 5,709.643 ms