explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Utma

Settings
# exclusive inclusive rows x rows loops node
1. 137.226 2,115.860 ↓ 19.9 62,836 1

GroupAggregate (cost=935,285.78..935,443.43 rows=3,153 width=72) (actual time=1,893.242..2,115.860 rows=62,836 loops=1)

  • Group Key: rdi.rrdi_famille_eln_niveau, rdi.rrdi_code_fournisseur
2. 344.071 1,978.634 ↓ 202.0 636,956 1

Sort (cost=935,285.78..935,293.66 rows=3,153 width=30) (actual time=1,893.224..1,978.634 rows=636,956 loops=1)

  • Sort Key: rdi.rrdi_famille_eln_niveau, rdi.rrdi_code_fournisseur
  • Sort Method: external merge Disk: 25,016kB
3. 568.548 1,634.563 ↓ 202.0 636,956 1

Hash Join (cost=223,381.18..935,102.55 rows=3,153 width=30) (actual time=826.233..1,634.563 rows=636,956 loops=1)

  • Hash Cond: ((rdi.rrdi_elt_gest_int = fs.elg_num_elt_gestion_elg) AND (rdi.rrdi_famille_eln_niveau = fs.eln_num_elt_niveau_fam))
4. 245.841 357.223 ↑ 1.3 667,096 1

Bitmap Heap Scan on rfid_registry_data_impacted rdi (cost=40,160.68..724,243.36 rows=860,702 width=38) (actual time=117.220..357.223 rows=667,096 loops=1)

  • Recheck Cond: ((tti_num_type_tiers_tir = 7) AND (tir_num_tiers_tir = 144) AND (rrdi_date_impact > (now() - '1 year'::interval)))
  • Filter: ((rrdi_famille_eln_niveau IS NOT NULL) AND (rrdi_code_fournisseur IS NOT NULL) AND (rrdi_stock_control > 0))
  • Rows Removed by Filter: 354,345
  • Heap Blocks: exact=40,825
5. 111.382 111.382 ↑ 1.2 1,021,449 1

Bitmap Index Scan on idx02_registry_data_impacted (cost=0.00..39,945.51 rows=1,207,115 width=0) (actual time=111.382..111.382 rows=1,021,449 loops=1)

  • Index Cond: ((tti_num_type_tiers_tir = 7) AND (tir_num_tiers_tir = 144) AND (rrdi_date_impact > (now() - '1 year'::interval)))
6. 308.525 708.792 ↑ 1.0 1,930,645 1

Hash (cost=143,845.40..143,845.40 rows=1,980,340 width=16) (actual time=708.792..708.792 rows=1,930,645 loops=1)

  • Buckets: 131,072 Batches: 32 Memory Usage: 3,873kB
7. 400.267 400.267 ↑ 1.0 1,930,645 1

Seq Scan on flat_structure fs (cost=0.00..143,845.40 rows=1,980,340 width=16) (actual time=2.149..400.267 rows=1,930,645 loops=1)

Planning time : 0.577 ms
Execution time : 2,122.784 ms