explain.depesz.com

PostgreSQL's explain analyze made readable

Result: muFD

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

Nested Loop Anti Join (cost=2,000.00..173,664.43 rows=1 width=4) (actual time=454.436..454.436 rows=0 loops=1)

  • Join Filter: (((a.claim_type)::text <> (b.claim_type)::text) AND ((a.claim_number)::text = (b.claim_number)::text))
2. 20.896 467.280 ↓ 0.0 0 1

Gather (cost=1,000.00..86,832.21 rows=1 width=19) (actual time=454.434..467.280 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 446.384 446.384 ↓ 0.0 0 3

Parallel Seq Scan on pct a (cost=0.00..85,832.11 rows=1 width=19) (actual time=446.384..446.384 rows=0 loops=3)

  • Filter: ((date_financial_cutoff >= '2019-04-01'::date) AND (date_financial_cutoff <= '2019-03-31'::date) AND ((claim_type)::text <> 'D'::text))
  • Rows Removed by Filter: 398816
4. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,000.00..86,832.21 rows=1 width=15) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
5. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on pct b (cost=0.00..85,832.11 rows=1 width=15) (never executed)

  • Filter: (((claim_type)::text <> 'D'::text) AND (date_financial_cutoff >= '2019-04-01'::date) AND (date_financial_cutoff <= '2019-03-31'::date))