explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Lmtv

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 5.973 436.321 ↓ 0.0 0 1

Gather (cost=1,000.00..196,319.00 rows=10,000 width=685) (actual time=434.627..436.321 rows=0 loops=1)

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

Parallel Seq Scan on json_report (cost=0.00..194,319.00 rows=4,167 width=685) (actual time=430.348..430.348 rows=0 loops=3)

  • Filter: ((data -> 'attribute_1'::text) = '945'::jsonb)
  • Rows Removed by Filter: 666,667