explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gYz2

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

Limit (cost=0.850..118,987.590 rows=1 width=6,051) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.850..118,987.590 rows=1 width=6,051) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.420..118,987.090 rows=1 width=6,055) (actual rows= loops=)

  • Join Filter: (papa_india.bravo_tango = five.bravo_tango)
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.420..118,986.070 rows=1 width=6,059) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on two quebec (cost=0.000..56,130.910 rows=4,181 width=6,051) (actual rows= loops=)

  • Filter: ((romeo <> 3) AND (golf_romeo((kilo)::text) ~~ 'xray'::text))
6. 0.000 0.000 ↓ 0.0

Index Scan using delta_victor on papa_uniform papa_india (cost=0.420..15.020 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (papa_seven = quebec.papa_seven)
  • Filter: ((delta_four 1) = sierra)
7.          

SubPlan (for Index Scan)

8. 0.000 0.000 ↓ 0.0

Aggregate (cost=8.450..8.460 rows=1 width=4) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Index Scan using delta_victor on papa_uniform bravo_juliet (cost=0.420..8.440 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (papa_seven = quebec.papa_seven)
10. 0.000 0.000 ↓ 0.0

Seq Scan on mike five (cost=0.000..1.010 rows=1 width=4) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Index Scan using foxtrot on india golf_yankee (cost=0.420..0.490 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (lima = papa_india.sierra)