explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1sZX

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.288 ↓ 1.3 4 1

Nested Loop Left Join (cost=22.92..108.24 rows=3 width=1,234) (actual time=0.147..0.288 rows=4 loops=1)

2. 0.003 0.258 ↓ 1.3 4 1

Nested Loop Left Join (cost=22.64..83.32 rows=3 width=728) (actual time=0.136..0.258 rows=4 loops=1)

3. 0.006 0.215 ↓ 1.3 4 1

Nested Loop (cost=22.22..57.99 rows=3 width=551) (actual time=0.121..0.215 rows=4 loops=1)

  • Join Filter: ((batches_1.rec_id)::text = (molecules.rec_id)::text)
4. 0.002 0.141 ↑ 1.2 4 1

Nested Loop (cost=21.80..55.25 rows=5 width=481) (actual time=0.099..0.141 rows=4 loops=1)

5. 0.008 0.082 ↑ 1.3 3 1

HashAggregate (cost=21.38..21.42 rows=4 width=58) (actual time=0.080..0.082 rows=3 loops=1)

  • Group Key: batches_1.rec_id
6. 0.000 0.074 ↑ 1.3 3 1

Append (cost=0.42..21.37 rows=4 width=58) (actual time=0.028..0.074 rows=3 loops=1)

7. 0.002 0.053 ↑ 1.5 2 1

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

8. 0.051 0.051 ↑ 1.0 3 1

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

  • Index Cond: (rec_id = ANY ('{REC-0006392,REC-0122549}'::text[]))
  • Heap Fetches: 1
9. 0.000 0.021 ↑ 1.0 1 1

Unique (cost=0.42..8.44 rows=1 width=13) (actual time=0.021..0.021 rows=1 loops=1)

10. 0.021 0.021 ↑ 1.0 1 1

Index Only Scan using molecules_rec_id_key on molecules molecules_1 (cost=0.42..8.44 rows=1 width=13) (actual time=0.021..0.021 rows=1 loops=1)

  • Index Cond: (rec_id = 'REC-0067358'::text)
  • Heap Fetches: 1
11. 0.057 0.057 ↑ 1.0 1 3

Index Scan using batch_unique_chk on batches (cost=0.42..8.44 rows=1 width=423) (actual time=0.018..0.019 rows=1 loops=3)

  • Index Cond: ((rec_id)::text = (batches_1.rec_id)::text)
12. 0.068 0.068 ↑ 1.0 1 4

Index Scan using molecules_rec_id_key on molecules (cost=0.42..0.53 rows=1 width=70) (actual time=0.017..0.017 rows=1 loops=4)

  • Index Cond: ((rec_id)::text = (batches.rec_id)::text)
13. 0.040 0.040 ↓ 0.0 0 4

Index Scan using ix_cauldron_sirnas_rec_id on sirnas (cost=0.42..8.44 rows=1 width=177) (actual time=0.010..0.010 rows=0 loops=4)

  • Index Cond: ((rec_id)::text = (batches_1.rec_id)::text)
14. 0.028 0.028 ↓ 0.0 0 4

Index Scan using ix_cauldron_guides_rec_id on guides (cost=0.28..8.30 rows=1 width=506) (actual time=0.007..0.007 rows=0 loops=4)

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