explain.depesz.com

A tool for finding a real cause for slow queries.

Result: W9r : cat="S" & pos="VVFIN" & #1 > #2

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 2.076 11,442.937 ↑ 1.0 1 1

Aggregate (cost=17,727.23..17,727.24 rows=1 width=0) (actual time=11,442.937..11,442.937 rows=1 loops=1)

2. 40.422 11,440.861 ↓ 35,875.0 35,875 1

HashAggregate (cost=17,727.20..17,727.21 rows=1 width=8) (actual time=11,434.465..11,440.861 rows=35,875 loops=1)

3. 154.647 11,400.439 ↓ 36,009.0 36,009 1

Nested Loop (cost=280.53..17,727.20 rows=1 width=8) (actual time=21.299..11,400.439 rows=36,009 loops=1)

4. 152.595 10,691.390 ↓ 277,201.0 277,201 1

Nested Loop (cost=280.53..17,573.31 rows=1 width=12) (actual time=21.228..10,691.390 rows=277,201 loops=1)

5. 684.470 9,984.393 ↓ 277,201.0 277,201 1

Nested Loop (cost=280.53..17,572.87 rows=1 width=8) (actual time=21.218..9,984.393 rows=277,201 loops=1)

6. 340.606 7,080.995 ↓ 1,109,464.0 1,109,464 1

Nested Loop (cost=280.53..17,418.98 rows=1 width=12) (actual time=21.156..7,080.995 rows=1,109,464 loops=1)

7. 398.799 4,521.461 ↓ 1,109,464.0 1,109,464 1

Nested Loop (cost=280.53..17,418.54 rows=1 width=8) (actual time=21.122..4,521.461 rows=1,109,464 loops=1)

  • Join Filter: (component1.id = rank1.component_ref)
8. 267.252 1,806.302 ↓ 1,158,180.0 1,158,180 1

Nested Loop (cost=280.53..17,409.99 rows=1 width=20) (actual time=21.088..1,806.302 rows=1,158,180 loops=1)

9. 45.978 175.002 ↓ 48,716.0 48,716 1

Nested Loop (cost=49.80..122.36 rows=1 width=8) (actual time=21.052..175.002 rows=48,716 loops=1)

10. 10.703 31.592 ↓ 8,119.3 48,716 1

Bitmap Heap Scan on component component1 (cost=49.80..72.51 rows=6 width=4) (actual time=21.023..31.592 rows=48,716 loops=1)

  • Recheck Cond: ((name IS NULL) AND (type = 'd'::bpchar))
11. 0.098 20.889 ↓ 0.0 0 1

BitmapAnd (cost=49.80..49.80 rows=6 width=0) (actual time=20.889..20.889 rows=0 loops=1)

12. 11.522 11.522 ↓ 152.9 173,257 1

Bitmap Index Scan on idx_component_name (cost=0.00..24.77 rows=1,133 width=0) (actual time=11.522..11.522 rows=173,257 loops=1)

  • Index Cond: (name IS NULL)
13. 9.269 9.269 ↓ 90.1 102,136 1

Bitmap Index Scan on idx_component_type (cost=0.00..24.77 rows=1,133 width=0) (actual time=9.269..9.269 rows=102,136 loops=1)

  • Index Cond: (type = 'd'::bpchar)
14. 97.432 97.432 ↑ 1.0 1 48,716

Index Scan using "PK_component" on component component2 (cost=0.00..8.29 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=48,716)

  • Index Cond: (id = component1.id)
  • Filter: ((name IS NULL) AND (type = 'd'::bpchar))
15. 1,120.468 1,364.048 ↑ 506.5 24 48,716

Bitmap Heap Scan on rank rank2 (cost=230.73..17,135.66 rows=12,157 width=12) (actual time=0.008..0.028 rows=24 loops=48,716)

  • Recheck Cond: (component_ref = component1.id)
16. 243.580 243.580 ↑ 506.5 24 48,716

Bitmap Index Scan on idx_rank_component_ref (cost=0.00..227.69 rows=12,157 width=0) (actual time=0.005..0.005 rows=24 loops=48,716)

  • Index Cond: (component_ref = component1.id)
17. 2,316.360 2,316.360 ↑ 1.0 1 1,158,180

Index Scan using "UNIQ_rank_pre" on rank rank1 (cost=0.00..8.53 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=1,158,180)

  • Index Cond: (pre = rank2.parent)
18. 2,218.928 2,218.928 ↑ 1.0 1 1,109,464

Index Scan using "PK_node" on node node1 (cost=0.00..0.44 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=1,109,464)

  • Index Cond: (id = rank1.node_ref)
19. 2,218.928 2,218.928 ↓ 0.0 0 1,109,464

Index Scan using "UNIQ_node_annotation" on node_annotation node_annotation1 (cost=0.00..153.87 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=1,109,464)

  • Index Cond: ((node_ref = node1.id) AND ((name)::text = 'cat'::text))
  • Filter: ((value)::text = 'S'::text)
20. 554.402 554.402 ↑ 1.0 1 277,201

Index Scan using "PK_node" on node node2 (cost=0.00..0.44 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=277,201)

  • Index Cond: (id = rank2.node_ref)
21. 554.402 554.402 ↓ 0.0 0 277,201

Index Scan using "UNIQ_node_annotation" on node_annotation node_annotation2 (cost=0.00..153.87 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=277,201)

  • Index Cond: ((node_ref = node2.id) AND ((name)::text = 'pos'::text))
  • Filter: ((value)::text = 'VVFIN'::text)