explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uznA

Settings
# exclusive inclusive rows x rows loops node
1. 30.462 30.462 ↓ 1.4 429 1

Index Scan using idx_pol_1_cover1596456589387 on cover1596456589387 (cost=0.57..1,075.10 rows=299 width=1,344) (actual time=12.663..30.462 rows=429 loops=1)

  • Index Cond: (((policy_id)::text = ANY ('{120001800,214480801}'::text[])) AND ((policy_bu_code)::text = ANY ('{CBNL,HERM}'::text[])) AND ((policy_extension_id)::text = ''::text))