explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hYrL

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 37.749 ↑ 785.5 2 1

Sort (cost=22,922.58..22,926.51 rows=1,571 width=808) (actual time=37.748..37.749 rows=2 loops=1)

  • Sort Key: batches_1.rec_id, batches.hash
  • Sort Method: quicksort Memory: 27kB
2. 0.032 37.734 ↑ 785.5 2 1

Hash Left Join (cost=7,458.73..22,839.18 rows=1,571 width=808) (actual time=36.498..37.734 rows=2 loops=1)

  • Hash Cond: ((batches_1.rec_id)::text = (guides.rec_id)::text)
3. 0.019 36.589 ↑ 785.5 2 1

Nested Loop (cost=7,302.91..22,653.91 rows=1,571 width=514) (actual time=35.356..36.589 rows=2 loops=1)

  • Join Filter: ((batches_1.rec_id)::text = (batches.rec_id)::text)
4. 0.012 36.518 ↑ 1,092.5 2 1

Nested Loop (cost=7,302.49..19,583.60 rows=2,185 width=119) (actual time=35.319..36.518 rows=2 loops=1)

5. 1.260 36.458 ↑ 1,092.5 2 1

Hash Left Join (cost=7,302.07..7,865.82 rows=2,185 width=65) (actual time=35.279..36.458 rows=2 loops=1)

  • Hash Cond: ((batches_1.rec_id)::text = (sirnas.rec_id)::text)
6. 0.014 0.091 ↑ 1,092.5 2 1

HashAggregate (cost=3,236.12..3,257.97 rows=2,185 width=58) (actual time=0.080..0.091 rows=2 loops=1)

  • Group Key: batches_1.rec_id
7. 0.000 0.077 ↑ 1,092.5 2 1

Append (cost=16.88..3,230.66 rows=2,185 width=58) (actual time=0.039..0.077 rows=2 loops=1)

8. 0.001 0.040 ↑ 1.0 2 1

Unique (cost=16.88..16.89 rows=2 width=12) (actual time=0.039..0.040 rows=2 loops=1)

9. 0.006 0.039 ↑ 1.0 2 1

Sort (cost=16.88..16.89 rows=2 width=12) (actual time=0.039..0.039 rows=2 loops=1)

  • Sort Key: batches_1.rec_id
  • Sort Method: quicksort Memory: 25kB
10. 0.033 0.033 ↑ 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.019..0.033 rows=2 loops=1)

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

HashAggregate (cost=3,170.09..3,191.92 rows=2,183 width=13) (actual time=0.037..0.037 rows=0 loops=1)

  • Group Key: molecules_1.rec_id
12. 0.001 0.031 ↓ 0.0 0 1

Bitmap Heap Scan on molecules molecules_1 (cost=44.92..3,164.63 rows=2,183 width=13) (actual time=0.031..0.031 rows=0 loops=1)

  • Recheck Cond: (synonyms && '{75510f04-b7a8-4217-8118-ef09e6562663,a94e57f8-f25d-463c-aa20-887030f4c9c3}'::character varying[])
13. 0.030 0.030 ↓ 0.0 0 1

Bitmap Index Scan on ix_gin_cauldron_molecules_synonyms (cost=0.00..44.37 rows=2,183 width=0) (actual time=0.030..0.030 rows=0 loops=1)

  • Index Cond: (synonyms && '{75510f04-b7a8-4217-8118-ef09e6562663,a94e57f8-f25d-463c-aa20-887030f4c9c3}'::character varying[])
14. 16.160 35.107 ↑ 1.0 75,049 1

Hash (cost=2,681.20..2,681.20 rows=75,420 width=23) (actual time=35.107..35.107 rows=75,049 loops=1)

  • Buckets: 65536 Batches: 2 Memory Usage: 2568kB
15. 18.947 18.947 ↑ 1.0 75,049 1

Seq Scan on sirnas (cost=0.00..2,681.20 rows=75,420 width=23) (actual time=0.010..18.947 rows=75,049 loops=1)

16. 0.048 0.048 ↑ 1.0 1 2

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

  • Index Cond: ((rec_id)::text = (batches_1.rec_id)::text)
17. 0.052 0.052 ↑ 1.0 1 2

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

  • Index Cond: ((rec_id)::text = (molecules.rec_id)::text)
18. 0.437 1.113 ↑ 1.0 3,103 1

Hash (cost=117.03..117.03 rows=3,103 width=22) (actual time=1.113..1.113 rows=3,103 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 198kB
19. 0.676 0.676 ↑ 1.0 3,103 1

Seq Scan on guides (cost=0.00..117.03 rows=3,103 width=22) (actual time=0.011..0.676 rows=3,103 loops=1)