explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kTXUc

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

Merge Join (cost=123,878,704.45..128,240,850.28 rows=220,411,792 width=763) (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=1,944,450.52..1,951,127.74 rows=2,670,889 width=435) (actual rows= loops=)

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

Hash Semi Join (cost=139,294.29..609,508.96 rows=2,670,889 width=435) (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..113,566.89 rows=2,670,889 width=435) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=126,700.77..126,700.77 rows=745,402 width=12) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash Join (cost=2,403.70..126,700.77 rows=745,402 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=2,380.79..2,380.79 rows=1,833 width=4) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

HashAggregate (cost=2,362.46..2,380.79 rows=1,833 width=4) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash Join (cost=650.84..2,346.78 rows=6,269 width=4) (actual rows= loops=)

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

Seq Scan on workflowclient (cost=0.00..1,339.50 rows=26,111 width=4) (actual rows= loops=)

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

Hash (cost=561.17..561.17 rows=7,174 width=8) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Seq Scan on compteworkflowclient (cost=0.00..561.17 rows=7,174 width=8) (actual rows= loops=)

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

Materialize (cost=121,934,212.62..122,904,246.18 rows=194,006,713 width=328) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Sort (cost=121,934,212.62..122,419,229.40 rows=194,006,713 width=328) (actual rows= loops=)

  • Sort Key: detailrapports.idrapport, detailrapports.version
16. 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=)