explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OHS1

Settings
# exclusive inclusive rows x rows loops node
1. 2.856 75.523 ↓ 1.9 2,322 1

Nested Loop (cost=42,456.990..50,260.060 rows=1,231 width=255) (actual time=0.380..75.523 rows=2,322 loops=1)

2.          

CTE foxtrot_yankee

3. 2.831 21.047 ↓ 6.0 2,105 1

Nested Loop (cost=16.410..3,934.560 rows=348 width=7) (actual time=0.312..21.047 rows=2,105 loops=1)

  • Join Filter: ((foxtrot_delta.foxtrot_six)::text = (lima_charlie.quebec_whiskey)::text)
  • Rows Removed by Join Filter: 4210
4. 2.449 16.111 ↓ 6.0 2,105 1

Nested Loop (cost=16.410..3,917.870 rows=348 width=18) (actual time=0.299..16.111 rows=2,105 loops=1)

5. 0.761 1.032 ↓ 6.0 2,105 1

Bitmap Heap Scan on two mike_seven (cost=15.990..1,238.140 rows=348 width=7) (actual time=0.286..1.032 rows=2,105 loops=1)

  • Recheck Cond: (((mike_xray)::text = 'zulu'::text) AND ((oscar_zulu)::text = 'foxtrot_november'::text))
  • Heap Blocks: exact=119
6. 0.271 0.271 ↓ 6.0 2,105 1

Bitmap Index Scan on lima_oscar (cost=0.000..15.910 rows=348 width=0) (actual time=0.271..0.271 rows=2,105 loops=1)

  • Index Cond: (((mike_xray)::text = 'zulu'::text) AND ((oscar_zulu)::text = 'foxtrot_november'::text))
7. 12.630 12.630 ↑ 1.0 1 2,105

Index Scan using hotel on seven foxtrot_delta (cost=0.420..7.690 rows=1 width=18) (actual time=0.006..0.006 rows=1 loops=2,105)

  • Index Cond: ((kilo)::text = (mike_seven.kilo)::text)
8. 2.100 2.105 ↑ 1.0 3 2,105

Materialize (cost=0.000..1.040 rows=3 width=15) (actual time=0.000..0.001 rows=3 loops=2,105)

9. 0.005 0.005 ↑ 1.0 3 1

Seq Scan on bravo lima_charlie (cost=0.000..1.030 rows=3 width=15) (actual time=0.004..0.005 rows=3 loops=1)

10.          

CTE lima_mike

11. 2.610 57.315 ↓ 1.9 2,322 1

Nested Loop (cost=0.850..38,522.010 rows=1,231 width=7) (actual time=0.365..57.315 rows=2,322 loops=1)

12. 1.377 40.533 ↑ 3.6 2,362 1

Nested Loop (cost=0.430..34,557.940 rows=8,598 width=7) (actual time=0.352..40.533 rows=2,362 loops=1)

13. 22.316 22.316 ↓ 6.0 2,105 1

CTE Scan on foxtrot_yankee (cost=0.000..6.960 rows=348 width=146) (actual time=0.313..22.316 rows=2,105 loops=1)

14. 16.840 16.840 ↑ 25.0 1 2,105

Index Scan using charlie on mike_quebec lima_six (cost=0.430..99.030 rows=25 width=14) (actual time=0.007..0.008 rows=1 loops=2,105)

  • Index Cond: ((kilo)::text = (foxtrot_yankee.kilo)::text)
15. 14.172 14.172 ↑ 1.0 1 2,362

Index Scan using lima_two on oscar_three mike_kilo (cost=0.420..0.450 rows=1 width=14) (actual time=0.006..0.006 rows=1 loops=2,362)

  • Index Cond: ((juliet_foxtrot)::text = (lima_six.quebec_whiskey)::text)
16. 58.735 58.735 ↓ 1.9 2,322 1

CTE Scan on lima_mike xray (cost=0.000..24.620 rows=1,231 width=146) (actual time=0.367..58.735 rows=2,322 loops=1)

17. 13.932 13.932 ↑ 1.0 1 2,322

Index Scan using juliet_four on oscar_three delta (cost=0.420..6.310 rows=1 width=109) (actual time=0.006..0.006 rows=1 loops=2,322)

  • Index Cond: ((quebec_whiskey)::text = (xray.quebec_seven)::text)