explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AI5I

Settings
# exclusive inclusive rows x rows loops node
1. 881.271 5,635.112 ↑ 1.4 109,919 1

Sort (cost=119,125.710..119,509.910 rows=153,683 width=280) (actual time=5,524.169..5,635.112 rows=109,919 loops=1)

  • Sort Key: charlie_hotel2."quebec_golf", charlie_hotel2.quebec_seven
  • Sort Method: quicksort Memory: 32527kB
2. 425.472 4,753.841 ↑ 1.4 109,919 1

HashAggregate (cost=104,349.400..105,886.230 rows=153,683 width=280) (actual time=4,598.987..4,753.841 rows=109,919 loops=1)

  • Group Key: charlie_hotel2.quebec_seven
3. 573.273 4,328.369 ↑ 2.1 157,071 1

Nested Loop (cost=20,119.570..103,543.130 rows=322,508 width=280) (actual time=449.288..4,328.369 rows=157,071 loops=1)

  • Join Filter: (charlie_hotel2."three" = charlie_hotel3.quebec_seven)
4. 371.733 3,126.812 ↓ 2.6 157,071 1

Hash Join (cost=20,119.150..75,914.720 rows=60,020 width=296) (actual time=449.243..3,126.812 rows=157,071 loops=1)

  • Hash Cond: (charlie_hotel4."victor_two" = charlie_hotel5.quebec_seven)
5. 868.412 2,753.903 ↑ 1.2 223,138 1

Merge Join (cost=20,016.010..74,194.670 rows=271,122 width=312) (actual time=448.056..2,753.903 rows=223,138 loops=1)

  • Merge Cond: (charlie_hotel4."three" = charlie_hotel2."three")
6. 1,190.065 1,190.065 ↑ 8.9 468,119 1

Index Scan using oscar on kilo_juliet foxtrot (cost=0.430..452,982.240 rows=4,158,068 width=32) (actual time=0.008..1,190.065 rows=468,119 loops=1)

7. 505.674 695.426 ↓ 1.5 223,235 1

Sort (cost=20,010.310..20,394.520 rows=153,683 width=280) (actual time=447.404..695.426 rows=223,235 loops=1)

  • Sort Key: charlie_hotel2."six
  • Sort Method: quicksort Memory: 47375kB
8. 189.752 189.752 ↓ 1.0 153,686 1

Seq Scan on papa_yankee two_quebec (cost=0.000..6,770.830 rows=153,683 width=280) (actual time=0.014..189.752 rows=153,686 loops=1)

9. 0.382 1.176 ↓ 1.0 446 1

Hash (cost=97.670..97.670 rows=437 width=16) (actual time=1.175..1.176 rows=446 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 29kB
10. 0.794 0.794 ↓ 1.0 446 1

Seq Scan on golf india (cost=0.000..97.670 rows=437 width=16) (actual time=0.009..0.794 rows=446 loops=1)

  • Filter: ("kilo_two" = 'papa_romeo'::uuid)
  • Rows Removed by Filter: 1542
11. 628.284 628.284 ↑ 1.0 1 157,071

Index Only Scan using two_three on victor_uniform charlie_xray (cost=0.420..0.450 rows=1 width=16) (actual time=0.003..0.004 rows=1 loops=157,071)

  • Index Cond: (quebec_seven = charlie_hotel4."three")
  • Heap Fetches: 14822
Planning time : 1.068 ms
Execution time : 5,723.630 ms