explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oN0j

Settings
# exclusive inclusive rows x rows loops node
1. 6.856 12,672.904 ↑ 1.0 1 1

Aggregate (cost=74,251,001.770..74,251,001.780 rows=1 width=40) (actual time=12,672.904..12,672.904 rows=1 loops=1)

2. 1.227 12,666.048 ↑ 45.0 1,810 1

Unique (cost=74,239,196.130..74,240,825.640 rows=81,409 width=16) (actual time=12,664.193..12,666.048 rows=1,810 loops=1)

3. 12.678 12,664.821 ↑ 22.1 9,849 1

Sort (cost=74,239,196.130..74,239,739.300 rows=217,268 width=16) (actual time=12,664.192..12,664.821 rows=9,849 loops=1)

  • Sort Key: seven_bravo.victor_kilo, seven_bravo.yankee_hotel
  • Sort Method: quicksort Memory: 846kB
4. 18.358 12,652.143 ↑ 22.1 9,849 1

Nested Loop (cost=0.990..74,216,222.780 rows=217,268 width=16) (actual time=9,109.588..12,652.143 rows=9,849 loops=1)

  • Join Filter: (quebec_sierra_sierra.xray_yankee = lima.quebec_seven)
  • Rows Removed by Join Filter: 127860
5. 85.055 12,614.087 ↑ 22.1 9,849 1

Nested Loop (cost=0.990..74,131,254.150 rows=217,268 width=24) (actual time=9,109.565..12,614.087 rows=9,849 loops=1)

  • Join Filter: (charlie.quebec_seven = seven_bravo.november_oscar)
  • Rows Removed by Join Filter: 571242
6. 1,325.771 12,479.787 ↑ 22.1 9,849 1

Index Scan using victor_seven on seven_five seven_bravo (cost=0.420..73,938,501.210 rows=217,268 width=32) (actual time=9,109.474..12,479.787 rows=9,849 loops=1)

  • Index Cond: (yankee_hotel < 'six_quebec'::timestamp without time zone)
  • Filter: ((delta 1) AND ((delta 3) <> november_november ('quebec_bravo'::integer[])))
  • Rows Removed by Filter: 429296
7.          

SubPlan (for Index Scan)

8. 2,195.725 8,343.755 ↑ 1.0 1 439,145

Aggregate (cost=23.970..23.980 rows=1 width=1) (actual time=0.019..0.019 rows=1 loops=439,145)

9. 3,952.305 6,148.030 ↑ 1.0 2 439,145

Bitmap Heap Scan on five_sierra sierra (cost=4.460..23.960 rows=2 width=0) (actual time=0.011..0.014 rows=2 loops=439,145)

  • Recheck Cond: (victor_kilo = seven_bravo.victor_kilo)
  • Filter: ((six_zulu <= 'six_quebec'::timestamp without time zone) AND (tango_hotel = ANY ('india'::integer[])))
  • Rows Removed by Filter: 4
  • Heap Blocks: exact=2427605
10. 2,195.725 2,195.725 ↓ 1.2 6 439,145

Bitmap Index Scan on golf_charlie (cost=0.000..4.460 rows=5 width=0) (actual time=0.005..0.005 rows=6 loops=439,145)

  • Index Cond: (victor_kilo = seven_bravo.victor_kilo)
11. 294.608 2,810.261 ↑ 1.0 1 18,611

Index Scan using golf_charlie on five_sierra yankee_lima (cost=0.420..144.390 rows=1 width=4) (actual time=0.088..0.151 rows=1 loops=18,611)

  • Index Cond: (victor_kilo = seven_bravo.victor_kilo)
  • Filter: (alpha = (delta 2))
  • Rows Removed by Filter: 5
12.          

SubPlan (for Index Scan)

13. 598.965 2,515.653 ↑ 1.0 1 119,793

Aggregate (cost=23.960..23.970 rows=1 width=8) (actual time=0.021..0.021 rows=1 loops=119,793)

14. 1,197.930 1,916.688 ↓ 1.2 6 119,793

Bitmap Heap Scan on five_sierra quebec_sierra_india (cost=4.460..23.950 rows=5 width=8) (actual time=0.010..0.016 rows=6 loops=119,793)

  • Recheck Cond: (victor_kilo = seven_bravo3.victor_kilo)
  • Filter: (six_zulu <= 'six_quebec'::timestamp without time zone)
  • Rows Removed by Filter: 2
  • Heap Blocks: exact=894255
15. 718.758 718.758 ↓ 1.6 8 119,793

Bitmap Index Scan on golf_charlie (cost=0.000..4.460 rows=5 width=0) (actual time=0.006..0.006 rows=8 loops=119,793)

  • Index Cond: (victor_kilo = seven_bravo3.victor_kilo)
16. 48.839 49.245 ↑ 1.0 59 9,849

Materialize (cost=0.570..470.910 rows=59 width=16) (actual time=0.000..0.005 rows=59 loops=9,849)

17. 0.046 0.406 ↑ 1.0 59 1

Nested Loop (cost=0.570..470.610 rows=59 width=16) (actual time=0.045..0.406 rows=59 loops=1)

18. 0.045 0.242 ↑ 1.0 59 1

Nested Loop (cost=0.290..452.730 rows=59 width=16) (actual time=0.029..0.242 rows=59 loops=1)

19. 0.020 0.020 ↑ 1.0 59 1

Seq Scan on five_delta charlie (cost=0.000..2.590 rows=59 width=16) (actual time=0.010..0.020 rows=59 loops=1)

20. 0.177 0.177 ↑ 1.0 1 59

Index Scan using quebec_hotel on seven_tango bravo_hotel (cost=0.290..7.630 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=59)

  • Index Cond: (quebec_seven = charlie.foxtrot)
21. 0.118 0.118 ↑ 1.0 1 59

Index Scan using xray_charlie on bravo_uniform quebec_sierra_sierra (cost=0.280..0.300 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=59)

  • Index Cond: (quebec_seven = bravo_hotel.tango_seven)
22. 19.686 19.698 ↑ 1.9 14 9,849

Materialize (cost=0.000..1.410 rows=27 width=8) (actual time=0.001..0.002 rows=14 loops=9,849)

23. 0.012 0.012 ↑ 1.0 27 1

Seq Scan on golf_uniform lima (cost=0.000..1.270 rows=27 width=8) (actual time=0.007..0.012 rows=27 loops=1)