explain.depesz.com

PostgreSQL's explain analyze made readable

Result: h1TX

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 1,080.342 ↑ 2.5 2 1

Nested Loop (cost=650.950..29,663.470 rows=5 width=184) (actual time=534.076..1,080.342 rows=2 loops=1)

2. 0.091 0.091 ↑ 1.0 1 1

Index Only Scan using hotel_four on mike lima (cost=0.420..8.440 rows=1 width=32) (actual time=0.059..0.091 rows=1 loops=1)

  • Index Cond: (quebec_seven = 'three'::text)
  • Heap Fetches: 0
3. 0.598 1,080.233 ↑ 2.5 2 1

Nested Loop (cost=650.530..29,654.980 rows=5 width=185) (actual time=534.014..1,080.233 rows=2 loops=1)

4. 0.553 3.395 ↑ 1.1 40 1

Nested Loop (cost=1.110..242.990 rows=45 width=66) (actual time=0.106..3.395 rows=40 loops=1)

5. 0.282 0.282 ↑ 1.1 40 1

Index Only Scan using sierra on tango papa_zulu (cost=0.560..13.340 rows=45 width=66) (actual time=0.066..0.282 rows=40 loops=1)

  • Index Cond: (whiskey = 'three'::text)
  • Heap Fetches: 0
6. 2.560 2.560 ↑ 1.0 1 40

Index Only Scan using papa_echo on bravo echo (cost=0.550..5.100 rows=1 width=33) (actual time=0.064..0.064 rows=1 loops=40)

  • Index Cond: (quebec_seven = (papa_zulu.foxtrot)::text)
  • Heap Fetches: 13
7. 0.320 1,076.240 ↓ 0.0 0 40

Bitmap Heap Scan on romeo quebec_echo (cost=649.420..653.530 rows=7 width=152) (actual time=26.906..26.906 rows=0 loops=40)

  • Recheck Cond: (((hotel_mike1)::text = (echo.quebec_seven)::text) OR ((hotel_mike2)::text = (echo.quebec_seven)::text))
  • Heap Blocks: exact=2
8. 0.280 1,075.920 ↓ 0.0 0 40

BitmapOr (cost=649.420..649.420 rows=7 width=0) (actual time=26.898..26.898 rows=0 loops=40)

9. 1.600 1.600 ↓ 0.0 0 40

Bitmap Index Scan on four (cost=0.000..0.610 rows=4 width=0) (actual time=0.040..0.040 rows=0 loops=40)

  • Index Cond: ((hotel_mike1)::text = (echo.quebec_seven)::text)
10. 1,074.040 1,074.040 ↓ 0.0 0 40

Bitmap Index Scan on four (cost=0.000..648.810 rows=3 width=0) (actual time=26.851..26.851 rows=0 loops=40)

  • Index Cond: ((hotel_mike2)::text = (echo.quebec_seven)::text)
Planning time : 2.501 ms
Execution time : 1,080.529 ms