explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jyFA

Settings
# exclusive inclusive rows x rows loops node
1. 121.354 925.298 ↓ 1.5 501,392 1

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

  • Workers Planned: 8
  • Workers Launched: 8
2. 784.704 803.944 ↓ 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=197.754..803.944 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=33,376
3. 0.000 19.240 ↓ 0.0 0 1 / 9

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

4. 11.233 11.233 ↑ 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=101.100..101.100 rows=842,572 loops=1)

  • Index Cond: ((histo_process_action)::text = 'S_TRAITEMENT_OK'::text)
5. 8.006 8.006 ↑ 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=72.053..72.053 rows=691,495 loops=1)

  • Index Cond: ((histo_process_action)::text = 'TRAITEMENT_OK'::text)
Planning time : 0.673 ms
Execution time : 943.720 ms