explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MCDl

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.011 ↑ 1.0 1 1

Aggregate (cost=38.94..38.95 rows=1 width=8) (actual time=0.011..0.011 rows=1 loops=1)

2. 0.000 0.009 ↓ 0.0 0 1

Nested Loop Semi Join (cost=9.33..38.94 rows=1 width=8) (actual time=0.009..0.009 rows=0 loops=1)

3. 0.001 0.009 ↓ 0.0 0 1

Hash Join (cost=8.46..20.12 rows=1 width=24) (actual time=0.009..0.009 rows=0 loops=1)

  • Hash Cond: (facture0_.document_id = document1_.id)
4. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on facture facture0_ (cost=0.00..11.50 rows=40 width=16) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: (mt_restant_du > '0'::numeric)
5. 0.000 0.000 ↓ 0.0 0

Hash (cost=8.45..8.45 rows=1 width=8) (never executed)

6. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_document_type on document document1_ (cost=0.43..8.45 rows=1 width=8) (never executed)

  • Index Cond: ((type)::text = 'FACTURE'::text)
7. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.86..9.84 rows=1 width=8) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_document_receivers_id_receiv_ac on document_receivers documentre2_ (cost=0.43..8.45 rows=1 width=16) (never executed)

  • Index Cond: (id = facture0_.document_id)
9. 0.000 0.000 ↓ 0.0 0

Index Scan using activation_code_pkey on activation_code activation3_ (cost=0.43..1.38 rows=1 width=8) (never executed)

  • Index Cond: (id = documentre2_.activation_code_id)
  • Filter: ((activation_code)::text = 'HN8t7coFQB'::text)