explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 34sX

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.003 1.933 ↓ 4.0 4 1

Group (cost=225.880..225.890 rows=1 width=108) (actual time=1.931..1.933 rows=4 loops=1)

  • Group Key: delta.quebec, six.bravo, zulu.romeo
2. 0.020 1.930 ↓ 4.0 4 1

Sort (cost=225.880..225.880 rows=1 width=108) (actual time=1.930..1.930 rows=4 loops=1)

  • Sort Key: delta.quebec, six.bravo, zulu.romeo
  • Sort Method: quicksort Memory: 25kB
3. 0.015 1.910 ↓ 4.0 4 1

Nested Loop (cost=130.830..225.870 rows=1 width=108) (actual time=1.631..1.910 rows=4 loops=1)

4. 0.037 1.895 ↓ 4.0 4 1

Nested Loop (cost=130.550..225.490 rows=1 width=101) (actual time=1.626..1.895 rows=4 loops=1)

  • Join Filter: (zulu.quebec = delta.quebec)
5. 0.182 1.858 ↑ 18.8 4 1

Hash Join (cost=130.270..190.420 rows=75 width=40) (actual time=1.604..1.858 rows=4 loops=1)

  • Hash Cond: (seven.hotel = zulu.hotel)
6. 1.240 1.661 ↓ 1.0 2,515 1

HashAggregate (cost=129.140..154.150 rows=2,501 width=16) (actual time=1.343..1.661 rows=2,515 loops=1)

  • Group Key: seven.hotel
7. 0.421 0.421 ↑ 1.0 3,409 1

Seq Scan on seven (cost=0.000..112.090 rows=3,409 width=16) (actual time=0.003..0.421 rows=3,409 loops=1)

8. 0.015 0.015 ↑ 1.5 4 1

Hash (cost=1.060..1.060 rows=6 width=24) (actual time=0.015..0.015 rows=4 loops=1)