explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OSfo

Settings
# exclusive inclusive rows x rows loops node
1. 1.978 27,159.421 ↑ 1.2 185 1

GroupAggregate (cost=773,949.19..774,330.36 rows=229 width=20) (actual time=27,157.031..27,159.421 rows=185 loops=1)

  • Group Key: c.name
2. 145.085 27,157.443 ↑ 5.4 9,131 1

Sort (cost=773,949.19..774,072.43 rows=49,296 width=12) (actual time=27,157.017..27,157.443 rows=9,131 loops=1)

  • Sort Key: c.name
  • Sort Method: quicksort Memory: 849kB
3. 26,891.260 27,012.358 ↑ 5.4 9,131 1

Nested Loop (cost=0.00..770,106.77 rows=49,296 width=12) (actual time=0.029..27,012.358 rows=9,131 loops=1)

  • Join Filter: ((c.way && p.way) AND _st_intersects(c.way, p.way))
  • Rows Removed by Join Filter: 2512405
4. 2.330 2.330 ↑ 1.0 9,136 1

Seq Scan on cities p (cost=0.00..990.80 rows=9,136 width=32) (actual time=0.003..2.330 rows=9,136 loops=1)

5. 118.685 118.768 ↑ 1.0 276 9,136

Materialize (cost=0.00..48.18 rows=276 width=245,965) (actual time=0.000..0.013 rows=276 loops=9,136)

6. 0.083 0.083 ↑ 1.0 276 1

Seq Scan on adm2 c (cost=0.00..46.80 rows=276 width=245,965) (actual time=0.003..0.083 rows=276 loops=1)