explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8erP : Titile

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 5.634 ↑ 1.0 1 1

Aggregate (cost=344.100..344.110 rows=1 width=8) (actual time=5.634..5.634 rows=1 loops=1)

2. 0.012 5.630 ↑ 27.0 2 1

GroupAggregate (cost=342.340..343.420 rows=54 width=16) (actual time=5.624..5.630 rows=2 loops=1)

  • Group Key: echo.kilo_seven
3. 0.019 5.618 ↑ 2.6 21 1

Sort (cost=342.340..342.470 rows=54 width=16) (actual time=5.616..5.618 rows=21 loops=1)

  • Sort Key: echo.kilo_seven
  • Sort Method: quicksort Memory: 25kB
4. 0.006 5.599 ↑ 2.6 21 1

Subquery Scan on echo (cost=339.710..340.790 rows=54 width=16) (actual time=5.588..5.599 rows=21 loops=1)

5. 0.284 5.593 ↑ 2.6 21 1

HashAggregate (cost=339.710..340.250 rows=54 width=24) (actual time=5.586..5.593 rows=21 loops=1)

  • Group Key: kilo_tango.papa_oscar, quebec.kilo_seven
6. 0.141 0.284 ↓ 1.1 201 1

Hash Join (cost=2.380..9.710 rows=176 width=28) (actual time=0.120..0.284 rows=201 loops=1)

  • Hash Cond: (kilo_tango.yankee = quebec.yankee)
7. 0.043 0.043 ↓ 1.1 205 1

Seq Scan on hotel kilo_tango (cost=0.000..6.820 rows=182 width=16) (actual time=0.010..0.043 rows=205 loops=1)

8. 0.051 0.100 ↓ 1.6 86 1

Hash (cost=1.700..1.700 rows=54 width=20) (actual time=0.100..0.100 rows=86 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 13kB
9. 0.049 0.049 ↓ 1.6 86 1

Seq Scan on delta quebec (cost=0.000..1.700 rows=54 width=20) (actual time=0.011..0.049 rows=86 loops=1)

  • Filter: ((kilo_seven)::text = ANY ('papa_mike'::text[]))
  • Rows Removed by Filter: 2
10.          

SubPlan (for HashAggregate)

11. 0.603 5.025 ↑ 1.0 1 201

Aggregate (cost=1.850..1.860 rows=1 width=8) (actual time=0.025..0.025 rows=1 loops=201)

12. 4.422 4.422 ↓ 3.7 11 201

Seq Scan on delta xray (cost=0.000..1.840 rows=3 width=4) (actual time=0.006..0.022 rows=11 loops=201)

  • Filter: ((uniform = quebec.uniform) AND ((kilo_seven)::text = (quebec.kilo_seven)::text))
  • Rows Removed by Filter: 77
Planning time : 0.486 ms
Execution time : 5.751 ms