explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZUaW : select-bots

Settings

Optimization(s) for this plan:

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

Index Scan using xray on six (cost=0.090..3,188.790 rows=14,862 width=195) (actual rows= loops=)

  • Index Cond: ((quebec >= 1) AND (quebec <= 100000))
  • Filter: (((lima)::text <> 'papa'::text) AND ((india)::text ~* 'tango'::text))