explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DwiG

Settings
# exclusive inclusive rows x rows loops node
1. 32.420 4,675.601 ↓ 0.0 0 1

Gather (cost=1,000.00..1,356,167.75 rows=10,000 width=33) (actual time=4,671.632..4,675.601 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 4,643.181 4,643.181 ↓ 0.0 0 3

Parallel Seq Scan on test (cost=0.00..1,354,167.75 rows=4,167 width=33) (actual time=4,643.181..4,643.181 rows=0 loops=3)

  • Filter: ((info)::text ~~ 'ABC%'::text)
  • Rows Removed by Filter: 33333333