explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Go7Q

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=3,395,901.98..3,395,901.99 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather Motion 64:1 (slice3; segments: 64) (cost=3,395,901.30..3,395,901.96 rows=1 width=8) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Aggregate (cost=3,395,901.30..3,395,901.31 rows=1 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,810.66..3,395,901.26 rows=1 width=0) (actual rows= loops=)

  • Hash Cond: e2.src_tail::text = ec.tail_num::text AND to_char(e2.flight_date_exact, 'YYYY-MM'::text) = to_char(ec.flight_date::timestamp with time zone, 'YYYY-MM'::text)
  • Join Filter: ec.adi_flight_record_number = e2.adi_flight_record_number
5. 0.000 0.000 ↓ 0.0

Redistribute Motion 64:64 (slice1; segments: 64) (cost=0.00..3,394,089.04 rows=5 width=114) (actual rows= loops=)

  • Hash Key: to_char(e2.flight_date_exact, 'YYYY-MM'::text), e2.src_tail::text
6. 0.000 0.000 ↓ 0.0

Append-only Scan on flight_engine_summary_final e2 (cost=0.00..3,394,083.44 rows=5 width=114) (actual rows= loops=)

  • Filter: engine_family::text !~~ 'GENX-%'::text AND to_char(flight_date_exact, 'YYYYMM'::text) >= '201401'::text AND (length(operator_icao::text) = 3 OR (operator_icao::text = 'WWAH'::text AND engine_family::text = 'GENX-2B': (...)
7. 0.000 0.000 ↓ 0.0

Hash (cost=1,385.23..1,385.23 rows=444 width=23) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Redistribute Motion 64:64 (slice2; segments: 64) (cost=0.00..1,385.23 rows=444 width=23) (actual rows= loops=)

  • Hash Key: to_char(ec.flight_date::timestamp with time zone, 'YYYY-MM'::text), ec.tail_num::text
9. 0.000 0.000 ↓ 0.0

Seq Scan on ceod_engine_central_valid ec (cost=0.00..818.00 rows=444 width=23) (actual rows= loops=)

  • Filter: file_type::text = 'QAR'::text AND (ems_origination::text = ANY ('{HoustonDC_EMS11,DubaiDC_EMS002,ShanghaiDC_EMS04,DubaiDC_EMS005}'::text[])) AND 'QAR'::text = file_type::text