explain.depesz.com

A tool for finding a real cause for slow queries.

Result: zVo

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=30.59..30.60 rows=1 width=0) (actual time=.. rows= loops=)

2. 0.000 0.000 ↓ 0.0

HashAggregate (cost=30.57..30.58 rows=1 width=24) (actual time=.. rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..30.56 rows=1 width=24) (actual time=.. rows= loops=)

  • Join Filter: ((facts1.component_id = facts3.component_id) AND (facts1.pre = facts3.parent) AND (facts2.text_ref = facts3.text_ref) AND (facts2.right_token <= (facts3.left_token - 1)))
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..20.37 rows=1 width=60) (actual time=.. rows= loops=)

  • Join Filter: ((facts1.component_id = facts2.component_id) AND (facts1.pre = facts2.parent))
5. 0.000 0.000 ↓ 0.0

Seq Scan on facts facts1 (cost=0.00..10.18 rows=1 width=24) (actual time=.. rows= loops=)

  • Filter: ((edge_name IS NULL) AND root AND (edge_type = 'd'::bpchar) AND ((node_annotation_name)::text = 'cat'::text) AND ((node_annotation_value)::text = 'S'::text))
6. 0.000 0.000 ↓ 0.0

Seq Scan on facts facts2 (cost=0.00..10.18 rows=1 width=36) (actual time=.. rows= loops=)

  • Filter: ((edge_name IS NULL) AND (edge_type = 'd'::bpchar) AND ((node_annotation_name)::text = 'pos'::text) AND ((node_annotation_value)::text = 'VVFIN'::text))
7. 0.000 0.000 ↓ 0.0

Seq Scan on facts facts3 (cost=0.00..10.18 rows=1 width=36) (actual time=.. rows= loops=)

  • Filter: ((edge_name IS NULL) AND (edge_type = 'd'::bpchar) AND ((edge_annotation_name)::text = 'func'::text) AND ((edge_annotation_value)::text = 'SB'::text))