explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Nf5U

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.454 ↑ 1.0 100 1

Limit (cost=9.35..15.09 rows=100 width=58) (actual time=0.200..0.454 rows=100 loops=1)

2. 0.388 0.388 ↑ 18.6 100 1

Hash Join (cost=9.35..116.04 rows=1,860 width=58) (actual time=0.199..0.388 rows=100 loops=1)

3. 0.061 0.061 ↑ 27.0 151 1

Seq Scan on city (cost=0.00..72.79 rows=4,079 width=31) (actual time=0.009..0.061 rows=151 loops=1)

4. 0.174 0.174 ↑ 1.0 109 1

Hash (cost=7.99..7.99 rows=109 width=31) (actual time=0.173..0.174 rows=109 loops=1)

5. 0.116 0.116 ↑ 1.0 109 1

Seq Scan on country (cost=0.00..7.99 rows=109 width=31) (actual time=0.005..0.116 rows=109 loops=1)