explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1wzD

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

Update on properties (cost=0.29..54.65 rows=2 width=947) (actual time=9.978..9.978 rows=0 loops=1)

2. 0.386 0.386 ↓ 5.0 10 1

Index Scan using idx_properties_cid_id_is_disabled_remote_primary_key on properties (cost=0.29..54.65 rows=2 width=947) (actual time=0.092..0.386 rows=10 loops=1)

  • Index Cond: ((cid = 2138) AND (id = ANY ('{525630,518258,484645,494368,180033,615739,225205,573338,484563,223331}'::integer[])))
  • Filter: ((termination_date IS NULL) AND (is_disabled <> 1) AND (property_type_id <> ALL ('{38,99}'::integer[])))