explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9cKt

Settings
# exclusive inclusive rows x rows loops node
1. 0.520 15.856 ↓ 72.4 652 1

Nested Loop (cost=1.01..11,239.43 rows=9 width=50) (actual time=2.773..15.856 rows=652 loops=1)

  • Buffers: shared hit=2890 read=1039
  • Execution Time: 15.955 ms(12 lignes)
2. 4.504 4.504 ↓ 10.6 677 1

Index Scan using olm_hf_dwh_f_compte_courant_compl_dl_datextract on hf_dwh_f_compte_courant_compl (cost=0.44..11,059.75 rows=64 width=33) (actual time=2.711..4.504 rows=677 loops=1)

  • Index 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: 12103
  • Buffers: shared hit=564
3. 10.832 10.832 ↑ 1.0 1 677

Index Scan using olm_fmo on hf_dwh_d_obj_facturable (cost=0.57..2.80 rows=1 width=41) (actual time=0.016..0.016 rows=1 loops=677)

  • Index Cond: ((objf_id = hf_dwh_f_compte_courant_compl.objf_id) AND (dl_datextract = '2019-12-31'::date) AND (dl_annee_gestion = 2019) AND (dl_version = 1) AND (dl_soc_id = 3))
  • Buffers: shared hit=2326 read=1039
Planning time : 0.808 ms