explain.depesz.com

PostgreSQL's explain analyze made readable

Result: scaw

Settings
# exclusive inclusive rows x rows loops node
1. 134.023 4,304.872 ↓ 1.5 501,392 1

Gather (cost=118,050.91..5,146,289.49 rows=324,299 width=83) (actual time=2,793.992..4,304.872 rows=501,392 loops=1)

  • Workers Planned: 8
  • Workers Launched: 8
2. 4,032.663 4,170.849 ↓ 1.4 55,710 9 / 9

Parallel Bitmap Heap Scan on ged_vm_stat_traitement_q (cost=117,050.91..5,112,859.59 rows=40,537 width=83) (actual time=2,781.137..4,170.849 rows=55,710 loops=9)

  • Recheck Cond: ((sid_publie_in = 1) OR (sid_frachr_in = 1))
  • Filter: (((typo_domaine)::text <> 'Indemnisation'::text) AND (histo_operation_date >= '2019-01-01 00:00:00'::timestamp without time zone) AND ((typo_domaine)::text <> ' '::text) AND (sid_publie_in = 1) AND (((histo_process_action)::text = 'S_TRAITEMENT_OK'::text) OR ((histo_process_action)::text = 'TRAITEMENT_OK'::text)))
  • Rows Removed by Filter: 785,053
  • Heap Blocks: exact=244,266
3. 138.186 138.186 ↓ 2.1 30,255,610 1 / 9

Bitmap Index Scan on xfk_ged_vm_stat_traitement_q_2 (cost=0.00..116,969.83 rows=14,591,434 width=0) (actual time=1,243.677..1,243.677 rows=30,255,610 loops=1)

Planning time : 0.379 ms
Execution time : 4,321.567 ms