explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jkCb

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 5,513.994 ↓ 0.0 0 1

Limit (cost=289,259.73..289,259.73 rows=1 width=35) (actual time=5,513.994..5,513.994 rows=0 loops=1)

2. 0.000 5,513.992 ↓ 0.0 0 1

Sort (cost=289,259.73..289,259.73 rows=1 width=35) (actual time=5,513.992..5,513.992 rows=0 loops=1)

  • Sort Key: importance DESC, (length(alternative_names)) DESC
  • Sort Method: quicksort Memory: 25kB
3. 462.768 5,553.608 ↓ 0.0 0 1

Gather (cost=1,000.00..289,259.72 rows=1 width=35) (actual time=5,513.976..5,553.608 rows=0 loops=1)

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

Parallel Seq Scan on osmnames o (cost=0.00..288,259.62 rows=1 width=35) (actual time=5,090.840..5,090.840 rows=0 loops=3)

  • Filter: (((type)::text <> 'island'::text) AND ((type)::text <> 'state'::text) AND ((type)::text <> 'county'::text) AND (name = 'Nein'::text) AND ((state)::text = ''::text) AND ((country_code)::text = 'il'::text) AND ((class)::text = 'boundary'::text))
  • Rows Removed by Filter: 2114520