explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OMif : Optimization for: plan #r7o5

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.011 1,091.956 ↑ 1.0 1 1

Aggregate (cost=300,236.57..300,236.58 rows=1 width=8) (actual time=1,091.956..1,091.956 rows=1 loops=1)

2. 14.147 1,091.945 ↓ 0.0 0 1

Gather (cost=1,000.00..300,236.57 rows=1 width=0) (actual time=1,091.945..1,091.945 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 1,077.798 1,077.798 ↓ 0.0 0 3

Parallel Seq Scan on es_question (cost=0.00..299,236.47 rows=1 width=0) (actual time=1,077.798..1,077.798 rows=0 loops=3)

  • Filter: ((NOT isdeleted) AND ((title)::text = ADA_M0204S001::text))
  • Rows Removed by Filter: 192615