explain.depesz.com

PostgreSQL's explain analyze made readable

Result: u1ex

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

Merge Join (cost=167,504,435.70..173,550,913.80 rows=306,146,810 width=813) (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,529,161.83..2,538,240.57 rows=3,631,495 width=436) (actual rows= loops=)

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

Hash Semi Join (cost=253,527.78..909,969.74 rows=3,631,495 width=436) (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..156,987.95 rows=3,631,495 width=436) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=232,876.76..232,876.76 rows=1,222,322 width=12) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,084.38..232,876.76 rows=1,222,322 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..167,709.43 rows=2,444,643 width=21) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash (cost=3,061.81..3,061.81 rows=1,805 width=4) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

HashAggregate (cost=3,043.76..3,061.81 rows=1,805 width=4) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash Join (cost=839.93..3,025.44 rows=7,330 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,693.89 rows=33,466 width=4) (actual rows= loops=)

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

Hash (cost=738.10..738.10 rows=8,146 width=8) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

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

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

Materialize (cost=164,975,217.71..166,298,859.55 rows=264,728,368 width=377) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Sort (cost=164,975,217.71..165,637,038.63 rows=264,728,368 width=377) (actual rows= loops=)

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

Seq Scan on detailrapports (cost=0.00..10,440,733.68 rows=264,728,368 width=377) (actual rows= loops=)