| Result (cost=56.27..56.28 rows=1 width=1) |
| InitPlan 2 (returns $2) |
| -> Nested Loop Left Join (cost=11.97..56.27 rows=1 width=0) |
| Join Filter: (pcr.contract_id = c.id) |
| Filter: ((client.sales_rep = 1005) OR (client.sales_rep IS NULL) OR (hashed SubPlan 1) OR (pcr.id IS NULL)) |
| -> Index Only Scan using tbl_purchase_contracts_pkey on tbl_purchase_contracts c (cost=0.28..4.29 rows=1 width=4) |
| Index Cond: (id = 3848) |
| -> Nested Loop Left Join (cost=0.28..40.54 rows=1 width=16) |
| -> Seq Scan on tbl_purchase_client_rels pcr (cost=0.00..32.24 rows=1 width=12) |
| Filter: (contract_id = 3848) |
| -> Index Scan using tbl_clients_pkey on tbl_clients client (cost=0.28..8.29 rows=1 width=8) |
| Index Cond: (pcr.client_id = id) |
| SubPlan 1 |
| -> Seq Scan on tbl_user_visit_clients (cost=0.00..11.41 rows=1 width=4) |
| Filter: (user_id = 1005) |