explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2sVe

Settings
# exclusive inclusive rows x rows loops node
1. 22.576 400.183 ↑ 3.3 367 1

Gather (cost=1,000.00..367,195.79 rows=1,199 width=198) (actual time=0.732..400.183 rows=367 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=544 read=302986
2. 377.607 377.607 ↑ 4.1 122 3 / 3

Parallel Seq Scan on geoname (cost=0.00..366,075.89 rows=500 width=198) (actual time=0.778..377.607 rows=122 loops=3)

  • Filter: ((name)::text ~~ 'Georgia%'::text)
  • Rows Removed by Filter: 4001857
  • Buffers: shared hit=544 read=302986
Planning time : 0.184 ms
Execution time : 400.244 ms