explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qdqo

Settings
# exclusive inclusive rows x rows loops node
1. 0.060 212.121 ↑ 770.0 10 1

Sort (cost=41,853.78..41,873.03 rows=7,700 width=808) (actual time=212.117..212.121 rows=10 loops=1)

  • Sort Key: batches_1.rec_id, batches.hash
  • Sort Method: quicksort Memory: 35kB
2. 0.100 212.061 ↑ 770.0 10 1

Hash Left Join (cost=19,557.14..38,616.22 rows=7,700 width=808) (actual time=162.715..212.061 rows=10 loops=1)

  • Hash Cond: ((batches_1.rec_id)::text = (guides.rec_id)::text)
3. 0.082 210.818 ↑ 770.0 10 1

Nested Loop (cost=19,401.32..38,316.03 rows=7,700 width=514) (actual time=161.532..210.818 rows=10 loops=1)

  • Join Filter: ((batches_1.rec_id)::text = (batches.rec_id)::text)
4. 44.177 210.436 ↑ 1,071.0 10 1

Hash Join (cost=19,400.90..23,266.63 rows=10,710 width=119) (actual time=161.480..210.436 rows=10 loops=1)

  • Hash Cond: ((batches_1.rec_id)::text = (molecules.rec_id)::text)
5. 5.117 42.625 ↑ 1,071.0 10 1

Hash Left Join (cost=8,070.84..9,106.31 rows=10,710 width=65) (actual time=37.726..42.625 rows=10 loops=1)

  • Hash Cond: ((batches_1.rec_id)::text = (sirnas.rec_id)::text)
6. 0.055 0.371 ↑ 1,071.0 10 1

HashAggregate (cost=4,004.89..4,111.99 rows=10,710 width=58) (actual time=0.329..0.371 rows=10 loops=1)

  • Group Key: batches_1.rec_id
7. 0.003 0.316 ↑ 1,071.0 10 1

Append (cost=84.54..3,978.12 rows=10,710 width=58) (actual time=0.174..0.316 rows=10 loops=1)

8. 0.001 0.174 ↑ 1.0 10 1

Unique (cost=84.54..84.59 rows=10 width=12) (actual time=0.172..0.174 rows=10 loops=1)

9. 0.031 0.173 ↑ 1.0 10 1

Sort (cost=84.54..84.57 rows=10 width=12) (actual time=0.172..0.173 rows=10 loops=1)

  • Sort Key: batches_1.rec_id
  • Sort Method: quicksort Memory: 25kB
10. 0.142 0.142 ↑ 1.0 10 1

Index Scan using batches_hash_key on batches batches_1 (cost=0.42..84.37 rows=10 width=12) (actual time=0.038..0.142 rows=10 loops=1)

  • Index Cond: ((hash)::text = ANY ('{75510f04-b7a8-4217-8118-ef09e6562663,a94e57f8-f25d-463c-aa20-887030f4c9c3,b0ea1af2-50e1-4919-bf29-ec78ffdc0072,10bca36f-c24d-48bd-a048-7d6a881f42b7,be5f8370-bacc-4118-a064-030e1b993cd9,413a8a65-567d-4526-ba67-835703c91fac,3e5b1900-eddf-4609-afbb-414056f01faf,d8a33ee8-fa4d-4502-a078-c30a1742a0db,d77cbe02-c438-4dba-a4f8-26cf672e4148,082bb222-a373-4ee2-86fe-d3ed2749811a}'::text[]))
11. 0.054 0.139 ↓ 0.0 0 1

HashAggregate (cost=3,679.43..3,786.43 rows=10,700 width=13) (actual time=0.139..0.139 rows=0 loops=1)

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

Bitmap Heap Scan on molecules molecules_1 (cost=218.93..3,652.68 rows=10,700 width=13) (actual time=0.085..0.085 rows=0 loops=1)

  • Recheck Cond: (synonyms && '{75510f04-b7a8-4217-8118-ef09e6562663,a94e57f8-f25d-463c-aa20-887030f4c9c3,b0ea1af2-50e1-4919-bf29-ec78ffdc0072,10bca36f-c24d-48bd-a048-7d6a881f42b7,be5f8370-bacc-4118-a064-030e1b993cd9,413a8a65-567d-4526-ba67-835703c91fac,3e5b1900-eddf-4609-afbb-414056f01faf,d8a33ee8-fa4d-4502-a078-c30a1742a0db,d77cbe02-c438-4dba-a4f8-26cf672e4148,082bb222-a373-4ee2-86fe-d3ed2749811a}'::character varying[])
13. 0.084 0.084 ↓ 0.0 0 1

Bitmap Index Scan on ix_gin_cauldron_molecules_synonyms (cost=0.00..216.25 rows=10,700 width=0) (actual time=0.084..0.084 rows=0 loops=1)

  • Index Cond: (synonyms && '{75510f04-b7a8-4217-8118-ef09e6562663,a94e57f8-f25d-463c-aa20-887030f4c9c3,b0ea1af2-50e1-4919-bf29-ec78ffdc0072,10bca36f-c24d-48bd-a048-7d6a881f42b7,be5f8370-bacc-4118-a064-030e1b993cd9,413a8a65-567d-4526-ba67-835703c91fac,3e5b1900-eddf-4609-afbb-414056f01faf,d8a33ee8-fa4d-4502-a078-c30a1742a0db,d77cbe02-c438-4dba-a4f8-26cf672e4148,082bb222-a373-4ee2-86fe-d3ed2749811a}'::character varying[])
14. 17.026 37.137 ↑ 1.0 75,049 1

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

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

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

16. 63.108 123.634 ↑ 1.0 248,847 1

Hash (cost=5,788.47..5,788.47 rows=248,847 width=54) (actual time=123.633..123.634 rows=248,847 loops=1)

  • Buckets: 65536 Batches: 8 Memory Usage: 3088kB
17. 60.526 60.526 ↑ 1.0 248,847 1

Seq Scan on molecules (cost=0.00..5,788.47 rows=248,847 width=54) (actual time=0.011..60.526 rows=248,847 loops=1)

18. 0.300 0.300 ↑ 1.0 1 10

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

  • Index Cond: ((rec_id)::text = (molecules.rec_id)::text)
19. 0.435 1.143 ↑ 1.0 3,103 1

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

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

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