explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kPDR

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

Nested Loop Semi Join (cost=1,000.00..27,430,889.53 rows=1 width=4) (actual rows= loops=)

  • Join Filter: (observations.id = previous_observations.observation_id)
2. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.00..21,635,539.65 rows=1 width=4) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on observations (cost=0.00..21,634,539.55 rows=1 width=4) (actual rows= loops=)

  • Filter: (((config_name)::text = 'ld_query'::text) AND (table_id <> ALL ('{107521,119818,118284,103954,120238,116248,101920,120359,106540,101933,101940,101945,101946,119885,110158,105561,105562,
4. 0.000 0.000 ↓ 0.0

Seq Scan on previous_observations (cost=0.00..3,105,448.28 rows=215,192,128 width=4) (actual rows= loops=)