explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gU2

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 11.472 ↑ 1.0 5 1

Limit (cost=56.76..113.52 rows=5 width=1,645) (actual time=11.135..11.472 rows=5 loops=1)

2. 0.023 11.469 ↑ 52.6 10 1

Nested Loop (cost=0.00..5,971.38 rows=526 width=1,645) (actual time=10.783..11.469 rows=10 loops=1)

3. 0.033 11.406 ↑ 52.6 10 1

Nested Loop (cost=0.00..4,445.81 rows=526 width=8) (actual time=10.774..11.406 rows=10 loops=1)

4. 11.313 11.313 ↑ 52.6 10 1

Index Scan using idx_chemical_structure on chemical_structure chemicalst2_ (cost=0.00..20.26 rows=526 width=8) (actual time=10.755..11.313 rows=10 loops=1)

  • Index Cond: (chemical_structure @ ROW('CCNc1ccccc1'::text, ''::text)::bingo.sub)
5. 0.060 0.060 ↑ 1.0 1 10

Index Only Scan using compound_composition_pkey on compound_composition compositio1_ (cost=0.00..8.40 rows=1 width=16) (actual time=0.006..0.006 rows=1 loops=10)

  • Index Cond: (chemical_structure_id = chemicalst2_.structure_id)
  • Heap Fetches: 10
6. 0.040 0.040 ↑ 1.0 1 10

Index Scan using simple_compound_pkey on simple_compound simplecomp0_ (cost=0.00..2.89 rows=1 width=1,645) (actual time=0.004..0.004 rows=1 loops=10)

  • Index Cond: (chem_compound_id = compositio1_.chem_compound_id)