explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Axau

Settings
# exclusive inclusive rows x rows loops node
1. 504.798 60,704.478 ↓ 72.4 652 1

Gather (cost=1,155.54..45,963.09 rows=9 width=50) (actual time=61.802..60,704.478 rows=652 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
  • Buffers: shared hit=236488 read=711437
  • Execution Time: 60704.797 ms(22 lignes)
2. 1.870 60,199.680 ↓ 54.3 163 4 / 4

Nested Loop (cost=155.54..44,962.19 rows=3 width=50) (actual time=120.734..60,199.680 rows=163 loops=4)

  • Buffers: shared hit=236488 read=711437
3. 11.281 15.557 ↓ 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=13.186..15.557 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=310
  • Buffers: shared read=445
4. 4.276 4.276 ↑ 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.103..17.103 rows=12,780 loops=1)

  • Index Cond: (dl_datextract = '2019-12-31'::date)
  • Buffers: shared read=47
5. 60,182.253 60,182.253 ↑ 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=55.413..355.582 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=236488 read=710992
Planning time : 20.424 ms