explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Bu8z : Serveur de pré-production (APG02)

Settings

Optimization path:

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

Hash Join (cost=129,808.51..10,745,580.83 rows=834,150 width=763) (actual rows= loops=)

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

Seq Scan on detailrapports (cost=0.00..7,697,330.13 rows=194,006,713 width=328) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=129,656.89..129,656.89 rows=10,108 width=435) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=91,824.97..129,656.89 rows=10,108 width=435) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

HashAggregate (cost=91,824.97..91,829.03 rows=406 width=12) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash Semi Join (cost=27.21..91,823.95 rows=406 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..87,692.05 rows=1,490,805 width=21) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

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

9. 0.000 0.000 ↓ 0.0

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

10. 0.000 0.000 ↓ 0.0

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

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

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

  • Index Cond: (idcompte = 103865)
12. 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)
13. 0.000 0.000 ↓ 0.0

Index Scan using rapports_index_nintervention on rapports (cost=0.00..92.86 rows=25 width=435) (actual rows= loops=)

  • Index Cond: ((rapports.nintervention)::text = (interventions.idintervention)::text))