explain.depesz.com

PostgreSQL's explain analyze made readable

Result: v5dh

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.036 51.459 ↓ 0.0 0 1

Sort (cost=9,286.39..9,286.39 rows=1 width=31) (actual time=51.459..51.459 rows=0 loops=1)

  • Sort Key: countries.short_name
  • Sort Method: quicksort Memory: 25kB
2. 0.002 51.423 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,000.14..9,286.38 rows=1 width=31) (actual time=51.423..51.423 rows=0 loops=1)

3. 5.148 51.421 ↓ 0.0 0 1

Gather (cost=1,000.00..9,278.20 rows=1 width=8) (actual time=51.421..51.421 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 46.273 46.273 ↓ 0.0 0 3 / 3

Parallel Seq Scan on ref_contract_specification_countries (cost=0.00..8,278.10 rows=1 width=8) (actual time=46.273..46.273 rows=0 loops=3)

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

Index Scan using countries_pkey on countries (cost=0.14..8.16 rows=1 width=31) (never executed)

  • Index Cond: (ref_contract_specification_countries.country_id = id)
Planning time : 0.322 ms
Execution time : 54.281 ms