explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SA96

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 149,206.953 ↑ 4.3 116 1

Hash Right Join (cost=38.10..56.80 rows=495 width=81) (actual time=149,206.917..149,206.953 rows=116 loops=1)

  • Hash Cond: (c.manufacturing_entity_id = m.id)
2.          

Initplan (for Hash Right Join)

3. 0.011 11.547 ↑ 1.0 1 1

Aggregate (cost=12.75..12.76 rows=1 width=32) (actual time=11.547..11.547 rows=1 loops=1)

4. 11.536 11.536 ↑ 25.6 39 1

Function Scan on find_manufacturing_entity_childs ms_1 (cost=0.25..10.25 rows=1,000 width=16) (actual time=11.533..11.536 rows=39 loops=1)

5. 149,193.252 149,193.252 ↑ 9.5 105 1

Function Scan on return_signal_condition_v2 c (cost=0.25..10.25 rows=1,000 width=68) (actual time=149,193.247..149,193.252 rows=105 loops=1)

6. 0.011 13.661 ↑ 2.5 39 1

Hash (cost=23.85..23.85 rows=99 width=29) (actual time=13.661..13.661 rows=39 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
7. 0.034 13.650 ↑ 2.5 39 1

Hash Join (cost=17.25..23.85 rows=99 width=29) (actual time=13.609..13.650 rows=39 loops=1)

  • Hash Cond: (m.id = ms.id)
8. 0.034 0.034 ↑ 1.0 198 1

Seq Scan on "ManufacturingEntity" m (cost=0.00..4.98 rows=198 width=29) (actual time=0.020..0.034 rows=198 loops=1)

9. 0.010 13.582 ↑ 5.1 39 1

Hash (cost=14.75..14.75 rows=200 width=16) (actual time=13.582..13.582 rows=39 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
10. 0.018 13.572 ↑ 5.1 39 1

HashAggregate (cost=12.75..14.75 rows=200 width=16) (actual time=13.565..13.572 rows=39 loops=1)

  • Group Key: ms.id
11. 13.554 13.554 ↑ 25.6 39 1

Function Scan on find_manufacturing_entity_childs ms (cost=0.25..10.25 rows=1,000 width=16) (actual time=13.551..13.554 rows=39 loops=1)