explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4xVN

Settings
# exclusive inclusive rows x rows loops node
1. 71.801 934.977 ↓ 1.5 501,392 1

Gather (cost=34,153.44..2,433,917.25 rows=332,738 width=83) (actual time=267.950..934.977 rows=501,392 loops=1)

  • Workers Planned: 8
  • Workers Launched: 8
2. 842.918 863.176 ↓ 1.3 55,710 9 / 9

Parallel Bitmap Heap Scan on ged_vm_stat_traitement_q (cost=33,153.44..2,399,643.45 rows=41,592 width=83) (actual time=255.108..863.176 rows=55,710 loops=9)

  • Recheck Cond: ((((histo_process_action)::text = 'S_TRAITEMENT_OK'::text) AND ((sid_publie_in = 1) OR (sid_frachr_in = 1))) OR (((histo_process_action)::text = 'TRAITEMENT_OK'::text) AND ((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))
  • Rows Removed by Filter: 114,742
  • Heap Blocks: exact=35,590
3. 0.001 20.258 ↓ 0.0 0 1 / 9

BitmapOr (cost=33,153.44..33,153.44 rows=2,966,841 width=0) (actual time=182.319..182.319 rows=0 loops=1)

4. 11.680 11.680 ↑ 1.9 842,572 1 / 9

Bitmap Index Scan on idx_ged_vm_stat_traitement_q_2 (cost=0.00..18,001.90 rows=1,619,049 width=0) (actual time=105.122..105.122 rows=842,572 loops=1)

  • Index Cond: ((histo_process_action)::text = 'S_TRAITEMENT_OK'::text)
5. 8.577 8.577 ↑ 1.9 691,495 1 / 9

Bitmap Index Scan on idx_ged_vm_stat_traitement_q_2 (cost=0.00..14,985.17 rows=1,347,792 width=0) (actual time=77.189..77.189 rows=691,495 loops=1)

  • Index Cond: ((histo_process_action)::text = 'TRAITEMENT_OK'::text)
Planning time : 1.364 ms
Execution time : 953.040 ms