explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0L8d

Settings
# exclusive inclusive rows x rows loops node
1. 7.079 2,747.763 ↑ 5.6 21,261 1

Finalize GroupAggregate (cost=716,522.25..748,972.71 rows=119,848 width=15) (actual time=2,553.176..2,747.763 rows=21,261 loops=1)

  • Group Key: fs.fst_modele_r3
2. 0.000 2,740.684 ↑ 11.2 21,378 1

Gather Merge (cost=716,522.25..746,575.75 rows=239,696 width=15) (actual time=2,553.171..2,740.684 rows=21,378 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 48.528 5,286.465 ↑ 16.8 7,126 3

Partial GroupAggregate (cost=715,522.23..717,908.86 rows=119,848 width=15) (actual time=1,710.115..1,762.155 rows=7,126 loops=3)

  • Group Key: fs.fst_modele_r3
4. 1,201.416 5,237.937 ↑ 1.3 123,924 3

Sort (cost=715,522.23..715,918.28 rows=158,421 width=15) (actual time=1,710.108..1,745.979 rows=123,924 loops=3)

  • Sort Key: fs.fst_modele_r3
  • Sort Method: quicksort Memory: 25kB
5. 688.494 4,036.521 ↑ 1.3 123,924 3

Hash Join (cost=171,236.14..699,130.88 rows=158,421 width=15) (actual time=1,023.457..1,345.507 rows=123,924 loops=3)

  • Hash Cond: ((rdi.rrdi_code_fournisseur)::text = (fs.fst_article_r3)::text)
6. 287.655 287.655 ↑ 1.3 123,954 3

Parallel Index Scan using idx02_registry_data_impacted on rfid_registry_data_impacted rdi (cost=0.56..514,021.89 rows=158,421 width=16) (actual time=0.013..95.885 rows=123,954 loops=3)

  • Index Cond: ((tti_num_type_tiers_tir = 7) AND (tir_num_tiers_tir = 230))
7. 1,587.936 3,060.372 ↑ 1.0 1,865,506 3

Hash (cost=138,638.81..138,638.81 rows=1,875,181 width=14) (actual time=1,020.124..1,020.124 rows=1,865,506 loops=3)

  • Buckets: 131072 Batches: 32 Memory Usage: 3756kB
8. 1,472.436 1,472.436 ↑ 1.0 1,865,521 3

Seq Scan on flat_structure fs (cost=0.00..138,638.81 rows=1,875,181 width=14) (actual time=0.009..490.812 rows=1,865,521 loops=3)

Planning time : 0.174 ms
Execution time : 2,752.426 ms