explain.depesz.com

PostgreSQL's explain analyze made readable

Result: odyX

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 350,469.625 ↑ 1.0 1 1

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

2. 19.814 350,469.611 ↓ 1.2 5 1

Gather (cost=680,701.46..680,701.87 rows=4 width=8) (actual time=350,469.605..350,469.611 rows=5 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 2.842 350,449.797 ↑ 1.0 1 5

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

4. 12.984 350,446.955 ↓ 72.2 24,199 5

Hash Join (cost=12.40..679,700.62 rows=335 width=0) (actual time=1,461.062..350,446.955 rows=24,199 loops=5)

  • Hash Cond: (hib."ID_MODE_NOTIFICATION" = rmn."ID_MODE_NOTIFICATION")
5. 350,433.917 350,433.917 ↑ 1.2 28,342 5

Parallel Seq Scan on "HISTO_IDENTIFICATION_BOVIN" hib (cost=0.00..679,277.07 rows=32,684 width=5) (actual time=1,460.787..350,433.917 rows=28,342 loops=5)

  • 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)))
  • Rows Removed by Filter: 3585071
6. 0.006 0.054 ↓ 1.5 3 5

Hash (cost=12.38..12.38 rows=2 width=32) (actual time=0.054..0.054 rows=3 loops=5)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.048 0.048 ↓ 1.5 3 5

Seq Scan on "REF_MODE_NOTIFICATION" rmn (cost=0.00..12.38 rows=2 width=32) (actual time=0.047..0.048 rows=3 loops=5)

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