explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qgrb

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

WindowAgg (cost=442,054.50..454,665.28 rows=630,539 width=1,805) (actual rows= loops=)

  • JIT:
  • Functions: 53
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
2. 0.000 0.000 ↓ 0.0

Sort (cost=442,054.50..443,630.84 rows=630,539 width=1,797) (actual rows= loops=)

  • Sort Key: ("substring"((unnest(ai_stat_pwi.all_odeon)), '/ ([0-9]+)'::text)), ai_stat_pwi.element
3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=39,381.14..93,506.26 rows=630,539 width=1,797) (actual rows= loops=)

  • Hash Cond: ((ai_stat_pwi.id_grid = mail.id_file) AND (odeon.intervention_id = mail.odeon) AND (ai_pwi.code_projet = mail.pwi_ref_projet) AND (ai_pwi.client = mail.client) AND (ai_pwi.nom_de_la_route = mail.nom_de_la_route))
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=27,370.24..73,219.54 rows=630,539 width=1,769) (actual rows= loops=)

  • Hash Cond: (ai_pwi.idoperation = ai_stat_pwi.element)
5. 0.000 0.000 ↓ 0.0

Seq Scan on ai_pwi (cost=0.00..37,179.39 rows=630,539 width=351) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=26,985.74..26,985.74 rows=30,760 width=1,477) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash Join (cost=25,601.36..26,985.74 rows=30,760 width=1,477) (actual rows= loops=)

  • Hash Cond: (("substring"((unnest(ai_stat_pwi.all_odeon)), '/ ([0-9]+)'::text)) = odeon.intervention_id)
8. 0.000 0.000 ↓ 0.0

Result (cost=0.00..996.03 rows=30,760 width=194) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

ProjectSet (cost=0.00..534.63 rows=30,760 width=162) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on ai_stat_pwi (cost=0.00..357.76 rows=3,076 width=276) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash (cost=22,068.94..22,068.94 rows=282,594 width=1,315) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Seq Scan on odeon_3m_15j odeon (cost=0.00..22,068.94 rows=282,594 width=1,315) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Hash (cost=11,462.88..11,462.88 rows=24,356 width=129) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Subquery Scan on mail (cost=10,914.88..11,462.88 rows=24,356 width=129) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

HashAggregate (cost=10,914.88..11,219.32 rows=24,356 width=129) (actual rows= loops=)

  • Group Key: ai_pwi_fon_mail_detail.id_file, ai_pwi_fon_mail_detail.odeon, ai_pwi_fon_mail_detail.pwi_ref_projet, ai_pwi_fon_mail_detail.client, ai_pwi_fon_mail_detail.nom_de_la_route
16. 0.000 0.000 ↓ 0.0

Seq Scan on ai_pwi_fon_mail_detail (cost=0.00..7,261.55 rows=243,555 width=105) (actual rows= loops=)