explain.depesz.com

A tool for finding a real cause for slow queries.

Result: fIr : explain

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=309,804,005.990..309,804,020.670 rows=10 width=246) (actual time=.. rows= loops=)

2. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=309,804,005.990..329,640,911.850 rows=13,517,118 width=246) (actual time=.. rows= loops=)

3. 0.000 0.000 ↓ 0.0

Sort (cost=309,804,005.990..312,618,539.520 rows=1,125,813,410 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..9,715,579.300 rows=1,125,813,410 width=246) (actual time=.. rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash Join (cost=241.760..106,716.250 rows=784,814 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..95,923.850 rows=784,814 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..84,920.850 rows=784,814 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..2,679.790 rows=62,256 width=16) (actual time=.. rows= loops=)

9. 0.000 0.000 ↓ 0.0

Index Scan using tango on hotel_alpha golf (cost=0.000..72,019.630 rows=781,768 width=21) (actual time=.. rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash (cost=194.140..194.140 rows=1,414 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=1,414 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)