explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PWI5 : Serveur de recette (APG03)

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Merge Join (cost=98,289,896.71..101,591,039.18 rows=165,989,509 width=990) (actual rows= loops=)

  • Merge Cond: (((rapports.idrapport)::text = (detailrapports.idrapport)::text) AND (rapports.version = detailrapports.version))
2. 0.000 0.000 ↓ 0.0

Sort (cost=2,029,558.87..2,034,816.28 rows=2,102,965 width=660) (actual rows= loops=)

  • Sort Key: rapports.idrapport, rapports.version
3. 0.000 0.000 ↓ 0.0

Hash Semi Join (cost=85,963.48..579,575.55 rows=2,102,965 width=660) (actual rows= loops=)

  • Hash Cond: ((rapports.nintervention)::text = (interventions.idintervention)::text)
4. 0.000 0.000 ↓ 0.0

Seq Scan on rapports (cost=0.00..89,790.65 rows=2,102,965 width=660) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=75,601.28..75,601.28 rows=613,296 width=12) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash Join (cost=23.62..75,601.28 rows=613,296 width=12) (actual rows= loops=)

  • Hash Cond: (interventions.idcompte = (compteworkflowclient.idcompte)::numeric)
7. 0.000 0.000 ↓ 0.0

Seq Scan on interventions (cost=0.00..69,440.91 rows=1,226,591 width=21) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash (cost=23.61..23.61 rows=1 width=4) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

HashAggregate (cost=23.60..23.61 rows=1 width=4) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.28..23.59 rows=1 width=4) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on compteworkflowclient (cost=4.28..15.31 rows=1 width=8) (actual rows= loops=)

  • Recheck Cond: (idcompte = 103865)
  • Filter: (wkfactif IS TRUE)
12. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on compteworkflowclient_pkey (cost=0.00..4.28 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (idcompte = 103865)
13. 0.000 0.000 ↓ 0.0

Index Scan using workflow_pkey on workflowclient (cost=0.00..8.27 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (workflowclient.id = compteworkflowclient.idworkflowclient)
  • Filter: (workflowclient.idapplication = 1::numeric)
14. 0.000 0.000 ↓ 0.0

Materialize (cost=96,260,310.79..97,021,579.11 rows=152,253,664 width=330) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Sort (cost=96,260,310.79..96,640,944.95 rows=152,253,664 width=330) (actual rows= loops=)

  • Sort Key: detailrapports.idrapport, detailrapports.version
16. 0.000 0.000 ↓ 0.0

Seq Scan on detailrapports (cost=0.00..6,094,413.64 rows=152,253,664 width=330) (actual rows= loops=)