explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dHOd

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 0.187 ↓ 2.0 2 1

Nested Loop Left Join (cost=18.42..68.39 rows=1 width=763) (actual time=0.140..0.187 rows=2 loops=1)

2. 0.002 0.160 ↓ 2.0 2 1

Nested Loop Left Join (cost=18.14..68.08 rows=1 width=456) (actual time=0.120..0.160 rows=2 loops=1)

3. 0.006 0.140 ↓ 2.0 2 1

Nested Loop (cost=17.72..67.54 rows=1 width=449) (actual time=0.108..0.140 rows=2 loops=1)

4. 0.044 0.044 ↑ 1.0 2 1

Index Scan using batches_hash_key on batches (cost=0.42..16.87 rows=2 width=407) (actual time=0.036..0.044 rows=2 loops=1)

  • Index Cond: ((hash)::text = ANY ('{75510f04-b7a8-4217-8118-ef09e6562663,a94e57f8-f25d-463c-aa20-887030f4c9c3}'::text[]))
5. 0.061 0.090 ↑ 1.0 1 2

Index Scan using molecules_rec_id_key on molecules (cost=17.30..25.32 rows=1 width=54) (actual time=0.045..0.045 rows=1 loops=2)

  • Index Cond: ((rec_id)::text = (batches.rec_id)::text)
  • Filter: ((synonyms && '{75510f04-b7a8-4217-8118-ef09e6562663,a94e57f8-f25d-463c-aa20-887030f4c9c3}'::character varying[]) OR (hashed SubPlan 1))
6.          

SubPlan (for Index Scan)

7. 0.029 0.029 ↑ 1.0 2 1

Index Scan using batches_hash_key on batches batches_1 (cost=0.42..16.87 rows=2 width=12) (actual time=0.010..0.029 rows=2 loops=1)

  • Index Cond: ((hash)::text = ANY ('{75510f04-b7a8-4217-8118-ef09e6562663,a94e57f8-f25d-463c-aa20-887030f4c9c3}'::text[]))
8. 0.018 0.018 ↓ 0.0 0 2

Index Scan using ix_cauldron_sirnas_rec_id on sirnas si (cost=0.42..0.53 rows=1 width=23) (actual time=0.009..0.009 rows=0 loops=2)

  • Index Cond: ((molecules.rec_id)::text = (rec_id)::text)
9. 0.014 0.014 ↓ 0.0 0 2

Index Scan using ix_cauldron_sgrnas_rec_id on sgrnas sg (cost=0.28..0.30 rows=1 width=21) (actual time=0.007..0.007 rows=0 loops=2)

  • Index Cond: ((molecules.rec_id)::text = (rec_id)::text)