explain.depesz.com

PostgreSQL's explain analyze made readable

Result: v6mxb

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 0.222 ↑ 2.0 2 1

Sort (cost=78.66..78.67 rows=4 width=763) (actual time=0.222..0.222 rows=2 loops=1)

  • Sort Key: molecules.rec_id, batches.hash
  • Sort Method: quicksort Memory: 27kB
2. 0.010 0.209 ↑ 2.0 2 1

Nested Loop Left Join (cost=31.37..78.62 rows=4 width=763) (actual time=0.160..0.209 rows=2 loops=1)

3. 0.002 0.185 ↑ 2.0 2 1

Nested Loop Left Join (cost=31.09..77.36 rows=4 width=456) (actual time=0.144..0.185 rows=2 loops=1)

4. 0.000 0.165 ↑ 2.0 2 1

Nested Loop (cost=30.67..75.39 rows=4 width=449) (actual time=0.133..0.165 rows=2 loops=1)

5. 0.003 0.136 ↑ 3.0 2 1

Nested Loop (cost=30.25..72.12 rows=6 width=419) (actual time=0.118..0.136 rows=2 loops=1)

6. 0.005 0.099 ↑ 2.5 2 1

HashAggregate (cost=29.83..29.88 rows=5 width=12) (actual time=0.098..0.099 rows=2 loops=1)

  • Group Key: (batches_1.rec_id)::text
7. 0.004 0.094 ↑ 1.2 4 1

Result (cost=0.42..29.82 rows=5 width=12) (actual time=0.027..0.094 rows=4 loops=1)

8. 0.000 0.090 ↑ 1.2 4 1

Append (cost=0.42..29.82 rows=5 width=12) (actual time=0.025..0.090 rows=4 loops=1)

9. 0.003 0.048 ↑ 1.5 2 1

Unique (cost=0.42..12.89 rows=3 width=12) (actual time=0.025..0.048 rows=2 loops=1)

10. 0.045 0.045 ↑ 1.5 2 1

Index Only Scan using batch_unique_chk on batches batches_1 (cost=0.42..12.88 rows=3 width=12) (actual time=0.024..0.045 rows=2 loops=1)

  • Index Cond: (rec_id = ANY ('{REC-0135598,REC-0162119}'::text[]))
  • Heap Fetches: 1
11. 0.000 0.042 ↑ 1.0 2 1

Unique (cost=0.42..16.88 rows=2 width=13) (actual time=0.022..0.042 rows=2 loops=1)

12. 0.042 0.042 ↑ 1.0 2 1

Index Only Scan using molecules_rec_id_key on molecules molecules_1 (cost=0.42..16.87 rows=2 width=13) (actual time=0.022..0.042 rows=2 loops=1)

  • Index Cond: (rec_id = ANY ('{REC-0135598,REC-0162119}'::text[]))
  • Heap Fetches: 2
13. 0.034 0.034 ↑ 1.0 1 2

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

  • Index Cond: ((rec_id)::text = (batches_1.rec_id)::text)
14. 0.030 0.030 ↑ 1.0 1 2

Index Scan using molecules_rec_id_key on molecules (cost=0.42..0.53 rows=1 width=54) (actual time=0.015..0.015 rows=1 loops=2)

  • Index Cond: ((rec_id)::text = (batches.rec_id)::text)
15. 0.018 0.018 ↓ 0.0 0 2

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

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

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

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