explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y8Ka

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

Sort (cost=121,118.89..121,122.60 rows=1,486 width=3,965) (actual rows= loops=)

  • Sort Key: e0_.date_prelevement
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=14,539.39..118,503.09 rows=1,486 width=3,965) (actual rows= loops=)

  • Hash Cond: (r2_.id_statut_resultat_du_client = s7_.id)
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=14,538.31..118,476.01 rows=2,972 width=3,965) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=14,537.75..101,446.82 rows=2,972 width=1,744) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=14,537.19..16,858.98 rows=811 width=1,652) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Only Scan using tiers_pkey on tiers t6_ (cost=0.29..8.30 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = '474c5b77-63d7-4954-a0b9-f9ad6562774b'::uuid)
7. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=14,536.91..16,842.57 rows=811 width=1,668) (actual rows= loops=)

  • Hash Cond: (d4_.id = d3_.id_demande)
8. 0.000 0.000 ↓ 0.0

Seq Scan on demande d4_ (cost=0.00..2,089.12 rows=24,244 width=424) (actual rows= loops=)

  • Filter: ((code_laboratoire)::text = 'LILLAB'::text)
9. 0.000 0.000 ↓ 0.0

Hash (cost=14,526.77..14,526.77 rows=811 width=1,244) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.43..14,526.77 rows=811 width=1,244) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.99..10,065.14 rows=811 width=1,152) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Index Only Scan using tiers_echantillon_type_unique on tiers_echantillon t5_ (cost=0.56..3,282.05 rows=811 width=32) (actual rows= loops=)

  • Index Cond: (id_tiers = '474c5b77-63d7-4954-a0b9-f9ad6562774b'::uuid)
13. 0.000 0.000 ↓ 0.0

Index Scan using echantillon_pkey on echantillon e0_ (cost=0.43..8.35 rows=1 width=1,120) (actual rows= loops=)

  • Index Cond: (id = t5_.id_echantillon)
14. 0.000 0.000 ↓ 0.0

Index Scan using idx_8d43c49334765610 on demande_echantillon d3_ (cost=0.43..5.49 rows=1 width=92) (actual rows= loops=)

  • Index Cond: (e0_.id = id_echantillon)
15. 0.000 0.000 ↓ 0.0

Index Scan using idx_29624cd734765610 on echantillon_resultat_du e1_ (cost=0.56..103.91 rows=39 width=108) (actual rows= loops=)

  • Index Cond: (id_echantillon = e0_.id)
16. 0.000 0.000 ↓ 0.0

Index Scan using resultat_du_pkey on resultat_du r2_ (cost=0.56..5.72 rows=1 width=2,221) (actual rows= loops=)

  • Index Cond: (id = e1_.id_resultat_du)
17. 0.000 0.000 ↓ 0.0

Hash (cost=1.05..1.05 rows=2 width=16) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Seq Scan on statut_resultat_du_client s7_ (cost=0.00..1.05 rows=2 width=16) (actual rows= loops=)

  • Filter: ((code)::text = ANY ('{ENATTENTE,URGENT}'::text[]))