explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2tAu

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

Gather (cost=1,358.00..2,812,940.05 rows=13,991 width=21) (actual rows= loops=)

  • Workers Planned: 2
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=358.00..2,810,540.95 rows=5,830 width=21) (actual rows= loops=)

  • Hash Cond: (date(ap.horodatage_appel) = da.date_sql)
3. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on dwh_dim_action_appel ap (cost=0.00..2,810,095.50 rows=5,830 width=25) (actual rows= loops=)

  • Filter: ((fk_dwh_dim_date IS NULL) AND ((source)::text = 'BORA'::text))
4. 0.000 0.000 ↓ 0.0

Hash (cost=233.00..233.00 rows=10,000 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on dwh_dim_date da (cost=0.00..233.00 rows=10,000 width=8) (actual rows= loops=)