explain.depesz.com

PostgreSQL's explain analyze made readable

Result: suOyW

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

Index Scan using idx_hcp_workplace_all on hcp_workplace (cost=0.42..8.46 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((setting_id IS NULL) AND (country_id = 3) AND (state_or_region IS NULL) AND (city IS NULL) AND ((workplace_name)::text = 'yoyo'::text) AND (address IS NULL) AND (postcode IS NULL) AND (website IS NULL) AND (domain_name_text IS NULL) AND ((source)::text = 'yoyoo'::text))