explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TKsb

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

Merge Join (cost=290,765,409.44..296,356,697.15 rows=280,646,422 width=1,381) (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=68,354,723.18..68,363,660.53 rows=3,574,942 width=881) (actual rows= loops=)

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

Hash Semi Join (cost=64,162,412.27..65,191,870.89 rows=3,574,942 width=881) (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..151,751.42 rows=3,574,942 width=881) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=64,144,049.57..64,144,049.57 rows=1,086,856 width=12) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on interventions (cost=0.00..64,144,049.57 rows=1,086,856 width=12) (actual rows= loops=)

  • Filter: (alternatives: SubPlan 1 or hashed SubPlan 2)
7.          

SubPlan (for Seq Scan)

8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..1,207.52 rows=41 width=0) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on compteworkflowclient (cost=0.00..899.80 rows=41 width=4) (actual rows= loops=)

  • Filter: ((wkfactif IS TRUE) AND ($0 = (idcompte)::numeric))
10. 0.000 0.000 ↓ 0.0

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

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

Hash Join (cost=2,098.14..3,026.34 rows=8,160 width=4) (actual rows= loops=)

  • Hash Cond: (administration.compteworkflowclient.idworkflowclient = administration.workflowclient.id)
12. 0.000 0.000 ↓ 0.0

Seq Scan on compteworkflowclient (cost=0.00..724.20 rows=8,160 width=8) (actual rows= loops=)

  • Filter: (wkfactif IS TRUE)
13. 0.000 0.000 ↓ 0.0

Hash (cost=1,680.72..1,680.72 rows=33,393 width=4) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Seq Scan on workflowclient (cost=0.00..1,680.72 rows=33,393 width=4) (actual rows= loops=)

  • Filter: (idapplication = 1::numeric)
15. 0.000 0.000 ↓ 0.0

Materialize (cost=222,410,397.99..223,717,482.43 rows=261,416,887 width=500) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Sort (cost=222,410,397.99..223,063,940.21 rows=261,416,887 width=500) (actual rows= loops=)

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

Seq Scan on detailrapports (cost=0.00..10,286,338.87 rows=261,416,887 width=500) (actual rows= loops=)