explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oeaY : Optimization for: plan #bCWN

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 31.414 208.090 ↓ 0.0 0 1

Gather (cost=1,000.00..40,241.10 rows=11 width=16) (actual time=184.831..208.090 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.004 176.676 ↓ 0.0 0 3 / 3

Parallel Append (cost=0.00..39,240.00 rows=5 width=16) (actual time=176.676..176.676 rows=0 loops=3)

3. 147.352 147.352 ↓ 0.0 0 3 / 3

Parallel Seq Scan on subject_email_entries_history (cost=0.00..30,260.60 rows=4 width=16) (actual time=147.352..147.352 rows=0 loops=3)

  • Filter: (subject_id = '123'::bigint)
  • Rows Removed by Filter: 293956
4. 29.320 29.320 ↓ 0.0 0 2 / 3

Parallel Seq Scan on subject_email_entries_actual (cost=0.00..8,979.38 rows=1 width=16) (actual time=43.980..43.980 rows=0 loops=2)

  • Filter: (subject_id = '123'::bigint)
  • Rows Removed by Filter: 162618