explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LgXL : Optimization for: plan #l13t

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 29.999 9,790.634 ↓ 6.8 17,340 1

Gather Merge (cost=6,476,733.89..6,477,051.45 rows=2,568 width=1,366) (actual time=9,767.178..9,790.634 rows=17,340 loops=1)

  • Workers Planned: 8
  • Workers Launched: 8
2. 1.843 9,760.635 ↓ 6.0 1,927 9 / 9

Sort (cost=6,475,733.74..6,475,734.55 rows=321 width=1,366) (actual time=9,760.351..9,760.635 rows=1,927 loops=9)

  • Sort Key: startdatetime, rq_data_od2_dep_date
  • Sort Method: quicksort Memory: 334kB
3. 9,758.792 9,758.792 ↓ 6.0 1,927 9 / 9

Parallel Seq Scan on lhg_markets_202005 (cost=0.00..6,475,720.38 rows=321 width=1,366) (actual time=4,089.505..9,758.792 rows=1,927 loops=9)

  • Filter: (((pcc)::text = 'AQYM'::text) AND ((startdatetime)::date = '2020-05-30'::date) AND ((rq_data_od1_dep_date)::date = '2020-08-17'::date))
  • Rows Removed by Filter: 31,988,730