explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PyPq

Settings
# exclusive inclusive rows x rows loops node
1. 136.855 1,930.967 ↓ 19.9 62,836 1

GroupAggregate (cost=935,281.36..935,439.01 rows=3,153 width=72) (actual time=1,707.104..1,930.967 rows=62,836 loops=1)

  • Group Key: rdi.rrdi_famille_eln_niveau, rdi.rrdi_code_fournisseur
2. 342.002 1,794.112 ↓ 202.0 636,996 1

Sort (cost=935,281.36..935,289.24 rows=3,153 width=30) (actual time=1,707.088..1,794.112 rows=636,996 loops=1)

  • Sort Key: rdi.rrdi_famille_eln_niveau, rdi.rrdi_code_fournisseur
  • Sort Method: external merge Disk: 25,016kB
3. 405.062 1,452.110 ↓ 202.0 636,996 1

Hash Join (cost=223,381.92..935,098.13 rows=3,153 width=30) (actual time=807.148..1,452.110 rows=636,996 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.941 350.897 ↑ 1.3 667,136 1

Bitmap Heap Scan on rfid_registry_data_impacted rdi (cost=40,161.42..724,238.73 rows=860,743 width=38) (actual time=110.775..350.897 rows=667,136 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,354
  • Heap Blocks: exact=40,829
5. 104.956 104.956 ↑ 1.2 1,021,498 1

Bitmap Index Scan on idx02_registry_data_impacted (cost=0.00..39,946.23 rows=1,207,173 width=0) (actual time=104.955..104.956 rows=1,021,498 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. 298.903 696.151 ↑ 1.0 1,930,645 1

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

  • Buckets: 131,072 Batches: 32 Memory Usage: 3,873kB
7. 397.248 397.248 ↑ 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.210..397.248 rows=1,930,645 loops=1)

Planning time : 0.384 ms
Execution time : 1,937.253 ms