explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UjfC

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.504 ↑ 1.0 1 1

Aggregate (cost=856.90..856.91 rows=1 width=8) (actual time=0.504..0.504 rows=1 loops=1)

2. 0.000 0.500 ↓ 0.0 0 1

Nested Loop Anti Join (cost=5.87..856.75 rows=58 width=8) (actual time=0.500..0.500 rows=0 loops=1)

3. 0.001 0.500 ↓ 0.0 0 1

Nested Loop (cost=5.31..720.02 rows=58 width=8) (actual time=0.500..0.500 rows=0 loops=1)

4. 0.002 0.499 ↓ 0.0 0 1

Bitmap Heap Scan on dossier_receivers dossierrec1_ (cost=4.88..229.48 rows=58 width=8) (actual time=0.499..0.499 rows=0 loops=1)

  • Recheck Cond: ((receiveractivationcode)::text = 'HN8t7coFQB'::text)
5. 0.497 0.497 ↓ 0.0 0 1

Bitmap Index Scan on idx_dossier_receivers_receiv_ac (cost=0.00..4.86 rows=58 width=0) (actual time=0.497..0.497 rows=0 loops=1)

  • Index Cond: ((receiveractivationcode)::text = 'HN8t7coFQB'::text)
6. 0.000 0.000 ↓ 0.0 0

Index Only Scan using dossier_pkey on dossier dossier0_ (cost=0.43..8.45 rows=1 width=8) (never executed)

  • Index Cond: (id = dossierrec1_.id)
  • Heap Fetches: 0
7. 0.000 0.000 ↓ 0.0 0

Index Only Scan using idx_dossier_user_view_dossier_user on dossier_user_view dossieruse2_ (cost=0.56..2.33 rows=1 width=8) (never executed)

  • Index Cond: ((dossier_id = dossier0_.id) AND (user_id = '8664'::bigint))
  • Heap Fetches: 0