explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iWYk

Settings
# exclusive inclusive rows x rows loops node
1. 1.036 12,643.723 ↑ 4.8 12 1

Sort (cost=12,146.020..12,146.170 rows=58 width=196) (actual time=12,643.719..12,643.723 rows=12 loops=1)

  • Sort Key: mike.quebec_seven
  • Sort Method: quicksort Memory: 31kB
2. 0.671 12,642.687 ↑ 4.8 12 1

Hash Left Join (cost=3.980..12,144.320 rows=58 width=196) (actual time=1,208.351..12,642.687 rows=12 loops=1)

  • Hash Cond: (mike.zulu_foxtrot = sierra1.quebec_seven)
3. 34.999 34.999 ↑ 4.8 12 1

Index Scan using romeo on mike (cost=0.280..5.290 rows=58 width=142) (actual time=0.057..34.999 rows=12 loops=1)

4. 0.024 0.033 ↑ 1.0 76 1

Hash (cost=2.760..2.760 rows=76 width=54) (actual time=0.033..0.033 rows=76 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 15kB
5. 0.009 0.009 ↑ 1.0 76 1

Seq Scan on whiskey quebec_golf (cost=0.000..2.760 rows=76 width=54) (actual time=0.003..0.009 rows=76 loops=1)

6.          

SubPlan (for Hash Left Join)

7. 0.576 12,399.528 ↑ 1.0 1 12

Aggregate (cost=197.840..197.850 rows=1 width=33) (actual time=1,033.294..1,033.294 rows=1 loops=12)

8. 0.120 12,398.952 ↓ 2.0 2 12

Subquery Scan on india (cost=0.560..197.840 rows=1 width=33) (actual time=637.861..1,033.246 rows=2 loops=12)

9. 0.396 12,398.832 ↓ 2.0 2 12

GroupAggregate (cost=0.560..197.830 rows=1 width=9) (actual time=637.855..1,033.236 rows=2 loops=12)

  • Group Key: foxtrot.juliet
10. 12,398.436 12,398.436 ↓ 3.0 9 12

Index Scan using uniform on foxtrot (cost=0.560..197.800 rows=3 width=9) (actual time=256.085..1,033.203 rows=9 loops=12)

  • Index Cond: ((juliet)::text = ANY ('kilo'::text[]))
  • Filter: (mike.quebec_seven = zulu_two)
  • Rows Removed by Filter: 384
11. 0.228 0.228 ↑ 1.0 1 12

Seq Scan on whiskey (cost=0.000..2.950 rows=1 width=13) (actual time=0.017..0.019 rows=1 loops=12)

  • Filter: (mike.zulu_foxtrot = quebec_seven)
  • Rows Removed by Filter: 75
12. 0.144 0.144 ↑ 1.0 1 12

Seq Scan on whiskey zulu_zulu (cost=0.000..2.950 rows=1 width=13) (actual time=0.011..0.012 rows=1 loops=12)

  • Filter: (mike.zulu_foxtrot = quebec_seven)
  • Rows Removed by Filter: 75
13. 0.096 207.084 ↑ 1.0 1 12

Aggregate (cost=5.440..5.450 rows=1 width=0) (actual time=17.256..17.257 rows=1 loops=12)

14. 206.988 206.988 ↑ 1.0 1 12

Index Scan using romeo on mike zulu_sierra (cost=0.280..5.440 rows=1 width=0) (actual time=0.029..17.249 rows=1 loops=12)

  • Filter: (zulu_foxtrot = sierra1.quebec_seven)
  • Rows Removed by Filter: 11
Planning time : 0.662 ms
Execution time : 12,643.906 ms