explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ALfo

Settings
# exclusive inclusive rows x rows loops node
1. 0.093 22,047.927 ↑ 1.0 1,000 1

Limit (cost=1,000.00..1,019,574.56 rows=1,000 width=41) (actual time=0.379..22,047.927 rows=1,000 loops=1)

2. 270.872 22,047.834 ↑ 12.0 1,000 1

Gather (cost=1,000.00..12,235,099.10 rows=12,011 width=41) (actual time=0.378..22,047.834 rows=1,000 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 21,776.962 21,776.962 ↑ 15.0 334 3

Parallel Seq Scan on wordsearch x (cost=0.00..12,232,898.00 rows=5,005 width=41) (actual time=543.874..21,776.962 rows=334 loops=3)

  • Filter: ((articleid)::text = '29021819'::text)
  • Rows Removed by Filter: 23206776
Planning time : 0.517 ms
Execution time : 22,047.997 ms