explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TLgw

Settings
# exclusive inclusive rows x rows loops node
1. 36.880 58.684 ↓ 2.0 4,096 1

Hash Join (cost=1.02..92.23 rows=2,048 width=351) (actual time=1.366..58.684 rows=4,096 loops=1)

  • Hash Cond: (("outer".last_name)::text = ("inner".last_name)::text)
2. 21.658 21.658 ↑ 1.0 2,048 1

Seq Scan on customer (cost=0.00..60.48 rows=2,048 width=107) (actual time=0.079..21.658 rows=2,048 loops=1)

3. 0.146 0.146 ↑ 1.0 2 1

Hash (cost=1.02..1.02 rows=2 width=287) (actual time=0.146..0.146 rows=2 loops=1)

4. 0.000 0.000 ↓ 0.0

Seq Scan on contact (cost=0.00..1.02 rows=2 width=287) (actual rows= loops=)

  • (actual time=0.074..0.088 rows=2 loops=1)
Total runtime : 62.233 ms