explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BdbU

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 312.884 ↑ 1.0 20 1

Limit (cost=2.810..222.430 rows=20 width=2,257) (actual time=48.029..312.884 rows=20 loops=1)

2. 0.089 312.869 ↑ 5,896.3 20 1

Merge Join (cost=2.810..1,294,945.080 rows=117,926 width=2,257) (actual time=48.028..312.869 rows=20 loops=1)

  • Merge Cond: (lima0kilo_oscar.uniform_mike = delta_seven6kilo_oscar.four_three)
3. 0.139 312.756 ↑ 5,896.3 20 1

Nested Loop (cost=2.540..1,292,904.680 rows=117,926 width=2,109) (actual time=47.997..312.756 rows=20 loops=1)

  • Join Filter: (bravo_quebec3kilo_oscar.tango = delta_tango4kilo_oscar.bravo_seven)
  • Rows Removed by Join Filter: 585
4. 0.130 312.537 ↑ 5,896.3 20 1

Nested Loop (cost=2.540..1,229,129.980 rows=117,926 width=2,030) (actual time=47.964..312.537 rows=20 loops=1)

5. 0.343 243.687 ↑ 5,896.3 20 1

Nested Loop (cost=1.980..948,097.330 rows=117,926 width=1,778) (actual time=46.530..243.687 rows=20 loops=1)

6. 0.121 183.704 ↑ 5,896.3 20 1

Nested Loop (cost=1.540..688,866.660 rows=117,926 width=1,663) (actual time=33.682..183.704 rows=20 loops=1)

7. 0.134 99.343 ↑ 5,896.3 20 1

Nested Loop Left Join (cost=1.110..426,994.290 rows=117,926 width=1,526) (actual time=25.519..99.343 rows=20 loops=1)

  • Filter: ((lima0kilo_oscar.xray five NULL) OR (bravo_quebec5kilo_oscar.romeo <> 0) OR (bravo_quebec5kilo_oscar.juliet_charlie <> november ('oscar_uniform'::integer[])))
8. 38.989 38.989 ↑ 5,896.7 20 1

Index Scan using seven_sierra on three delta_charlie (cost=0.540..130,366.890 rows=117,934 width=1,163) (actual time=15.598..38.989 rows=20 loops=1)

9. 60.220 60.220 ↑ 1.0 1 20

Index Scan using juliet_two on two_delta two_romeo (cost=0.570..2.500 rows=1 width=363) (actual time=3.011..3.011 rows=1 loops=20)

  • Index Cond: (lima0kilo_oscar.xray = quebec)
10. 84.240 84.240 ↑ 1.0 1 20

Index Scan using golf on kilo_tango echo (cost=0.430..2.220 rows=1 width=137) (actual time=4.212..4.212 rows=1 loops=20)

  • Index Cond: (uniform_whiskey = lima0kilo_oscar.india)
11. 59.640 59.640 ↑ 1.0 1 20

Index Scan using sierra_india on sierra_zulu two_four (cost=0.430..2.200 rows=1 width=115) (actual time=2.982..2.982 rows=1 loops=20)

  • Index Cond: (quebec = bravo_charlie1kilo_oscar.uniform_echo)
12. 68.720 68.720 ↑ 1.0 1 20

Index Scan using alpha on seven_lima six (cost=0.560..2.380 rows=1 width=252) (actual time=3.436..3.436 rows=1 loops=20)

  • Index Cond: (victor = lima0kilo_oscar.four_victor)
13. 0.070 0.080 ↑ 1.2 30 20

Materialize (cost=0.000..1.560 rows=37 width=79) (actual time=0.002..0.004 rows=30 loops=20)

14. 0.010 0.010 ↑ 1.0 36 1

Seq Scan on uniform_oscar oscar_xray (cost=0.000..1.370 rows=37 width=79) (actual time=0.007..0.010 rows=36 loops=1)

15. 0.024 0.024 ↑ 252.3 3 1

Index Scan using delta_zulu on sierra_charlie seven_charlie (cost=0.280..565.930 rows=757 width=148) (actual time=0.020..0.024 rows=3 loops=1)