explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MUrl : test short

Settings
# exclusive inclusive rows x rows loops node
1. 753.757 89,533.411 ↓ 1.0 3,626,770 1

Unique (cost=2,535,423.01..2,607,863.29 rows=3,622,014 width=54) (actual time=88,458.704..89,533.411 rows=3,626,770 loops=1)

2. 2,875.548 88,779.654 ↓ 1.0 3,626,770 1

Sort (cost=2,535,423.01..2,544,478.04 rows=3,622,014 width=54) (actual time=88,458.702..88,779.654 rows=3,626,770 loops=1)

  • Sort Key: ue.id, e.code_geo, ue.matricule_unique, ue.valeur_terrain, ue.valeur_batiment, ue.valeur_immeuble, ue.est_terrain_vague
  • Sort Method: external sort Disk: 239152kB
3. 1,229.820 85,904.106 ↓ 1.0 3,626,770 1

Group (cost=1,507,109.18..1,893,230.27 rows=3,622,014 width=54) (actual time=82,492.399..85,904.106 rows=3,626,770 loops=1)

  • Group Key: ue.id, e.code_geo, e.annee_exercice
4. 0.000 84,674.286 ↓ 1.2 3,626,770 1

Gather Merge (cost=1,507,109.18..1,870,592.69 rows=3,018,344 width=54) (actual time=82,492.397..84,674.286 rows=3,626,770 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 1,092.978 247,975.098 ↑ 1.2 1,208,923 3

Group (cost=1,506,109.15..1,521,200.87 rows=1,509,172 width=54) (actual time=82,087.693..82,658.366 rows=1,208,923 loops=3)

  • Group Key: ue.id, e.code_geo, e.annee_exercice
6. 7,019.307 246,882.120 ↑ 1.2 1,208,923 3

Sort (cost=1,506,109.15..1,509,882.08 rows=1,509,172 width=54) (actual time=82,087.684..82,294.040 rows=1,208,923 loops=3)

  • Sort Key: ue.id, e.code_geo
  • Sort Method: external merge Disk: 88800kB
7. 10,612.434 239,862.813 ↑ 1.2 1,208,923 3

Hash Join (cost=643.39..1,248,054.92 rows=1,509,172 width=54) (actual time=5,721.229..79,954.271 rows=1,208,923 loops=3)

  • Hash Cond: (ue.role = r.id)
8. 229,237.851 229,237.851 ↑ 1.2 13,774,947 3

Parallel Seq Scan on unite_evaluation ue (cost=0.00..1,168,108.12 rows=17,123,112 width=48) (actual time=1.740..76,412.617 rows=13,774,947 loops=3)

9. 0.678 12.528 ↑ 1.1 1,139 3

Hash (cost=628.29..628.29 rows=1,208 width=14) (actual time=4.176..4.176 rows=1,139 loops=3)

  • Buckets: 2048 Batches: 1 Memory Usage: 70kB
10. 5.814 11.850 ↑ 1.1 1,139 3

Hash Join (cost=167.21..628.29 rows=1,208 width=14) (actual time=0.621..3.950 rows=1,139 loops=3)

  • Hash Cond: (r.exercice_organisme = e.id)
11. 4.254 4.254 ↑ 1.0 13,706 3

Seq Scan on role r (cost=0.00..288.06 rows=13,706 width=8) (actual time=0.015..1.418 rows=13,706 loops=3)

12. 0.732 1.782 ↑ 1.0 1,280 3

Hash (cost=151.21..151.21 rows=1,280 width=14) (actual time=0.594..0.594 rows=1,280 loops=3)

  • Buckets: 2048 Batches: 1 Memory Usage: 76kB
13. 0.807 1.050 ↑ 1.0 1,280 3

Bitmap Heap Scan on exercice_organisme e (cost=26.21..151.21 rows=1,280 width=14) (actual time=0.090..0.350 rows=1,280 loops=3)

  • Recheck Cond: (annee_exercice = 2019)
  • Heap Blocks: exact=12
14. 0.243 0.243 ↑ 1.0 1,280 3

Bitmap Index Scan on exercice_organisme_annee_exercice_idx (cost=0.00..25.89 rows=1,280 width=0) (actual time=0.081..0.081 rows=1,280 loops=3)

  • Index Cond: (annee_exercice = 2019)
Planning time : 5.854 ms
Execution time : 89,686.009 ms