explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nvH8

Settings
# exclusive inclusive rows x rows loops node
1. 0.386 9.869 ↑ 1.0 19 1

Hash Join (cost=45.620..69.890 rows=19 width=246) (actual time=9.300..9.869 rows=19 loops=1)

  • Hash Cond: ((alpha_tango.quebec)::text = ("sierra"."alpha_hotel")::text)
2. 0.241 0.241 ↑ 1.0 21 1

Seq Scan on alpha_tango (cost=0.000..24.210 rows=21 width=190) (actual time=0.018..0.241 rows=21 loops=1)

3. 0.202 9.242 ↑ 1.0 19 1

Hash (cost=45.380..45.380 rows=19 width=56) (actual time=9.234..9.242 rows=19 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
4. 2.144 9.040 ↑ 1.0 19 1

Unique (cost=44.140..45.190 rows=19 width=56) (actual time=4.966..9.040 rows=19 loops=1)

5. 4.651 6.896 ↑ 1.0 209 1

Sort (cost=44.140..44.670 rows=209 width=56) (actual time=4.947..6.896 rows=209 loops=1)

  • Sort Key: "sierra"."alpha_hotel", "sierra"."seven" DESC
  • Sort Method: quicksort Memory: 51kB
6. 2.245 2.245 ↑ 1.0 209 1

Seq Scan on sierra (cost=0.000..36.090 rows=209 width=56) (actual time=0.016..2.245 rows=209 loops=1)