explain.depesz.com

A tool for finding a real cause for slow queries.

Result: fIr : explain

options
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0
→

Limit (cost=309804005.990..309804020.670 rows=10 width=246) (actual time=.. rows= loops=)

2. 0.000 0.000 ↓ 0.0
→

GroupAggregate (cost=309804005.990..329640911.850 rows=13517118 width=246) (actual time=.. rows= loops=)

3. 0.000 0.000 ↓ 0.0
→

Sort (cost=309804005.990..312618539.520 rows=1125813410 width=246) (actual time=.. rows= loops=)

  • Sort Key: uniform.november_lima, uniform.alpha, hotel_six.five, golf.romeo
4. 0.000 0.000 ↓ 0.0
→

Nested Loop Left Join (cost=241.760..9715579.300 rows=1125813410 width=246) (actual time=.. rows= loops=)

5. 0.000 0.000 ↓ 0.0
→

Hash Join (cost=241.760..106716.250 rows=784814 width=242) (actual time=.. rows= loops=)

  • Hash Cond: (victor.alpha = uniform.alpha)
6. 0.000 0.000 ↓ 0.0
→

Hash Left Join (cost=240.550..95923.850 rows=784814 width=24) (actual time=.. rows= loops=)

  • Hash Cond: (golf.romeo = hotel_six.romeo)
7. 0.000 0.000 ↓ 0.0
→

Merge Join (cost=28.740..84920.850 rows=784814 width=12) (actual time=.. rows= loops=)

  • Merge Cond: (victor.india_foxtrot = golf.india_foxtrot)
8. 0.000 0.000 ↓ 0.0
→

Index Scan using india_five on victor (cost=0.000..2679.790 rows=62256 width=16) (actual time=.. rows= loops=)

9. 0.000 0.000 ↓ 0.0
→

Index Scan using tango on hotel_alpha golf (cost=0.000..72019.630 rows=781768 width=21) (actual time=.. rows= loops=)

10. 0.000 0.000 ↓ 0.0
→

Hash (cost=194.140..194.140 rows=1414 width=16) (actual time=.. rows= loops=)

11. 0.000 0.000 ↓ 0.0
→

Seq Scan on november_whiskey hotel_six (cost=0.000..194.140 rows=1414 width=16) (actual time=.. rows= loops=)

12. 0.000 0.000 ↓ 0.0
→

Hash (cost=1.090..1.090 rows=9 width=222) (actual time=.. rows= loops=)

13. 0.000 0.000 ↓ 0.0
→

Seq Scan on xray_tango uniform (cost=0.000..1.090 rows=9 width=222) (actual time=.. rows= loops=)

14. 0.000 0.000 ↓ 0.0
→

Index Scan using foxtrot on four xray_mike (cost=0.000..7.270 rows=398 width=8) (actual time=.. rows= loops=)

  • Index Cond: (romeo = golf.romeo)