explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kUA

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 0.451 ↑ 96.7 3 1

Sort (cost=491.79..491.93 rows=290 width=1,676) (actual time=0.451..0.451 rows=3 loops=1)

  • Sort Key: ids.sort_order__c
  • Sort Method: quicksort Memory: 25kB
2.          

CTE ids

3. 0.010 0.431 ↑ 97.0 3 1

Recursive Union (cost=1.26..487.52 rows=291 width=219) (actual time=0.092..0.431 rows=3 loops=1)

4. 0.004 0.095 ↓ 2.0 2 1

Nested Loop (cost=1.26..6.15 rows=1 width=219) (actual time=0.088..0.095 rows=2 loops=1)

5. 0.006 0.080 ↑ 1.0 1 1

Nested Loop (cost=1.23..5.84 rows=1 width=74) (actual time=0.075..0.080 rows=1 loops=1)

6. 0.019 0.054 ↑ 1.0 1 1

Hash Join (cost=1.18..3.40 rows=1 width=61) (actual time=0.049..0.054 rows=1 loops=1)

7. 0.017 0.017 ↑ 1.0 37 1

Seq Scan on cpq_plan_product_code__c ppc (cost=0.00..2.20 rows=37 width=63) (actual time=0.006..0.017 rows=37 loops=1)

  • Filter: ((ppc.version__c)::text = '1.0.0'::text)
8. 0.010 0.018 ↑ 1.0 1 1

Hash (cost=1.18..1.18 rows=1 width=36) (actual time=0.018..0.018 rows=1 loops=1)

9. 0.008 0.008 ↑ 1.0 1 1

Seq Scan on cpq_product_code__c pc (cost=0.00..1.18 rows=1 width=36) (actual time=0.003..0.008 rows=1 loops=1)

  • Filter: ((pc.name)::text = 'IP-DIA'::text)
10. 0.020 0.020 ↑ 1.0 1 1

Index Scan using hcu_idx_cpq_plan__c_sfid on cpq_plan__c plan (cost=0.06..2.44 rows=1 width=32) (actual time=0.020..0.020 rows=1 loops=1)

  • Index Cond: ((plan.sfid)::text = (ppc.cpq_plan__c)::text)
11. 0.011 0.011 ↓ 2.0 2 1

Index Scan using hc_idx_cpq_plan_component__c_cpq_plan_product_code__c on cpq_plan_component__c pcomp (cost=0.03..0.30 rows=1 width=145) (actual time=0.010..0.011 rows=2 loops=1)

  • Index Cond: ((pcomp.cpq_plan_product_code__c)::text = (ppc.sfid)::text)
12. 0.010 0.326 ↓ 0.0 0 2

Hash Join (cost=16.73..47.96 rows=29 width=219) (actual time=0.162..0.163 rows=0 loops=2)

13. 0.080 0.292 ↓ 0.0 0 2

Merge Join (cost=15.40..46.62 rows=29 width=221) (actual time=0.145..0.146 rows=0 loops=2)

14. 0.070 0.070 ↑ 47.0 52 2

Index Scan using hcu_idx_cpq_plan__c_sfid on cpq_plan__c plan_1 (cost=0.06..163.60 rows=2,442 width=32) (actual time=0.007..0.035 rows=52 loops=2)

15. 0.014 0.142 ↓ 0.0 0 2

Sort (cost=8.53..8.54 rows=29 width=208) (actual time=0.070..0.071 rows=0 loops=2)

  • Sort Key: ppc_1.cpq_plan__c
  • Sort Method: quicksort Memory: 25kB
16. 0.013 0.128 ↓ 0.0 0 2

Hash Join (cost=4.93..8.39 rows=29 width=208) (actual time=0.059..0.064 rows=0 loops=2)

17. 0.027 0.088 ↓ 0.0 0 2

Hash Join (cost=2.56..6.00 rows=32 width=164) (actual time=0.039..0.044 rows=0 loops=2)

18. 0.009 0.009 ↑ 1.0 81 1

Seq Scan on cpq_plan_component__c pcomp_1 (cost=0.00..3.24 rows=81 width=145) (actual time=0.002..0.009 rows=81 loops=1)

19. 0.004 0.052 ↓ 0.0 0 2

Hash (cost=2.45..2.45 rows=32 width=38) (actual time=0.026..0.026 rows=0 loops=2)

20. 0.028 0.048 ↓ 0.0 0 2

Hash Join (cost=0.10..2.45 rows=32 width=38) (actual time=0.018..0.024 rows=0 loops=2)

21. 0.014 0.014 ↑ 1.0 68 2

Seq Scan on cpq_plan_component_relationship__c compr (cost=0.00..2.20 rows=68 width=38) (actual time=0.002..0.007 rows=68 loops=2)

22. 0.004 0.006 ↑ 5.0 2 2

Hash (cost=0.06..0.06 rows=10 width=54) (actual time=0.003..0.003 rows=2 loops=2)

23. 0.002 0.002 ↑ 5.0 2 2

WorkTable Scan (cost=0.00..0.06 rows=10 width=54) (actual time=0.001..0.001 rows=2 loops=2)

24. 0.014 0.027 ↑ 1.0 57 1

Hash (cost=2.17..2.17 rows=57 width=63) (actual time=0.027..0.027 rows=57 loops=1)

25. 0.013 0.013 ↑ 1.0 57 1

Seq Scan on cpq_plan_product_code__c ppc_1 (cost=0.00..2.17 rows=57 width=63) (actual time=0.002..0.013 rows=57 loops=1)

26. 0.014 0.024 ↑ 1.0 50 1

Hash (cost=1.15..1.15 rows=50 width=36) (actual time=0.024..0.024 rows=50 loops=1)

27. 0.010 0.010 ↑ 1.0 50 1

Seq Scan on cpq_product_code__c pc_1 (cost=0.00..1.15 rows=50 width=36) (actual time=0.002..0.010 rows=50 loops=1)

28. 0.437 0.437 ↑ 96.7 3 1

CTE Scan on ids ids (cost=0.00..1.89 rows=290 width=1,676) (actual time=0.095..0.437 rows=3 loops=1)

  • Filter: (ids.cpq_plan_product_code__c IS NOT NULL)