explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TBId

Settings
# exclusive inclusive rows x rows loops node
1. 104.956 1,835.592 ↓ 1.2 933 1

GroupAggregate (cost=479,216.23..491,703.88 rows=760 width=56) (actual time=1,594.786..1,835.592 rows=933 loops=1)

  • Group Key: rsf.rsf_eln_niveau_fam, rsf.rsf_eln_niveau_fam_nb_mod
2. 532.695 1,730.636 ↓ 1.2 1,158,340 1

Sort (cost=479,216.23..481,710.72 rows=997,796 width=20) (actual time=1,593.545..1,730.636 rows=1,158,340 loops=1)

  • Sort Key: rsf.rsf_eln_niveau_fam, rsf.rsf_eln_niveau_fam_nb_mod
  • Sort Method: external merge Disk: 29,576kB
3. 247.009 1,197.941 ↓ 1.2 1,158,340 1

Hash Left Join (cost=229,307.51..359,329.42 rows=997,796 width=20) (actual time=435.045..1,197.941 rows=1,158,340 loops=1)

  • Hash Cond: ((rsf.tir_num_tiers_tir = ms.store_id) AND ((fs.fst_modele_r3)::integer = ms.model_id))
4. 296.510 948.704 ↓ 1.2 1,158,340 1

Gather (cost=228,830.22..338,896.21 rows=997,796 width=27) (actual time=432.780..948.704 rows=1,158,340 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 123.108 652.194 ↑ 1.1 386,113 3 / 3

Merge Join (cost=227,830.22..238,116.61 rows=415,748 width=27) (actual time=431.730..652.194 rows=386,113 loops=3)

  • Merge Cond: (fs.eln_num_elt_niveau_fam = rsf.rsf_eln_niveau_fam)
6. 332.795 505.272 ↑ 1.6 503,649 3 / 3

Sort (cost=226,392.08..228,417.16 rows=810,030 width=15) (actual time=430.475..505.272 rows=503,649 loops=3)

  • Sort Key: fs.eln_num_elt_niveau_fam
  • Sort Method: external merge Disk: 14,040kB
7. 172.477 172.477 ↑ 1.3 645,927 3 / 3

Parallel Seq Scan on flat_structure fs (cost=0.00..133,051.30 rows=810,030 width=15) (actual time=5.071..172.477 rows=645,927 loops=3)

8. 22.834 23.814 ↓ 505.0 385,787 3 / 3

Sort (cost=1,438.14..1,440.05 rows=764 width=20) (actual time=1.249..23.814 rows=385,787 loops=3)

  • Sort Key: rsf.rsf_eln_niveau_fam
  • Sort Method: quicksort Memory: 97kB
9. 0.980 0.980 ↓ 1.2 933 3 / 3

Index Scan using idx01_rfid_stock_flat on rfid_stock_flat rsf (cost=0.43..1,401.56 rows=764 width=20) (actual time=0.045..0.980 rows=933 loops=3)

  • Index Cond: ((tti_num_type_tiers_tir = 7) AND (tir_num_tiers_tir = 230) AND ((rsf_flag_actif)::text = 'Y'::text))
10. 0.619 2.228 ↑ 1.0 2,621 1

Hash (cost=437.97..437.97 rows=2,621 width=8) (actual time=2.228..2.228 rows=2,621 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 135kB
11. 1.609 1.609 ↑ 1.0 2,621 1

Seq Scan on model_20_80_store ms (cost=0.00..437.97 rows=2,621 width=8) (actual time=0.406..1.609 rows=2,621 loops=1)

  • Filter: ((store_id = 230) AND (now() >= start_date) AND (now() <= end_date))
Planning time : 0.395 ms
Execution time : 1,842.569 ms