explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 72ya

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

Finalize Aggregate (cost=680,701.88..680,701.89 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather (cost=680,701.46..680,701.87 rows=4 width=8) (actual rows= loops=)

  • Workers Planned: 4
3. 0.000 0.000 ↓ 0.0

Partial Aggregate (cost=679,701.46..679,701.47 rows=1 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Join (cost=12.40..679,700.62 rows=335 width=0) (actual rows= loops=)

  • Hash Cond: (hib."ID_MODE_NOTIFICATION" = rmn."ID_MODE_NOTIFICATION")
5. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "HISTO_IDENTIFICATION_BOVIN" hib (cost=0.00..679,277.07 rows=32,684 width=5) (actual rows= loops=)

  • Filter: ((("NUCHEP")::text ~~ '14%'::text) AND (("COPACH")::text = 'FR'::text) AND (("STATUT")::text = 'V'::text) AND ("DATE_RECEPTION" >= to_date('01/01/2017'::text, 'DD/MM/YYYY'::text)) AND ("DATE_RECEPTION" <= to_date('31/12/2017'::text, 'DD/MM/YYYY'::text)))
6. 0.000 0.000 ↓ 0.0

Hash (cost=12.38..12.38 rows=2 width=32) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on "REF_MODE_NOTIFICATION" rmn (cost=0.00..12.38 rows=2 width=32) (actual rows= loops=)