explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OeTK : Optimization for: plan #gbbG

Settings

Optimization path:

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

HashAggregate (cost=85,572,638.340..85,572,638.400 rows=6 width=59) (actual rows= loops=)

  • Group Key: victor.sierra
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.560..85,571,299.590 rows=19,125 width=59) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.000..85,528,487.640 rows=19,128 width=51) (actual rows= loops=)

  • Join Filter: ((charlie_oscar.whiskey_golf)::text = (victor.whiskey_golf)::text)
4. 0.000 0.000 ↓ 0.0

Seq Scan on charlie_oscar (cost=0.000..85,504,955.720 rows=33,372 width=73) (actual rows= loops=)

  • Filter: (((delta 1))::text = 'zulu'::text)
5.          

SubPlan (for Seq Scan)

6. 0.000 0.000 ↓ 0.0

Function Scan on seven (cost=0.250..12.750 rows=5 width=32) (actual rows= loops=)

  • Filter: (bravo = 200)
7. 0.000 0.000 ↓ 0.0

Materialize (cost=0.000..4.770 rows=47 width=50) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on victor (cost=0.000..4.540 rows=47 width=50) (actual rows= loops=)

  • Filter: ((sierra)::text = ANY ('papa'::text[]))
9. 0.000 0.000 ↓ 0.0

Index Scan using whiskey_echo on hotel (cost=0.560..2.230 rows=1 width=45) (actual rows= loops=)

  • Index Cond: ((charlie_charlie)::text = (charlie_oscar.charlie_charlie)::text)