explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hSgM

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 324,686.080 ↑ 1.0 1 1

Finalize Aggregate (cost=691,625.30..691,625.31 rows=1 width=8) (actual time=324,686.079..324,686.080 rows=1 loops=1)

2. 13.665 324,686.065 ↓ 1.2 5 1

Gather (cost=691,624.88..691,625.29 rows=4 width=8) (actual time=324,683.287..324,686.065 rows=5 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 0.003 324,672.400 ↑ 1.0 1 5

Partial Aggregate (cost=690,624.88..690,624.89 rows=1 width=8) (actual time=324,672.400..324,672.400 rows=1 loops=5)

4. 0.001 324,672.397 ↓ 0.0 0 5

Hash Join (cost=12.40..690,624.79 rows=35 width=0) (actual time=324,672.397..324,672.397 rows=0 loops=5)

  • Hash Cond: (hib."ID_MODE_NOTIFICATION" = rmn."ID_MODE_NOTIFICATION")
5. 324,672.396 324,672.396 ↓ 0.0 0 5

Parallel Seq Scan on "HISTO_IDENTIFICATION_BOVIN" hib (cost=0.00..690,568.98 rows=3,451 width=5) (actual time=324,672.396..324,672.396 rows=0 loops=5)

  • Filter: ((("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)) AND ("substring"(("NUCHEP")::text, 2) = '14'::text))
  • Rows Removed by Filter: 3613413
6. 0.000 0.000 ↓ 0.0 0

Hash (cost=12.38..12.38 rows=2 width=32) (never executed)

7. 0.000 0.000 ↓ 0.0 0

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

  • Filter: ("MODE_NOTIFICATION_MNIB" = ANY ('{W,L}'::bpchar[]))