explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gL0Q

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 3.776 ↑ 1.0 100 1

Limit (cost=4.240..5,053.070 rows=100 width=1,956) (actual time=0.086..3.776 rows=100 loops=1)

2. 0.095 3.766 ↑ 1,298.9 100 1

Nested Loop Left Join (cost=4.240..6,558,132.180 rows=129,894 width=1,956) (actual time=0.085..3.766 rows=100 loops=1)

  • Join Filter: (whiskey_five.quebec_seven = sierra.whiskey_foxtrot)
  • Rows Removed by Join Filter: 992
3. 0.203 3.571 ↑ 1,298.9 100 1

Nested Loop Left Join (cost=4.240..6,536,698.530 rows=129,894 width=1,883) (actual time=0.080..3.571 rows=100 loops=1)

  • Join Filter: (five_oscar.quebec_seven = sierra.five_four)
  • Rows Removed by Join Filter: 1015
4. 0.039 3.368 ↑ 1,298.9 100 1

Nested Loop Left Join (cost=4.240..6,515,264.880 rows=129,894 width=1,810) (actual time=0.068..3.368 rows=100 loops=1)

5. 0.055 2.829 ↑ 1,298.9 100 1

Nested Loop Left Join (cost=3.680..5,522,375.420 rows=129,894 width=1,637) (actual time=0.060..2.829 rows=100 loops=1)

6. 0.027 2.274 ↑ 1,298.9 100 1

Nested Loop (cost=3.110..4,519,725.230 rows=129,894 width=1,579) (actual time=0.053..2.274 rows=100 loops=1)

7. 0.070 1.747 ↑ 1,298.9 100 1

Nested Loop (cost=2.550..3,511,739.030 rows=129,894 width=1,507) (actual time=0.045..1.747 rows=100 loops=1)

8. 0.032 1.677 ↑ 1,298.9 100 1

Nested Loop (cost=2.130..3,510,106.920 rows=129,894 width=1,422) (actual time=0.037..1.677 rows=100 loops=1)

9. 0.019 1.145 ↑ 1,298.9 100 1

Nested Loop (cost=1.560..2,507,180.730 rows=129,894 width=1,373) (actual time=0.029..1.145 rows=100 loops=1)

10. 0.083 0.626 ↑ 1,298.9 100 1

Nested Loop (cost=1.000..1,462,510.530 rows=129,894 width=484) (actual time=0.021..0.626 rows=100 loops=1)

11. 0.143 0.143 ↑ 1,298.9 100 1

Index Scan Backward using kilo_three on sierra (cost=0.560..511,794.560 rows=129,894 width=386) (actual time=0.013..0.143 rows=100 loops=1)

  • Index Cond: (bravo = 'kilo_delta_echo_six'::uuid)
12. 0.400 0.400 ↑ 1.0 1 100

Index Scan using yankee_three on lima (cost=0.430..7.310 rows=1 width=98) (actual time=0.004..0.004 rows=1 loops=100)

  • Index Cond: (juliet_delta = sierra.victor_foxtrot)
13. 0.500 0.500 ↑ 1.0 1 100

Index Scan using kilo_delta_echo_foxtrot on two (cost=0.560..8.030 rows=1 width=889) (actual time=0.005..0.005 rows=1 loops=100)

  • Index Cond: (juliet_delta = sierra.delta)
14. 0.500 0.500 ↑ 1.0 1 100

Index Scan using seven_two on six (cost=0.560..7.710 rows=1 width=49) (actual time=0.005..0.005 rows=1 loops=100)

  • Index Cond: (juliet_delta = sierra.romeo)
15. 0.000 0.000 ↑ 1.0 1 100

Materialize (cost=0.420..8.440 rows=1 width=85) (actual time=0.000..0.000 rows=1 loops=100)

16. 0.006 0.006 ↑ 1.0 1 1

Index Scan using victor_three on tango (cost=0.420..8.440 rows=1 width=85) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (juliet_delta = 'kilo_delta_echo_six'::uuid)
17. 0.500 0.500 ↑ 1.0 1 100

Index Scan using quebec_five on five_bravo (cost=0.560..7.750 rows=1 width=72) (actual time=0.005..0.005 rows=1 loops=100)

  • Index Cond: (juliet_delta = sierra.yankee_oscar)
18. 0.500 0.500 ↑ 1.0 1 100

Index Scan using seven_five on golf (cost=0.560..7.710 rows=1 width=58) (actual time=0.005..0.005 rows=1 loops=100)

  • Index Cond: (juliet_delta = sierra.hotel)
19. 0.500 0.500 ↑ 1.0 1 100

Index Scan using alpha on yankee_zulu (cost=0.560..7.630 rows=1 width=173) (actual time=0.004..0.005 rows=1 loops=100)

  • Index Cond: (juliet_delta = sierra.juliet_foxtrot)
20. 0.000 0.000 ↑ 1.0 11 100

Materialize (cost=0.000..1.170 rows=11 width=73) (actual time=0.000..0.000 rows=11 loops=100)

21. 0.004 0.004 ↑ 1.0 11 1

Seq Scan on five_oscar (cost=0.000..1.110 rows=11 width=73) (actual time=0.004..0.004 rows=11 loops=1)

22. 0.097 0.100 ↑ 1.0 11 100

Materialize (cost=0.000..1.170 rows=11 width=73) (actual time=0.000..0.001 rows=11 loops=100)

23. 0.003 0.003 ↑ 1.0 11 1

Seq Scan on five_oscar whiskey_five (cost=0.000..1.110 rows=11 width=73) (actual time=0.001..0.003 rows=11 loops=1)