explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pw7t : ad

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop Anti Join (cost=1.840..602,131.430 rows=305,147 width=88) (actual rows= loops=)

  • Join Filter: (bravo_quebec.quebec_seven = uniform.sierra_hotel)
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.270..597,546.040 rows=305,147 width=88) (actual rows= loops=)

  • Join Filter: ((quebec_three.quebec_seven = bravo_quebec.kilo_quebec) AND (quebec_sierra.quebec_seven = bravo_quebec.bravo_tango))
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.700..66,918.790 rows=78,843 width=56) (actual rows= loops=)

  • Join Filter: (quebec_three.quebec_seven = kilo_tango.kilo_quebec)
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.140..1,004.830 rows=211 width=29) (actual rows= loops=)

  • Join Filter: (quebec_three.quebec_seven = quebec_sierra.kilo_quebec)
5. 0.000 0.000 ↓ 0.0

Index Scan using tango_hotel on zulu_india quebec_three (cost=0.140..132.900 rows=2 width=10) (actual rows= loops=)

  • Filter: (yankee_uniform((sierra_seven)::text) = ANY ('zulu_echo_november'::text[]))
6. 0.000 0.000 ↓ 0.0

Materialize (cost=0.000..683.690 rows=6,845 width=19) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on echo quebec_sierra (cost=0.000..649.460 rows=6,845 width=19) (actual rows= loops=)

  • Filter: ('tango_xray'::text <> (juliet)::text)
8. 0.000 0.000 ↓ 0.0

Index Scan using yankee_quebec on quebec_four kilo_tango (cost=0.560..311.880 rows=41 width=27) (actual rows= loops=)

  • Index Cond: ((kilo_quebec = quebec_sierra.kilo_quebec) AND (bravo_tango = quebec_sierra.quebec_seven))
  • Filter: ('tango_xray'::text <> (juliet)::text)
9. 0.000 0.000 ↓ 0.0

Index Scan using lima on oscar bravo_quebec (cost=0.570..6.720 rows=1 width=68) (actual rows= loops=)

  • Index Cond: ((kilo_quebec = kilo_tango.kilo_quebec) AND (bravo_tango = kilo_tango.bravo_tango) AND (bravo_six = kilo_tango.quebec_seven))
  • Filter: ('tango_xray'::text <> (juliet)::text)
10. 0.000 0.000 ↓ 0.0

Materialize (cost=0.570..8.190 rows=1 width=4) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Index Only Scan using zulu_echo_mike on alpha uniform (cost=0.570..8.180 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (five = 'papa'::date)