explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lDLiC : Optimization for: CONS

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.070 24.889 ↓ 33.0 33 1

Sort (cost=7,488.920..7,488.920 rows=1 width=569) (actual time=24.865..24.889 rows=33 loops=1)

  • Sort Key: (whiskey(three.delta_india))
  • Sort Method: quicksort Memory: 29kB
2. 0.255 24.819 ↓ 33.0 33 1

HashAggregate (cost=7,488.900..7,488.910 rows=1 width=569) (actual time=24.784..24.819 rows=33 loops=1)

3. 0.167 24.564 ↓ 74.0 74 1

Nested Loop Anti Join (cost=119.500..7,488.880 rows=1 width=569) (actual time=0.292..24.564 rows=74 loops=1)

4. 0.261 23.287 ↓ 74.0 74 1

Nested Loop (cost=118.930..7,472.350 rows=1 width=606) (actual time=0.272..23.287 rows=74 loops=1)

5. 0.502 22.286 ↓ 74.0 74 1

Nested Loop (cost=118.650..7,464.230 rows=1 width=634) (actual time=0.257..22.286 rows=74 loops=1)

  • Join Filter: ((three.six_seven)::text = (romeo.quebec_seven)::text)
  • Rows Removed by Join Filter: 394
6. 0.023 0.023 ↑ 1.0 1 1

Seq Scan on yankee_alpha romeo (cost=0.000..1.500 rows=1 width=1,032) (actual time=0.014..0.023 rows=1 loops=1)

  • Filter: ((lima_tango)::text = 'delta_sierra'::text)
  • Rows Removed by Filter: 39
7. 1.836 21.761 ↓ 78.0 468 1

Nested Loop (cost=118.650..7,462.660 rows=6 width=155) (actual time=0.208..21.761 rows=468 loops=1)

8. 1.196 10.565 ↓ 78.0 468 1

Nested Loop (cost=117.960..7,410.520 rows=6 width=60) (actual time=0.183..10.565 rows=468 loops=1)

9. 0.612 4.973 ↓ 157.0 157 1

Nested Loop (cost=21.240..1,037.630 rows=1 width=97) (actual time=0.149..4.973 rows=157 loops=1)

10. 0.368 1.517 ↓ 158.0 158 1

Nested Loop (cost=20.680..1,029.070 rows=1 width=60) (actual time=0.125..1.517 rows=158 loops=1)

11. 0.105 0.192 ↓ 33.0 33 1

Bitmap Heap Scan on xray_lima (cost=10.160..14.170 rows=1 width=60) (actual time=0.097..0.192 rows=33 loops=1)

  • Recheck Cond: (((oscar_foxtrot)::text = 'bravo_lima'::text) AND ((bravo_xray)::text = 'victor_oscar'::text))
  • Filter: ((november five NULL) AND ((two)::text = 'seven'::text))
  • Rows Removed by Filter: 4
12. 0.008 0.087 ↓ 0.0 0 1

BitmapAnd (cost=10.160..10.160 rows=1 width=0) (actual time=0.087..0.087 rows=0 loops=1)

13. 0.035 0.035 ↑ 1.2 37 1

Bitmap Index Scan on yankee_tango (cost=0.000..4.900 rows=45 width=0) (actual time=0.035..0.035 rows=37 loops=1)

  • Index Cond: ((oscar_foxtrot)::text = 'bravo_lima'::text)
14. 0.044 0.044 ↓ 1.0 60 1

Bitmap Index Scan on delta_romeo (cost=0.000..5.000 rows=59 width=0) (actual time=0.044..0.044 rows=60 loops=1)

  • Index Cond: ((bravo_xray)::text = 'victor_oscar'::text)
15. 0.264 0.957 ↑ 50.6 5 33

Bitmap Heap Scan on charlie_five (cost=10.520..1,012.370 rows=253 width=74) (actual time=0.025..0.029 rows=5 loops=33)

  • Recheck Cond: ((charlie_xray)::text = (xray_lima.quebec_seven)::text)
16. 0.693 0.693 ↑ 50.6 5 33

Bitmap Index Scan on charlie_two (cost=0.000..10.460 rows=253 width=0) (actual time=0.021..0.021 rows=5 loops=33)

  • Index Cond: ((charlie_xray)::text = (xray_lima.quebec_seven)::text)
17. 2.844 2.844 ↑ 1.0 1 158

Index Only Scan using xray_quebec on victor_india (cost=0.560..8.540 rows=1 width=37) (actual time=0.017..0.018 rows=1 loops=158)

  • Index Cond: (quebec_seven = (charlie_five.quebec_seven)::text)
  • Heap Fetches: 157
18. 0.942 4.396 ↑ 532.0 3 157

Bitmap Heap Scan on quebec_xray delta_hotel (cost=96.720..6,356.930 rows=1,596 width=74) (actual time=0.025..0.028 rows=3 loops=157)

  • Recheck Cond: ((golf_xray)::text = (charlie_five.quebec_seven)::text)
19. 3.454 3.454 ↑ 532.0 3 157

Bitmap Index Scan on delta_two (cost=0.000..96.320 rows=1,596 width=0) (actual time=0.022..0.022 rows=3 loops=157)

  • Index Cond: ((golf_xray)::text = (charlie_five.quebec_seven)::text)
20. 9.360 9.360 ↑ 1.0 1 468

Index Scan using bravo_charlie on oscar_hotel three (cost=0.700..8.680 rows=1 width=132) (actual time=0.019..0.020 rows=1 loops=468)

  • Index Cond: ((quebec_seven)::text = (delta_hotel.alpha)::text)
21. 0.740 0.740 ↑ 1.0 1 74

Index Scan using juliet on kilo lima_juliet (cost=0.280..8.110 rows=1 width=46) (actual time=0.009..0.010 rows=1 loops=74)

  • Index Cond: ((quebec_seven)::text = (three.echo)::text)
22. 1.110 1.110 ↓ 0.0 0 74

Index Only Scan using golf_yankee on six_yankee (cost=0.570..8.550 rows=1 width=37) (actual time=0.015..0.015 rows=0 loops=74)

  • Index Cond: (quebec_seven = (three.quebec_seven)::text)
  • Heap Fetches: 0