explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hy75

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 0.182 ↑ 1.0 3 1

Sort (cost=57.31..57.31 rows=3 width=763) (actual time=0.181..0.182 rows=3 loops=1)

  • Sort Key: molecules.rec_id, batches.hash
  • Sort Method: quicksort Memory: 28kB
2. 0.011 0.169 ↑ 1.0 3 1

Nested Loop Left Join (cost=1.96..57.28 rows=3 width=763) (actual time=0.071..0.169 rows=3 loops=1)

3. 0.001 0.149 ↑ 1.0 3 1

Nested Loop Left Join (cost=1.68..56.34 rows=3 width=456) (actual time=0.060..0.149 rows=3 loops=1)

4. 0.003 0.133 ↑ 1.0 3 1

Nested Loop Left Join (cost=1.26..54.86 rows=3 width=449) (actual time=0.053..0.133 rows=3 loops=1)

5. 0.002 0.079 ↑ 1.0 3 1

Nested Loop (cost=0.84..50.65 rows=3 width=54) (actual time=0.033..0.079 rows=3 loops=1)

6. 0.047 0.047 ↑ 1.0 3 1

Index Only Scan using molecules_rec_id_key on molecules molecules_1 (cost=0.42..25.31 rows=3 width=13) (actual time=0.020..0.047 rows=3 loops=1)

  • Index Cond: (rec_id = ANY ('{REC-0122549,REC-0067358,REC-0131713}'::text[]))
  • Heap Fetches: 3
7. 0.030 0.030 ↑ 1.0 1 3

Index Scan using molecules_rec_id_key on molecules (cost=0.42..8.44 rows=1 width=54) (actual time=0.010..0.010 rows=1 loops=3)

  • Index Cond: ((rec_id)::text = (molecules_1.rec_id)::text)
8. 0.051 0.051 ↑ 1.0 1 3

Index Scan using ix_cauldron_batches_rec_id on batches (cost=0.42..1.39 rows=1 width=407) (actual time=0.017..0.017 rows=1 loops=3)

  • Index Cond: ((molecules.rec_id)::text = (rec_id)::text)
9. 0.015 0.015 ↓ 0.0 0 3

Index Scan using ix_cauldron_sirnas_rec_id on sirnas (cost=0.42..0.48 rows=1 width=23) (actual time=0.005..0.005 rows=0 loops=3)

  • Index Cond: ((rec_id)::text = (molecules.rec_id)::text)
10. 0.009 0.009 ↓ 0.0 0 3

Index Scan using ix_cauldron_guides_rec_id on guides (cost=0.28..0.30 rows=1 width=22) (actual time=0.003..0.003 rows=0 loops=3)

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