explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7iXX

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

Limit (cost=1.52..251.41 rows=10 width=514) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.52..364,430.60 rows=14,584 width=514) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=1.11..356,144.60 rows=15,459 width=514) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on artisans (cost=0.00..5,454.49 rows=109,849 width=514) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=1.11..3.18 rows=1 width=16) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=0.83..2.86 rows=1 width=48) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Scan using index_qualifications_obtenues_on_artisan_id on qualifications_obtenues (cost=0.42..1.07 rows=2 width=32) (actual rows= loops=)

  • Index Cond: (artisan_id = artisans.id)
  • Filter: ((date_debut <= '2019-02-07'::date) AND (date_fin >= '2019-02-07'::date))
8. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=0.41..0.88 rows=1 width=16) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Index Scan using index_operations_qualifications_on_qualification_id on operations_qualifications operations_qualifications_1 (cost=0.28..0.33 rows=3 width=32) (actual rows= loops=)

  • Index Cond: (qualification_id = qualifications_obtenues.qualification_id)
10. 0.000 0.000 ↓ 0.0

Index Scan using index_types_travaux_on_operation_id on types_travaux (cost=0.14..0.17 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (operation_id = operations_qualifications_1.operation_id)
  • Filter: ((slug)::text = 'isolation-du-sol'::text)
11. 0.000 0.000 ↓ 0.0

Index Only Scan using index_operations_qualifications_on_qualification_id on operations_qualifications (cost=0.28..0.33 rows=3 width=16) (actual rows= loops=)

  • Index Cond: (qualification_id = qualifications_obtenues.qualification_id)
12. 0.000 0.000 ↓ 0.0

Index Scan using entreprises_pkey on entreprises (cost=0.42..0.54 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = artisans.entreprise_id)
  • Filter: ((etat_administratif)::text = 'Active'::text)