explain.depesz.com

PostgreSQL's explain analyze made readable

Result: n94V

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

Index Scan using rule_data_nu1 on rule_data (cost=0.56..4.58 rows=1 width=248) (actual time=0.013..0.014 rows=0 loops=1)

  • Index Cond: (((client_code)::text = 'GAP2'::text) AND ((table_name)::text = 'MASTER_CITY'::text) AND ((match_on_value)::text = 'SARATOGASPRINGS'::text))