explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FJI2

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

HashAggregate (cost=33.810..33.820 rows=1 width=1,134) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.850..33.780 rows=1 width=1,134) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.850..32.720 rows=1 width=508) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.570..24.420 rows=1 width=503) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.280..11.140 rows=1 width=503) (actual rows= loops=)

  • Join Filter: (quebec_three.charlie = juliet_india.sierra_zulu)
6. 0.000 0.000 ↓ 0.0

Seq Scan on mike juliet_india (cost=0.000..1.040 rows=1 width=352) (actual rows= loops=)

  • Filter: (three_kilo = 10)
7. 0.000 0.000 ↓ 0.0

Index Scan using romeo on xray_mike quebec_three (cost=0.280..10.080 rows=2 width=167) (actual rows= loops=)

  • Index Cond: ((three_kilo = 10) AND (juliet_bravo = 522) AND (juliet_whiskey = 10))
  • Filter: ((papa)::text = 'xray_charlie'::text)
8. 0.000 0.000 ↓ 0.0

Index Scan using lima_uniform on oscar five (cost=0.290..13.270 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (quebec_three.quebec_kilo = quebec_kilo)
  • Filter: (three_kilo = three_kilo)
9. 0.000 0.000 ↓ 0.0

Index Scan using two on sierra_victor kilo_tango (cost=0.280..8.290 rows=1 width=37) (actual rows= loops=)

  • Index Cond: (quebec_three.delta = echo)
  • Filter: (juliet_bravo = quebec_three.kilo_sierra)
10. 0.000 0.000 ↓ 0.0

Seq Scan on zulu lima_delta (cost=0.000..1.040 rows=1 width=650) (actual rows= loops=)

  • Filter: ((three_juliet = 10) AND (three_kilo = 10))