explain.depesz.com

PostgreSQL's explain analyze made readable

Result: g7H2

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

Delete on whiskey (cost=12,500.290..23,076.040 rows=86,025 width=12) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Semi Join (cost=12,500.290..23,076.040 rows=86,025 width=12) (actual rows= loops=)

  • Hash Cond: (whiskey.quebec_seven = uniform1.quebec_seven)
3. 0.000 0.000 ↓ 0.0

Seq Scan on whiskey (cost=0.000..8,646.130 rows=370,513 width=10) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=11,424.980..11,424.980 rows=86,025 width=10) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on whiskey quebec_quebec (cost=0.000..11,424.980 rows=86,025 width=10) (actual rows= loops=)

  • Filter: ((quebec_seven <> 65) AND ((mike)::text = 'four'::text) AND ((two)::text = 'five'::text))