explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NmOr

Settings
# exclusive inclusive rows x rows loops node
1. 0.056 148,842.893 ↓ 3.0 3 1

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Unique (cost=12,170.33..12,170.43 rows=1 width=1,463) (actual time=148,842.825..148,842.893 rows=3 loops=1)

  • (actual time=0.452..0.853 rows=18 loops=2,815)
2. 0.339 148,842.837 ↓ 58.0 58 1

Sort (cost=12,170.33..12,170.34 rows=1 width=1,463) (actual time=148,842.824..148,842.837 rows=58 loops=1)

  • Sort Key: echo.quebec_seven, echo.india, echo.seven_papa, echo.romeo_hotel, echo.sierra, echo.november_lima, echo.kilo_india, echo.mike_quebec, echo.golf_six, echo.golf_two, echo.kilo_papa, echo.quebec_three, echo.juliet, echo.foxtrot_lima, echo.golf_whiskey, echo.romeo_four, echo.victor_alpha, echo.uniform_xray,echo.zulu_juliet, echo.xray_hotel_mike, echo.six_lima, echo.tango, echo.kilo_oscar, echo.delta_zulu, echo.zulu_two, echo.whiskey_india, echo.seven_victor, echo.charlie_papa, echo.hotel_whiskey, echo.hotel_india, echo.three, echo.papa_yankee, echo.victor_juliet, echo.victor_charlie, echo.delta_victor, echo.november_alpha
  • Sort Method: quicksort Memory: 54kB
3. 50.270 148,842.498 ↓ 58.0 58 1

Nested Loop (cost=59.98..12,170.32 rows=1 width=1,463) (actual time=58,545.880..148,842.498 rows=58 loops=1)

4. 2,436.432 147,517.303 ↓ 50,997.0 50,997 1

Nested Loop (cost=59.42..12,162.02 rows=1 width=1,475) (actual time=147.413..147,517.303 rows=50,997 loops=1)

5. 5.994 145,080.871 ↓ 2,815.0 2,815 1

Nested Loop (cost=58.85..10,605.97 rows=1 width=1,471) (actual time=145.533..145,080.871 rows=2,815 loops=1)

6. 55.789 142,811.617 ↓ 2,815.0 2,815 1

Nested Loop (cost=58.29..10,597.52 rows=1 width=8) (actual time=144.265..142,811.617 rows=2,815 loops=1)

7. 138,778.576 138,904.680 ↓ 16,891.0 50,673 1

Bitmap Heap Scan on kilo_xray yankee (cost=57.85..10,576.12 rows=3 width=4) (actual time=142.952..138,904.680 rows=50,673 loops=1)

  • Recheck Cond: (((lima)::text = 'oscar'::text) AND ((mike_tango)::text = 'uniform_sierra'::text))
  • Rows Removed by Index Recheck: 8,535,012
  • Filter: (six_mike ? 'mike_mike'::text)
  • Rows Removed by Filter: 274,281
  • Heap Blocks: exact=43,676 lossy=163,392
8. 126.104 126.104 ↓ 121.0 324,954 1

Bitmap Index Scan on kilo_juliet (cost=0.00..57.85 rows=2,686 width=0) (actual time=126.104..126.104 rows=324,954 loops=1)

9. 3,851.148 3,851.148 ↓ 0.0 0 50,673

Index Only Scan using four_bravo on quebec_oscar (cost=0.43..7.12 rows=1 width=4) (actual time=0.075..0.076 rows=0 loops=50,673)

  • Index Cond: ((whiskey_four = yankee.whiskey_four) AND (mike_juliet = 89,856))
  • Heap Fetches: 2,094
10. 2,263.260 2,263.260 ↑ 1.0 1 2,815

Index Scan using xray_hotel_november on echo (cost=0.56..8.44 rows=1 width=1,463) (actual time=0.802..0.804 rows=1 loops=2,815)

  • Index Cond: (quebec_seven = quebec_oscar.whiskey_four)
  • Filter: ((delta_quebec)::text = 'papa_alpha'::text)
11. 0.000 0.000 ↓ 0.0

Index Only Scan using uniform_juliet on kilo_xray (cost=0.57..1,549.38 rows=667 width=4) (actual rows= loops=)

  • Index Cond: (whiskey_four = echo.quebec_seven)
  • Heap Fetches: 28,080
12. 1,274.925 1,274.925 ↓ 0.0 0 50,997

Index Scan using kilo_golf on kilo_xray romeo_uniform (cost=0.57..8.29 rows=1 width=4) (actual time=0.025..0.025 rows=0 loops=50,997)

  • Index Cond: ((whiskey_four = kilo_xray.whiskey_four) AND ((lima)::text = 'kilo_six'::text) AND ((mike_tango)::text = 'foxtrot_sierra'::text))
  • Filter: ((six_mike ? 'four_four'::text) OR (six_mike @> 'four_four'::charlie_five))
  • Rows Removed by Filter: 1
Planning time : 4.481 ms
Execution time : 148,843.442 ms