explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qi6d

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 43.278 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.69..1,166.45 rows=1 width=899) (actual time=43.278..43.278 rows=0 loops=1)

2. 0.000 43.277 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.13..1,157.86 rows=1 width=863) (actual time=43.277..43.277 rows=0 loops=1)

3. 0.001 43.277 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..1,154.64 rows=1 width=838) (actual time=43.277..43.277 rows=0 loops=1)

  • Join Filter: (contract_specification_farm.deleted_date_time IS NULL)
4. 43.276 43.276 ↓ 0.0 0 1

Seq Scan on contract_specification_farm (cost=0.00..1,146.05 rows=1 width=353) (actual time=43.276..43.276 rows=0 loops=1)

  • Filter: ((deleted_date_time IS NULL) AND (contract_specification_id = 1,497,408))
  • Rows Removed by Filter: 33,828
5. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_n_farm_medicament on n_farm_medicament (cost=0.56..8.58 rows=1 width=485) (never executed)

  • Index Cond: (contract_specification_farm.farm_medicament_id = medicament_id)
  • Filter: (is_actual = '1'::numeric)
6. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_medicine_trade_name on n_farm_medicine_trade_name (cost=0.56..3.20 rows=1 width=31) (never executed)

  • Index Cond: (trade_name_id = n_farm_medicament.tn_id)
7. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_n_farm_primary_medic_pack on n_farm_primary_medicine_pack (cost=0.56..8.58 rows=1 width=44) (never executed)

  • Index Cond: (primary_package_id = contract_specification_farm.primary_package_id)
  • Filter: (is_actual = '1'::numeric)
Planning time : 732.172 ms
Execution time : 43.495 ms