explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rR6c : Optimization for: Optimization for: Optimization for: plan #yPb9; plan #vx5Y; plan #Smd2

Settings

Optimization path:

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

Hash Join (cost=13,560,894.67..568,751,399.80 rows=511 width=1,836) (actual rows= loops=)

  • Hash Cond: rmd_msgdetail.parameter_id = rmd_parmlist.parameter_id
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=13,560,594.96..568,742,387.89 rows=19,705 width=218) (actual rows= loops=)

  • Hash Cond: rmd_msgdetail.message_seq_id = rmd_msgheader.message_s
  • -> Append-only Scan on rmd_msgdetail (cost=0.00..451707533.12 r
3. 0.000 0.000 ↓ 0.0

Hash (cost=13,554,264.77..13,554,264.77 rows=7,913 width=155) (actual rows= loops=)

  • -> Broadcast Motion 64:64 (slice1; segments: 64) (cost=0
  • -> Append-only Scan on rmd_msgheader (cost=0.00..13
  • Filter: report_type::text = 'PostFlight'::text
4. 0.000 0.000 ↓ 0.0

Hash (cost=205.25..205.25 rows=119 width=1,618) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Broadcast Motion 64:64 (slice2; segments: 64) (cost=0.00..205.25 rows=119 width=1,618) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Append-only Scan on rmd_parmlist (cost=0.00..128.50 rows=2 width=1,618) (actual rows= loops=)

  • Filter: parameter_name::text ~~ '%P4%'::text OR parameter_name::text = 'Engine Serial Number'::text