explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WcLK

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

Limit (cost=1.000..49,126,723.220 rows=1 width=4) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=1.000..196,506,889.860 rows=4 width=4) (actual rows= loops=)

  • Merge Cond: (six.quebec = two.golf)
  • Filter: (((six.mike)::text = 'seven'::text) OR ((two.alpha)::text = 'seven'::text))
3. 0.000 0.000 ↓ 0.0

Index Scan using uniform on six (cost=0.560..115,139,774.880 rows=56,655,024 width=14) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using zulu on two (cost=0.440..55,816,644.120 rows=25,274,085 width=18) (actual rows= loops=)