explain.depesz.com

PostgreSQL's explain analyze made readable

Result: J8DK : Optimization for: Optimization for: plan #GRfc; plan #D5Cu

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.001 0.029 ↓ 0.0 0 1

Nested Loop Left Join (cost=45.76..20,155.89 rows=2,183 width=50) (actual time=0.029..0.029 rows=0 loops=1)

  • Join Filter: ((batches_1.rec_id)::text = (m.rec_id)::text)
2. 0.000 0.028 ↓ 0.0 0 1

Nested Loop Left Join (cost=45.34..20,073.52 rows=2,183 width=50) (actual time=0.028..0.028 rows=0 loops=1)

3. 0.001 0.028 ↓ 0.0 0 1

Bitmap Heap Scan on molecules m (cost=44.92..3,164.63 rows=2,183 width=13) (actual time=0.028..0.028 rows=0 loops=1)

  • Recheck Cond: (synonyms && '{3e268ce3-1480-4fd0-bf48-004fe835fe29,63beffc3-524a-4a7a-b70c-163f3336ba44}'::character varying[])
4. 0.027 0.027 ↓ 0.0 0 1

Bitmap Index Scan on ix_gin_cauldron_molecules_synonyms (cost=0.00..44.37 rows=2,183 width=0) (actual time=0.027..0.027 rows=0 loops=1)

  • Index Cond: (synonyms && '{3e268ce3-1480-4fd0-bf48-004fe835fe29,63beffc3-524a-4a7a-b70c-163f3336ba44}'::character varying[])
5. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_cauldron_batches_rec_id on batches (cost=0.42..7.74 rows=1 width=49) (never executed)

  • Index Cond: ((m.rec_id)::text = (rec_id)::text)
6. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.42..16.88 rows=2 width=12) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Index Scan using batches_hash_key on batches batches_1 (cost=0.42..16.87 rows=2 width=12) (never executed)

  • Index Cond: ((hash)::text = ANY ('{3e268ce3-1480-4fd0-bf48-004fe835fe29,63beffc3-524a-4a7a-b70c-163f3336ba44}'::text[]))