explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ocC

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 6,342.543 ↑ 1.0 5 1

Limit (cost=5,984.58..5,984.63 rows=5 width=1,645) (actual time=6,342.541..6,342.543 rows=5 loops=1)

2. 176.030 6,342.542 ↑ 52.6 10 1

HashAggregate (cost=5,984.53..5,989.79 rows=526 width=1,645) (actual time=6,342.538..6,342.542 rows=10 loops=1)

3. 86.268 6,166.512 ↓ 244.3 128,527 1

Nested Loop (cost=0.00..5,971.38 rows=526 width=1,645) (actual time=7.289..6,166.512 rows=128,527 loops=1)

4. 167.011 5,694.663 ↓ 244.3 128,527 1

Nested Loop (cost=0.00..4,445.81 rows=526 width=8) (actual time=7.281..5,694.663 rows=128,527 loops=1)

5. 5,013.620 5,013.620 ↓ 244.3 128,508 1

Index Scan using idx_chemical_structure on chemical_structure chemicalst2_ (cost=0.00..20.26 rows=526 width=8) (actual time=7.262..5,013.620 rows=128,508 loops=1)

  • Index Cond: (chemical_structure @ ROW('CCNc1ccccc1'::text, ''::text)::bingo.sub)
6. 514.032 514.032 ↑ 1.0 1 128,508

Index Only Scan using compound_composition_pkey on compound_composition compositio1_ (cost=0.00..8.40 rows=1 width=16) (actual time=0.003..0.004 rows=1 loops=128,508)

  • Index Cond: (chemical_structure_id = chemicalst2_.structure_id)
  • Heap Fetches: 128527
7. 385.581 385.581 ↑ 1.0 1 128,527

Index Scan using idx_pk on simple_compound simplecomp0_ (cost=0.00..2.89 rows=1 width=1,645) (actual time=0.002..0.003 rows=1 loops=128,527)

  • Index Cond: (chem_compound_id = compositio1_.chem_compound_id)