explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N62w : prod_prije_prod_spor_cest_upit_2

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

Update on srserviceassignment (cost=0.43..8.45 rows=1 width=321) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Index Scan using srserviceassignment_servicereq_id on srserviceassignment (cost=0.43..8.45 rows=1 width=321) (actual rows= loops=)

  • Index Cond: (servicerequest_id = '2391731'::bigint)
  • Filter: ((status)::text = 'Active'::text)