explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 0Km

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

Limit (cost=77614.120..77622.120 rows=50 width=1745) (actual time=.. rows= loops=)

2. 0.000 0.000 ↓ 0.0
→

Unique (cost=77614.120..89689.960 rows=75474 width=1745) (actual time=.. rows= loops=)

3. 0.000 0.000 ↓ 0.0
→

Sort (cost=77614.120..77802.810 rows=75474 width=1745) (actual time=.. rows= loops=)

  • Sort Key: lima_five.quebec_seven, lima_five.whiskey_delta, lima_five.uniform, lima_five.juliet_delta, lima_five.xray, lima_five.lima_golf, lima_five.kilo_sierra, lima_five.zulu_yankee, lima_five.papa_echo, lima_five.four_echo, lima_five.echo_six, lima_five.charlie_four, lima_victor.zulu_lima, lima_victor.seven_golf, lima_victor.kilo_kilo, lima_victor.mike_mike, lima_victor.victor_charlie, lima_victor.victor_juliet, lima_victor.charlie_two, lima_victor.juliet_delta, lima_victor.kilo_sierra, lima_victor.hotel_romeo_three, lima_victor.seven_november, lima_victor.seven_juliet, lima_victor.juliet_lima, echo_foxtrot.quebec_seven, echo_foxtrot.romeo, echo_foxtrot.oscar_four, echo_foxtrot.november_lima, echo_foxtrot.alpha, "india_mike".hotel_romeo_whiskey, "india_mike".tango, "india_mike".oscar_quebec, "india_mike".five, "india_mike".mike_mike, "india_mike".seven_echo, "india_mike".juliet_delta, "india_mike".november_mike, "india_mike".golf, "india_mike".zulu_yankee, "india_mike".papa_kilo, "india_mike".lima_four, "india_mike".victor_xray, "india_mike".mike_three, "india_mike".juliet_three, "india_mike".six, delta_alpha.quebec_seven, delta_alpha.five, delta_alpha.kilo_papa, delta_alpha.mike_four, delta_alpha.oscar_charlie, quebec_juliet.quebec_seven, quebec_juliet.november_lima, quebec_juliet.zulu_mike, quebec_juliet.india_uniform, quebec_juliet.delta_romeo, quebec_juliet.five, quebec_juliet.four_hotel, quebec_juliet.sierra, quebec_juliet.foxtrot
4. 0.000 0.000 ↓ 0.0
→

Hash Left Join (cost=5311.710..14358.340 rows=75474 width=1745) (actual time=.. rows= loops=)

  • Hash Cond: (lima_five.kilo_sierra = quebec_juliet.quebec_seven)
5. 0.000 0.000 ↓ 0.0
→

Hash Left Join (cost=5309.900..13521.210 rows=75474 width=1178) (actual time=.. rows= loops=)

  • Hash Cond: (lima_five.uniform = delta_alpha.quebec_seven)
6. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=3373.740..10076.640 rows=75474 width=1150) (actual time=.. rows= loops=)

7. 0.000 0.000 ↓ 0.0
→

Seq Scan on india_mike (cost=0.000..5.010 rows=1 width=702) (actual time=.. rows= loops=)

  • Filter: (quebec_seven = 30)
8. 0.000 0.000 ↓ 0.0
→

Hash Left Join (cost=3373.740..9316.890 rows=75474 width=448) (actual time=.. rows= loops=)

  • Hash Cond: (lima_victor.kilo_sierra = echo_foxtrot.quebec_seven)
9. 0.000 0.000 ↓ 0.0
→

Hash Join (cost=3362.970..8353.470 rows=75474 width=201) (actual time=.. rows= loops=)

  • Hash Cond: (lima_five.whiskey_delta = lima_victor.quebec_seven)
10. 0.000 0.000 ↓ 0.0
→

Seq Scan on lima_five (cost=0.000..3103.650 rows=75474 width=79) (actual time=.. rows= loops=)

  • Filter: (zulu_yankee AND (whiskey_seven = 30))
11. 0.000 0.000 ↓ 0.0
→

Hash (cost=2340.210..2340.210 rows=81821 width=122) (actual time=.. rows= loops=)

12. 0.000 0.000 ↓ 0.0
→

Seq Scan on lima_victor (cost=0.000..2340.210 rows=81821 width=122) (actual time=.. rows= loops=)

13. 0.000 0.000 ↓ 0.0
→

Hash (cost=6.450..6.450 rows=345 width=247) (actual time=.. rows= loops=)

14. 0.000 0.000 ↓ 0.0
→

Seq Scan on echo_foxtrot (cost=0.000..6.450 rows=345 width=247) (actual time=.. rows= loops=)

15. 0.000 0.000 ↓ 0.0
→

Hash (cost=1085.520..1085.520 rows=68052 width=28) (actual time=.. rows= loops=)

16. 0.000 0.000 ↓ 0.0
→

Seq Scan on delta_alpha (cost=0.000..1085.520 rows=68052 width=28) (actual time=.. rows= loops=)

17. 0.000 0.000 ↓ 0.0
→

Hash (cost=1.360..1.360 rows=36 width=567) (actual time=.. rows= loops=)

18. 0.000 0.000 ↓ 0.0
→

Seq Scan on quebec_juliet (cost=0.000..1.360 rows=36 width=567) (actual time=.. rows= loops=)