explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XY4i

Settings
# exclusive inclusive rows x rows loops node
1. 14.011 871.713 ↓ 1.1 55,375 1

Gather (cost=1,000.00..253,861.03 rows=52,035 width=1,069) (actual time=0.241..871.713 rows=55,375 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 857.702 857.702 ↑ 1.2 18,458 3 / 3

Parallel Seq Scan on test (cost=0.00..247,657.53 rows=21,681 width=1,069) (actual time=0.240..857.702 rows=18,458 loops=3)

  • Filter: (title ~* 'space'::text)
  • Rows Removed by Filter: 555,131
Planning time : 0.184 ms
Execution time : 874.262 ms