explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iGNO

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

HashAggregate (cost=241.42..241.47 rows=5 width=8) (actual rows= loops=)

  • Group Key: syn_compound.jchem_structure_id
2. 0.000 0.000 ↓ 0.0

Append (cost=0.58..241.41 rows=5 width=8) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.58..167.88 rows=4 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using ld_entity_entity_id_key on ld_entity (cost=0.29..72.19 rows=12 width=8) (actual rows= loops=)

  • Index Cond: (entity_id = ANY ('{CRA-1,CRA-1,CRA-1,CRA-1,CRA-1,CRA-1,CRA-1,CRA-1,CRA-1,CRA-1,CRA-1,CRA-1}'::text[]))
5. 0.000 0.000 ↓ 0.0

Index Scan using syn_compound_pkey on syn_compound (cost=0.29..7.97 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (id = ld_entity.id)
  • Filter: ((jchem_structure_id IS NOT NULL) AND (archived = 0))
6. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.52..73.48 rows=1 width=8) (actual rows= loops=)

  • Hash Cond: (ld_entity_1.id = ld_fragment.id)
7. 0.000 0.000 ↓ 0.0

Index Scan using ld_entity_entity_id_key on ld_entity ld_entity_1 (cost=0.29..72.22 rows=12 width=8) (actual rows= loops=)

  • Index Cond: (entity_id = ANY ('{CRA-1,CRA-1,CRA-1,CRA-1,CRA-1,CRA-1,CRA-1,CRA-1,CRA-1,CRA-1,CRA-1,CRA-1}'::text[]))
  • Filter: (archived = 0)
8. 0.000 0.000 ↓ 0.0

Hash (cost=1.10..1.10 rows=10 width=16) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on ld_fragment (cost=0.00..1.10 rows=10 width=16) (actual rows= loops=)

  • Filter: (jchem_structure_id IS NOT NULL)