explain.depesz.com

PostgreSQL's explain analyze made readable

Result: A0BO

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

Aggregate (cost=156,933.610..156,933.620 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

HashAggregate (cost=156,929.110..156,931.110 rows=200 width=13) (actual rows= loops=)

  • Group Key: yankee_november21kilo_oscar147five_juliet.papa_two
3. 0.000 0.000 ↓ 0.0

Append (cost=0.280..144,433.010 rows=4,998,438 width=13) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Only Scan using papa_lima on sierra_seven (cost=0.280..6.050 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (sierra_delta = 'golf_two'::text)
5. 0.000 0.000 ↓ 0.0

Index Only Scan using kilo_india on quebec_november (cost=0.410..6.180 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (sierra_delta = 'golf_two'::text)
6. 0.000 0.000 ↓ 0.0

Index Only Scan using xray_delta on foxtrot (cost=0.410..6.180 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (sierra_delta = 'golf_two'::text)
7. 0.000 0.000 ↓ 0.0

Index Only Scan using golf_quebec on quebec_whiskey (cost=0.410..6.180 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (sierra_delta = 'golf_two'::text)
8. 0.000 0.000 ↓ 0.0

Index Only Scan using november on whiskey_yankee_kilo (cost=0.280..6.040 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (sierra_delta = 'golf_two'::text)
9. 0.000 0.000 ↓ 0.0

Index Only Scan using oscar_echo on whiskey_hotel (cost=0.280..6.050 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (sierra_delta = 'golf_two'::text)
10. 0.000 0.000 ↓ 0.0

Index Only Scan using sierra_victor on kilo_five (cost=0.410..6.180 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (sierra_delta = 'golf_two'::text)
11. 0.000 0.000 ↓ 0.0

Index Only Scan using six_zulu on papa_yankee (cost=0.410..6.180 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (sierra_delta = 'golf_two'::text)
12. 0.000 0.000 ↓ 0.0

Index Only Scan using xray_yankee on echo_kilo (cost=0.420..8.440 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (sierra_delta = 'golf_two'::text)
13. 0.000 0.000 ↓ 0.0

Index Only Scan using zulu_juliet on seven (cost=0.420..8.440 rows=1 width=11) (actual rows= loops=)

  • Index Cond: (sierra_delta = 'golf_two'::text)
14. 0.000 0.000 ↓ 0.0

Index Only Scan using oscar_two on six_echo (cost=0.420..8.440 rows=1 width=10) (actual rows= loops=)

  • Index Cond: (sierra_delta = 'golf_two'::text)
15. 0.000 0.000 ↓ 0.0

Index Only Scan using alpha_juliet on kilo_xray (cost=0.420..6.190 rows=1 width=10) (actual rows= loops=)

  • Index Cond: (sierra_delta = 'golf_two'::text)
16. 0.000 0.000 ↓ 0.0

Index Only Scan using romeo_six on whiskey_juliet (cost=0.420..8.440 rows=1 width=10) (actual rows= loops=)

  • Index Cond: (sierra_delta = 'golf_two'::text)
17. 0.000 0.000 ↓ 0.0

Index Only Scan using four_hotel on delta (cost=0.420..6.190 rows=1 width=10) (actual rows= loops=)

  • Index Cond: (sierra_delta = 'golf_two'::text)
18. 0.000 0.000 ↓ 0.0

Index Only Scan using whiskey_yankee_four on five_bravo (cost=0.420..6.190 rows=1 width=9) (actual rows= loops=)

  • Index Cond: (sierra_delta = 'golf_two'::text)
19. 0.000 0.000 ↓ 0.0

Index Only Scan using alpha_mike on kilo_charlie (cost=0.420..6.190 rows=1 width=10) (actual rows= loops=)

  • Index Cond: (sierra_delta = 'golf_two'::text)
20. 0.000 0.000 ↓ 0.0

Index Only Scan using xray_tango on yankee_whiskey (cost=0.420..6.190 rows=1 width=11) (actual rows= loops=)

  • Index Cond: (sierra_delta = 'golf_two'::text)
21. 0.000 0.000 ↓ 0.0

Index Only Scan using papa_four on alpha_lima (cost=0.410..8.430 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (sierra_delta = 'golf_two'::text)
22. 0.000 0.000 ↓ 0.0

Index Only Scan using four_romeo on whiskey_seven (cost=0.560..8.570 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (sierra_delta = 'golf_two'::text)
23. 0.000 0.000 ↓ 0.0

Index Only Scan using six_six on xray_kilo (cost=0.550..6.320 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (sierra_delta = 'golf_two'::text)
24. 0.000 0.000 ↓ 0.0

Index Only Scan using lima_six on five_zulu (cost=0.410..6.180 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (sierra_delta = 'golf_two'::text)
25. 0.000 0.000 ↓ 0.0

Index Only Scan using lima_charlie on echo_romeo (cost=0.410..6.180 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (sierra_delta = 'golf_two'::text)
26. 0.000 0.000 ↓ 0.0

Index Only Scan using xray_six on lima_zulu (cost=0.420..6.190 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (sierra_delta = 'golf_two'::text)
27. 0.000 0.000 ↓ 0.0

Seq Scan on romeo_india (cost=0.000..2,242.550 rows=93,964 width=13) (actual rows= loops=)

  • Filter: (sierra_delta = 'golf_two'::text)
28. 0.000 0.000 ↓ 0.0

Seq Scan on five_quebec (cost=0.000..13,471.410 rows=564,513 width=13) (actual rows= loops=)

  • Filter: (sierra_delta = 'golf_two'::text)
29. 0.000 0.000 ↓ 0.0

Seq Scan on kilo_november (cost=0.000..17,320.690 rows=725,815 width=13) (actual rows= loops=)

  • Filter: (sierra_delta = 'golf_two'::text)
30. 0.000 0.000 ↓ 0.0

Seq Scan on tango (cost=0.000..15,213.730 rows=637,498 width=13) (actual rows= loops=)

  • Filter: (sierra_delta = 'golf_two'::text)
31. 0.000 0.000 ↓ 0.0

Seq Scan on victor_seven (cost=0.000..9,617.660 rows=403,013 width=13) (actual rows= loops=)

  • Filter: (sierra_delta = 'golf_two'::text)
32. 0.000 0.000 ↓ 0.0

Seq Scan on victor_india (cost=0.000..85.460 rows=3,557 width=13) (actual rows= loops=)

  • Filter: (sierra_delta = 'golf_two'::text)
33. 0.000 0.000 ↓ 0.0

Seq Scan on mike (cost=0.000..2,189.760 rows=91,741 width=13) (actual rows= loops=)

  • Filter: (sierra_delta = 'golf_two'::text)
34. 0.000 0.000 ↓ 0.0

Seq Scan on juliet (cost=0.000..14,096.950 rows=590,716 width=13) (actual rows= loops=)

  • Filter: (sierra_delta = 'golf_two'::text)
35. 0.000 0.000 ↓ 0.0

Seq Scan on four_golf (cost=0.000..17,328.590 rows=726,127 width=14) (actual rows= loops=)

  • Filter: (sierra_delta = 'golf_two'::text)
36. 0.000 0.000 ↓ 0.0

Seq Scan on quebec_papa (cost=0.000..17,574.850 rows=736,468 width=13) (actual rows= loops=)

  • Filter: (sierra_delta = 'golf_two'::text)
37. 0.000 0.000 ↓ 0.0

Seq Scan on bravo (cost=0.000..10,127.730 rows=424,378 width=13) (actual rows= loops=)

  • Filter: (sierra_delta = 'golf_two'::text)
38. 0.000 0.000 ↓ 0.0

Seq Scan on zulu_sierra (cost=0.000..15.810 rows=625 width=11) (actual rows= loops=)

  • Filter: (sierra_delta = 'golf_two'::text)