explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rs0Z

Settings
# exclusive inclusive rows x rows loops node
1. 0.429 11.486 ↑ 1.0 19 1

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

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

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

3. 0.184 10.814 ↑ 1.0 19 1

Hash (cost=45.380..45.380 rows=19 width=56) (actual time=10.806..10.814 rows=19 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
4. 2.074 10.630 ↑ 1.0 19 1

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

5. 5.199 8.556 ↑ 1.0 209 1

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

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

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

Planning time : 0.882 ms
Execution time : 11.880 ms