explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zlA3

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

Index Scan using hcp_licence_number_key on hcp (cost=0.42..8.45 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((licence_number)::text = '12234'::text)
  • Filter: ((title IS NULL) AND (full_name IS NULL) AND ((first_name)::text = 'fff'::text) AND ((family_name)::text = 'yoyoy'::text) AND (gender = 'male'::gender) AND (graduation_year = 2000) AND ((source)::text = 'sss'::text))