explain.depesz.com

PostgreSQL's explain analyze made readable

Result: opHu

Settings
# exclusive inclusive rows x rows loops node
1. 36.424 2,237.868 ↑ 2.0 3 1

GroupAggregate (cost=14,993.92..14,997.81 rows=6 width=56) (actual time=2,215.717..2,237.868 rows=3 loops=1)

  • Group Key: campagnejo3_.code_tech
2. 1.407 2,201.444 ↓ 6.4 3,294 1

Sort (cost=14,993.92..14,995.19 rows=511 width=81) (actual time=2,201.233..2,201.444 rows=3,294 loops=1)

  • Sort Key: campagnejo3_.code_tech
  • Sort Method: quicksort Memory: 354kB
3. 841.521 2,200.037 ↓ 6.4 3,294 1

Gather (cost=1,139.34..14,970.93 rows=511 width=81) (actual time=116.802..2,200.037 rows=3,294 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 0.634 1,358.516 ↓ 5.2 1,098 3

Hash Join (cost=139.34..13,919.83 rows=213 width=81) (actual time=43.577..1,358.516 rows=1,098 loops=3)

  • Hash Cond: (campagnejo2_.id_zone = campagnejo3_.id_zone)
5. 26.028 1,355.451 ↓ 5.2 1,098 3

Nested Loop (cost=138.20..13,917.73 rows=213 width=66) (actual time=41.046..1,355.451 rows=1,098 loops=3)

6. 0.670 1,329.400 ↓ 5.2 1,098 3

Hash Join (cost=137.92..13,831.30 rows=213 width=66) (actual time=34.836..1,329.400 rows=1,098 loops=3)

  • Hash Cond: (statusperi4_.id_dossier_status = dossiersta5_.id_dossier_status)
7. 306.651 1,327.760 ↑ 1.3 1,191 3

Nested Loop (cost=136.82..13,823.92 rows=1,489 width=99) (actual time=33.853..1,327.760 rows=1,191 loops=3)

8. 102.997 1,020.852 ↑ 1.3 1,191 3

Nested Loop (cost=136.40..12,859.65 rows=1,489 width=99) (actual time=29.830..1,020.852 rows=1,191 loops=3)

9. 910.664 917.770 ↑ 1.3 1,191 3

Parallel Bitmap Heap Scan on t_campagne_jour_retard campagnejo0_ (cost=135.98..8,233.66 rows=1,489 width=66) (actual time=4.777..917.770 rows=1,191 loops=3)

  • Recheck Cond: ((id_organisation = '8a9483ef5621e35d015626518779001c'::bpchar) AND (NOT boo_supprime) AND (NOT boo_en_migration) AND (NOT boo_traiter))
  • Heap Blocks: exact=621
10. 7.106 7.106 ↑ 1.0 3,572 1

Bitmap Index Scan on tst4 (cost=0.00..135.09 rows=3,574 width=0) (actual time=7.106..7.106 rows=3,572 loops=1)

  • Index Cond: (id_organisation = '8a9483ef5621e35d015626518779001c'::bpchar)
11. 0.085 0.085 ↑ 1.0 1 3,572

Index Only Scan using t_dossier_id_dossier_id_prestataire_id_status_idx on t_dossier dossier1_ (cost=0.42..3.11 rows=1 width=66) (actual time=0.085..0.085 rows=1 loops=3,572)

  • Index Cond: (id_dossier = campagnejo0_.id_dossier)
  • Heap Fetches: 25
12. 0.257 0.257 ↑ 1.0 1 3,572

Index Scan using t_status_periodicite_pkey on t_status_periodicite statusperi4_ (cost=0.42..0.65 rows=1 width=66) (actual time=0.257..0.257 rows=1 loops=3,572)

  • Index Cond: (id_status_periodicite = dossier1_.id_status)
13. 0.004 0.970 ↑ 1.0 1 3

Hash (cost=1.09..1.09 rows=1 width=132) (actual time=0.970..0.970 rows=1 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
14. 0.966 0.966 ↑ 1.0 1 3

Seq Scan on t_dossier_status dossiersta5_ (cost=0.00..1.09 rows=1 width=132) (actual time=0.965..0.966 rows=1 loops=3)

  • Filter: ((code_dossier_status)::text ~~ 'OUVERT'::text)
  • Rows Removed by Filter: 6
15. 0.023 0.023 ↑ 1.0 1 3,294

Index Scan using t_campagne_jour_category_pkey on t_campagne_jour_category campagnejo2_ (cost=0.28..0.41 rows=1 width=66) (actual time=0.023..0.023 rows=1 loops=3,294)

  • Index Cond: (id_category = campagnejo0_.id_category)
16. 0.010 2.431 ↑ 1.0 6 3

Hash (cost=1.06..1.06 rows=6 width=180) (actual time=2.431..2.431 rows=6 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
17. 2.421 2.421 ↑ 1.0 6 3

Seq Scan on t_campagne_jour_zone campagnejo3_ (cost=0.00..1.06 rows=6 width=180) (actual time=2.418..2.421 rows=6 loops=3)