explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KZbC

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 0.442 ↑ 1.0 2 1

Unique (cost=67.44..67.49 rows=2 width=763) (actual time=0.422..0.442 rows=2 loops=1)

2. 0.051 0.423 ↓ 2.0 4 1

Sort (cost=67.44..67.44 rows=2 width=763) (actual time=0.421..0.423 rows=4 loops=1)

  • Sort Key: molecules_1.rec_id, batches.hash, (COALESCE(batches.hash, molecules_1.synonyms[1])), (COALESCE(molecules_1.synonyms[1], batches.hash)), (array_remove(array_cat(molecules_1.synonyms, ARRAY[batches.hash, molecules_1.rec_id]), NULL::character varying)), molecules_1.type, batches.id, batches.name, batches.batch_fields, (COALESCE(sirnas.gene, guides.gene))
  • Sort Method: quicksort Memory: 29kB
3. 0.020 0.372 ↓ 2.0 4 1

Nested Loop (cost=1.96..67.43 rows=2 width=763) (actual time=0.108..0.372 rows=4 loops=1)

4. 0.004 0.278 ↓ 2.0 2 1

Nested Loop Left Join (cost=1.54..50.52 rows=1 width=461) (actual time=0.080..0.278 rows=2 loops=1)

5. 0.001 0.258 ↓ 2.0 2 1

Nested Loop Left Join (cost=1.26..42.21 rows=1 width=456) (actual time=0.071..0.258 rows=2 loops=1)

6. 0.002 0.099 ↓ 2.0 2 1

Nested Loop (cost=0.84..33.77 rows=1 width=449) (actual time=0.059..0.099 rows=2 loops=1)

7. 0.045 0.045 ↑ 1.0 2 1

Index Scan using molecules_rec_id_key on molecules molecules_1 (cost=0.42..16.87 rows=2 width=54) (actual time=0.030..0.045 rows=2 loops=1)

  • Index Cond: ((rec_id)::text = ANY ('{REC-0147642,REC-0142674}'::text[]))
8. 0.052 0.052 ↑ 1.0 1 2

Index Scan using batch_unique_chk on batches (cost=0.42..8.44 rows=1 width=407) (actual time=0.025..0.026 rows=1 loops=2)

  • Index Cond: ((rec_id)::text = (molecules_1.rec_id)::text)
9. 0.158 0.158 ↓ 0.0 0 2

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

  • Index Cond: ((rec_id)::text = (molecules_1.rec_id)::text)
10. 0.016 0.016 ↓ 0.0 0 2

Index Scan using ix_cauldron_guides_rec_id on guides (cost=0.28..8.30 rows=1 width=22) (actual time=0.008..0.008 rows=0 loops=2)

  • Index Cond: ((rec_id)::text = (molecules_1.rec_id)::text)
11. 0.074 0.074 ↑ 1.0 2 2

Index Only Scan using molecules_rec_id_key on molecules (cost=0.42..16.87 rows=2 width=0) (actual time=0.017..0.037 rows=2 loops=2)

  • Index Cond: (rec_id = ANY ('{REC-0147642,REC-0142674}'::text[]))
  • Heap Fetches: 4