explain.depesz.com

PostgreSQL's explain analyze made readable

Result: J66w : Fuckup

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

Nested Loop Semi Join (cost=163,210.340..44,133,092.840 rows=13,628 width=8) (actual rows= loops=)

  • Join Filter: (delta 1)
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=163,210.340..326,058.540 rows=27,256 width=16) (actual rows= loops=)

  • Hash Cond: (india0kilo_oscar.mike = six_romeo1kilo_oscar.quebec_seven)
3. 0.000 0.000 ↓ 0.0

Seq Scan on six_xray echo (cost=0.000..133,146.460 rows=2,054,446 width=16) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=157,297.970..157,297.970 rows=340,110 width=16) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using bravo_four on four uniform_alpha (cost=0.440..157,297.970 rows=340,110 width=16) (actual rows= loops=)

  • Index Cond: (uniform_foxtrot = 'xray'::bigint)
6. 0.000 0.000 ↓ 0.0

Materialize (cost=0.000..47.530 rows=372 width=8) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on quebec_alpha foxtrot (cost=0.000..45.670 rows=372 width=8) (actual rows= loops=)

  • Filter: five
8.          

SubPlan (forNested Loop Semi Join)

9. 0.000 0.000 ↓ 0.0

Index Scan using victor on uniform_bravo sierra (cost=0.560..8.580 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (kilo_charlie = india0kilo_oscar.quebec_seven)
  • Filter: (two = bravo_india2kilo_oscar.two)