explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fb53

Settings
# exclusive inclusive rows x rows loops node
1. 201.350 39,400.654 ↓ 72.4 652 1

Gather (cost=1,155.54..45,963.09 rows=9 width=50) (actual time=60.852..39,400.654 rows=652 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
  • Buffers: shared hit=493415 read=454510
  • Execution Time: 39400.878 ms(22 lignes)
2. 1.393 39,199.304 ↓ 54.3 163 4 / 4

Nested Loop (cost=155.54..44,962.19 rows=3 width=50) (actual time=128.401..39,199.304 rows=163 loops=4)

  • Buffers: shared hit=493415 read=454510
3. 11.857 16.197 ↓ 8.0 169 4 / 4

Parallel Bitmap Heap Scan on hf_dwh_f_compte_courant_compl (cost=154.97..16,040.32 rows=21 width=33) (actual time=14.052..16.197 rows=169 loops=4)

  • Recheck Cond: (dl_datextract = '2019-12-31'::date)
  • Filter: ((dl_annee_gestion = 2019) AND (dl_version = 1) AND (type_mvt_compl = 'RECA'::bpchar) AND (type_cptc_compl = 'FORT'::bpchar))
  • Rows Removed by Filter: 3026
  • Heap Blocks: exact=17
  • Buffers: shared hit=322 read=123
4. 4.340 4.340 ↑ 1.1 12,780 1 / 4

Bitmap Index Scan on olm_hf_dwh_f_compte_courant_compl_dl_datextract (cost=0.00..154.95 rows=14,589 width=0) (actual time=17.361..17.361 rows=12,780 loops=1)

  • Index Cond: (dl_datextract = '2019-12-31'::date)
  • Buffers: shared read=47
5. 39,181.713 39,181.713 ↑ 1.0 1 677 / 4

Index Scan using olm_hf_dwh_d_obj_facturable_objf_id on hf_dwh_d_obj_facturable (cost=0.57..1,377.22 rows=1 width=41) (actual time=39.284..231.502 rows=1 loops=677)

  • Index Cond: (objf_id = hf_dwh_f_compte_courant_compl.objf_id)
  • Filter: ((dl_datextract = '2019-12-31'::date) AND (dl_annee_gestion = 2019) AND (dl_version = 1) AND (dl_soc_id = 3))
  • Rows Removed by Filter: 1391
  • Buffers: shared hit=493093 read=454387
Planning time : 0.396 ms