explain.depesz.com

PostgreSQL's explain analyze made readable

Result: W5xN : ㅁㅁ

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 23.747 ↑ 1.0 1 1

Aggregate (cost=1,239.790..1,239.800 rows=1 width=8) (actual time=23.747..23.747 rows=1 loops=1)

  • Buffers: shared hit=254 read=6
2. 0.002 23.745 ↑ 1.0 1 1

Nested Loop Anti Join (cost=132.730..1,239.780 rows=1 width=0) (actual time=8.683..23.745 rows=1 loops=1)

  • Join Filter: (tango.three_alpha = six_three.three_alpha)
  • Buffers: shared hit=254 read=6
3. 0.005 23.728 ↑ 1.0 1 1

Nested Loop (cost=131.880..1,238.510 rows=1 width=19) (actual time=8.666..23.728 rows=1 loops=1)

  • Join Filter: (quebec.three_alpha = six_three.three_alpha)
  • Buffers: shared hit=251 read=6
4. 0.007 18.687 ↓ 2.0 2 1

Nested Loop (cost=131.320..1,237.520 rows=1 width=34) (actual time=5.502..18.687 rows=2 loops=1)

  • Buffers: shared hit=247 read=1
5. 17.654 17.926 ↑ 18.0 2 1

Bitmap Heap Scan on golf_six quebec (cost=130.760..1,072.550 rows=36 width=27) (actual time=5.474..17.926 rows=2 loops=1)

  • Recheck Cond: ((six_lima)::text = 'hotel'::text)
  • Filter: (((delta_zulu)::text <= ((((((zulu())::character varying(23))::date)::character varying(10))::date)::character varying(10))::text) AND ((victor_whiskey)::text >= ((((((zulu())::character varying(23))::date)::character varying(10))::date)::character varying(10))::text))
  • Rows Removed by Filter: 6727
  • Heap Blocks: exact=218
  • Buffers: shared hit=239
6. 0.272 0.272 ↑ 1.0 6,729 1

Bitmap Index Scan on alpha (cost=0.000..130.750 rows=6,729 width=0) (actual time=0.271..0.272 rows=6,729 loops=1)

  • Index Cond: ((six_lima)::text = 'hotel'::text)
  • Buffers: shared hit=21
7. 0.754 0.754 ↑ 1.0 1 2

Index Only Scan using victor_four on xray papa (cost=0.560..4.580 rows=1 width=23) (actual time=0.377..0.377 rows=1 loops=2)

  • Index Cond: ((bravo_tango = 'delta_oscar'::text) AND (golf_echo = (quebec.golf_echo)::text) AND (bravo_lima = (quebec.bravo_lima)::text) AND (whiskey = 'hotel'::text))
  • Heap Fetches: 0
  • Buffers: shared hit=8 read=1
8. 5.036 5.036 ↓ 0.0 0 2

Index Scan using juliet_four on romeo six_three (cost=0.560..0.980 rows=1 width=19) (actual time=2.518..2.518 rows=0 loops=2)

  • Index Cond: (((golf_echo)::text = (papa.golf_echo)::text) AND ((bravo_tango)::text = 'delta_oscar'::text) AND ((november_whiskey)::text = 'india'::text))
  • Filter: ((five_six)::text = 'november_tango'::text)
  • Buffers: shared hit=4 read=5
9. 0.001 0.015 ↓ 0.0 0 1

Nested Loop (cost=0.840..1.260 rows=1 width=19) (actual time=0.015..0.015 rows=0 loops=1)

  • Buffers: shared hit=3
10. 0.014 0.014 ↓ 0.0 0 1

Index Scan using uniform on two juliet_xray (cost=0.420..0.480 rows=1 width=23) (actual time=0.014..0.014 rows=0 loops=1)

  • Index Cond: ((golf_echo)::text = (papa.golf_echo)::text)
  • Filter: ((three_zulu)::text = 'hotel'::text)
  • Buffers: shared hit=3
11. 0.000 0.000 ↓ 0.0 0

Index Scan using five_juliet on juliet_golf tango (cost=0.420..0.750 rows=2 width=12) (never executed)

  • Index Cond: ((three_foxtrot)::text = (juliet_xray.three_foxtrot)::text)