explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Z146

Settings
# exclusive inclusive rows x rows loops node
1. 0.309 2,674.672 ↑ 3.3 76 1

Sort (cost=313.24..313.87 rows=250 width=3,029) (actual time=2,674.620..2,674.672 rows=76 loops=1)

  • Sort Key: t01.code
  • Sort Method: quicksort Memory: 80kB
2.          

CTE q

3. 0.078 1,321.199 ↑ 1.0 50 1

Limit (cost=155.42..155.55 rows=50 width=43) (actual time=1,321.089..1,321.199 rows=50 loops=1)

4. 3.481 1,321.121 ↑ 20.0 50 1

Sort (cost=155.42..157.92 rows=1,000 width=43) (actual time=1,321.086..1,321.121 rows=50 loops=1)

  • Sort Key: t01_1.code
  • Sort Method: top-N heapsort Memory: 31kB
5. 4.377 1,317.640 ↓ 2.2 2,195 1

HashAggregate (cost=112.20..122.20 rows=1,000 width=43) (actual time=1,315.835..1,317.640 rows=2,195 loops=1)

  • Group Key: t01_1.code, "IBoardVariableContext_1".id
6. 3.632 1,313.263 ↓ 2.2 2,195 1

Hash Left Join (cost=94.57..107.20 rows=1,000 width=43) (actual time=1,308.063..1,313.263 rows=2,195 loops=1)

  • Hash Cond: ("IBoardVariableContext_1".variable_id = t01_1.id)
7. 1,307.256 1,307.256 ↓ 2.2 2,195 1

Function Scan on iboard_variables_contexts "IBoardVariableContext_1" (cost=0.25..10.25 rows=1,000 width=36) (actual time=1,305.664..1,307.256 rows=2,195 loops=1)

8. 1.188 2.375 ↑ 1.0 1,303 1

Hash (cost=78.03..78.03 rows=1,303 width=15) (actual time=2.373..2.375 rows=1,303 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 78kB
9. 1.187 1.187 ↑ 1.0 1,303 1

Seq Scan on variables t01_1 (cost=0.00..78.03 rows=1,303 width=15) (actual time=0.019..1.187 rows=1,303 loops=1)

10. 0.135 2,674.363 ↑ 3.3 76 1

Hash Left Join (cost=139.07..147.74 rows=250 width=3,029) (actual time=2,673.274..2,674.363 rows=76 loops=1)

  • Hash Cond: ("IBoardVariableContext".entity_unit_id = t09.id)
11. 0.142 2,674.220 ↑ 3.3 76 1

Hash Left Join (cost=126.37..134.37 rows=250 width=2,455) (actual time=2,673.256..2,674.220 rows=76 loops=1)

  • Hash Cond: ("IBoardVariableContext".dimension_id = t08.id)
12. 0.139 2,674.057 ↑ 3.3 76 1

Hash Left Join (cost=125.26..132.59 rows=250 width=1,423) (actual time=2,673.225..2,674.057 rows=76 loops=1)

  • Hash Cond: (t01.family_id = t02.id)
13. 0.136 2,673.757 ↑ 3.3 76 1

Hash Left Join (cost=121.19..127.83 rows=250 width=1,368) (actual time=2,673.056..2,673.757 rows=76 loops=1)

  • Hash Cond: (t01.type_id = t05.id)
14. 0.135 2,673.603 ↑ 3.3 76 1

Hash Left Join (cost=120.15..124.74 rows=250 width=1,118) (actual time=2,673.030..2,673.603 rows=76 loops=1)

  • Hash Cond: (t01.nature_id = t06.id)
15. 0.136 2,673.445 ↑ 3.3 76 1

Hash Left Join (cost=119.03..122.41 rows=250 width=868) (actual time=2,672.999..2,673.445 rows=76 loops=1)

  • Hash Cond: (t01.unit_id = t07.id)
16. 0.169 2,673.257 ↑ 3.3 76 1

Hash Right Join (cost=117.58..120.17 rows=250 width=650) (actual time=2,672.939..2,673.257 rows=76 loops=1)

  • Hash Cond: (t03.variable_id = t01.id)
17. 0.146 0.288 ↑ 1.0 84 1

Hash Left Join (cost=1.36..3.48 rows=84 width=235) (actual time=0.081..0.288 rows=84 loops=1)

  • Hash Cond: (t03.default_value_id = t04.id)
18. 0.098 0.098 ↑ 1.0 84 1

Seq Scan on lnk_variable_default_values t03 (cost=0.00..1.84 rows=84 width=13) (actual time=0.026..0.098 rows=84 loops=1)

19. 0.021 0.044 ↑ 1.0 16 1

Hash (cost=1.16..1.16 rows=16 width=222) (actual time=0.043..0.044 rows=16 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
20. 0.023 0.023 ↑ 1.0 16 1

Seq Scan on default_values t04 (cost=0.00..1.16 rows=16 width=222) (actual time=0.010..0.023 rows=16 loops=1)

21. 0.097 2,672.800 ↑ 5.0 50 1

Hash (cost=113.10..113.10 rows=250 width=415) (actual time=2,672.800..2,672.800 rows=50 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 30kB
22. 0.138 2,672.703 ↑ 5.0 50 1

Hash Left Join (cost=96.19..113.10 rows=250 width=415) (actual time=2,669.080..2,672.703 rows=50 loops=1)

  • Hash Cond: ("IBoardVariableContext".variable_id = t01.id)
23. 1.893 2,669.276 ↑ 5.0 50 1

Hash Join (cost=1.88..18.13 rows=250 width=49) (actual time=2,665.768..2,669.276 rows=50 loops=1)

  • Hash Cond: ("IBoardVariableContext".id = q."Id")
24. 1,346.059 1,346.059 ↓ 2.2 2,195 1

Function Scan on iboard_variables_contexts "IBoardVariableContext" (cost=0.25..10.25 rows=1,000 width=49) (actual time=1,344.358..1,346.059 rows=2,195 loops=1)

25. 0.048 1,321.324 ↑ 1.0 50 1

Hash (cost=1.00..1.00 rows=50 width=32) (actual time=1,321.323..1,321.324 rows=50 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
26. 1,321.276 1,321.276 ↑ 1.0 50 1

CTE Scan on q (cost=0.00..1.00 rows=50 width=32) (actual time=1,321.094..1,321.276 rows=50 loops=1)

27. 1.814 3.289 ↑ 1.0 1,303 1

Hash (cost=78.03..78.03 rows=1,303 width=366) (actual time=3.288..3.289 rows=1,303 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 517kB
28. 1.475 1.475 ↑ 1.0 1,303 1

Seq Scan on variables t01 (cost=0.00..78.03 rows=1,303 width=366) (actual time=0.024..1.475 rows=1,303 loops=1)

29. 0.022 0.052 ↓ 1.1 23 1

Hash (cost=1.20..1.20 rows=20 width=222) (actual time=0.051..0.052 rows=23 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
30. 0.030 0.030 ↓ 1.1 23 1

Seq Scan on units t07 (cost=0.00..1.20 rows=20 width=222) (actual time=0.011..0.030 rows=23 loops=1)

31. 0.009 0.023 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=254) (actual time=0.022..0.023 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
32. 0.014 0.014 ↑ 1.0 5 1

Seq Scan on natures t06 (cost=0.00..1.05 rows=5 width=254) (actual time=0.009..0.014 rows=5 loops=1)

33. 0.006 0.018 ↑ 1.0 2 1

Hash (cost=1.02..1.02 rows=2 width=254) (actual time=0.017..0.018 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
34. 0.012 0.012 ↑ 1.0 2 1

Seq Scan on variable_types t05 (cost=0.00..1.02 rows=2 width=254) (actual time=0.010..0.012 rows=2 loops=1)

35. 0.080 0.161 ↑ 1.0 92 1

Hash (cost=2.92..2.92 rows=92 width=59) (actual time=0.160..0.161 rows=92 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
36. 0.081 0.081 ↑ 1.0 92 1

Seq Scan on families t02 (cost=0.00..2.92 rows=92 width=59) (actual time=0.011..0.081 rows=92 loops=1)

37. 0.008 0.021 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=1,036) (actual time=0.021..0.021 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
38. 0.013 0.013 ↑ 1.0 5 1

Seq Scan on dimensions t08 (cost=0.00..1.05 rows=5 width=1,036) (actual time=0.009..0.013 rows=5 loops=1)

39. 0.001 0.008 ↓ 0.0 0 1

Hash (cost=11.20..11.20 rows=120 width=578) (actual time=0.008..0.008 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
40. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on entity_units t09 (cost=0.00..11.20 rows=120 width=578) (actual time=0.006..0.007 rows=0 loops=1)