explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5YlB : Optimization for: plan #SBr

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.003 21.143 ↑ 1.0 10 1

Limit (cost=8,926.51..8,926.54 rows=10 width=44) (actual time=21.141..21.143 rows=10 loops=1)

2. 0.011 21.140 ↑ 8.2 10 1

Sort (cost=8,926.51..8,926.72 rows=82 width=44) (actual time=21.139..21.140 rows=10 loops=1)

  • Sort Key: assays.created_time
  • Sort Method: top-N heapsort Memory: 25kB
3. 0.010 21.129 ↑ 1.0 81 1

Append (cost=289.17..8,924.74 rows=82 width=44) (actual time=1.355..21.129 rows=81 loops=1)

4. 0.001 1.356 ↑ 1.0 10 1

Limit (cost=289.17..289.19 rows=10 width=12) (actual time=1.355..1.356 rows=10 loops=1)

5. 0.067 1.355 ↑ 57.8 10 1

Sort (cost=289.17..290.61 rows=578 width=12) (actual time=1.354..1.355 rows=10 loops=1)

  • Sort Key: assays.created_time
  • Sort Method: top-N heapsort Memory: 25kB
6. 1.288 1.288 ↑ 1.0 578 1

Seq Scan on assays (cost=0.00..276.68 rows=578 width=12) (actual time=0.456..1.288 rows=578 loops=1)

  • Filter: ((owner)::text = 'gesa.volkers'::text)
  • Rows Removed by Filter: 8,756
7. 0.001 0.021 ↓ 0.0 0 1

Limit (cost=3.51..3.51 rows=1 width=12) (actual time=0.021..0.021 rows=0 loops=1)

8. 0.006 0.020 ↓ 0.0 0 1

Sort (cost=3.51..3.51 rows=1 width=12) (actual time=0.020..0.020 rows=0 loops=1)

  • Sort Key: clone_locations.created_time
  • Sort Method: quicksort Memory: 25kB
9. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on clone_locations (cost=0.00..3.50 rows=1 width=12) (actual time=0.014..0.014 rows=0 loops=1)

  • Filter: ((owner)::text = 'gesa.volkers'::text)
  • Rows Removed by Filter: 120
10. 0.001 0.101 ↑ 1.0 10 1

Limit (cost=20.37..20.39 rows=10 width=12) (actual time=0.099..0.101 rows=10 loops=1)

11. 0.009 0.100 ↑ 3.6 10 1

Sort (cost=20.37..20.46 rows=36 width=12) (actual time=0.099..0.100 rows=10 loops=1)

  • Sort Key: clone_orders.created_time
  • Sort Method: top-N heapsort Memory: 25kB
12. 0.091 0.091 ↑ 1.0 36 1

Seq Scan on clone_orders (cost=0.00..19.59 rows=36 width=12) (actual time=0.013..0.091 rows=36 loops=1)

  • Filter: ((owner)::text = 'gesa.volkers'::text)
  • Rows Removed by Filter: 571
13. 0.002 5.540 ↑ 1.0 10 1

Limit (cost=3,629.24..3,629.27 rows=10 width=12) (actual time=5.538..5.540 rows=10 loops=1)

14. 0.008 5.538 ↑ 2.7 10 1

Sort (cost=3,629.24..3,629.31 rows=27 width=12) (actual time=5.537..5.538 rows=10 loops=1)

  • Sort Key: (max(clones.created_time))
  • Sort Method: top-N heapsort Memory: 25kB
15. 0.180 5.530 ↓ 1.3 35 1

HashAggregate (cost=3,628.39..3,628.66 rows=27 width=12) (actual time=5.524..5.530 rows=35 loops=1)

  • Group Key: clones.clone_order_id
16. 5.350 5.350 ↑ 1.0 678 1

Seq Scan on clones (cost=0.00..3,625.00 rows=678 width=12) (actual time=0.012..5.350 rows=678 loops=1)

  • Filter: ((owner)::text = 'gesa.volkers'::text)
  • Rows Removed by Filter: 13,882
17. 0.000 3.776 ↑ 1.0 10 1

Limit (cost=1,286.82..1,286.85 rows=10 width=12) (actual time=3.775..3.776 rows=10 loops=1)

18. 0.035 3.776 ↑ 25.5 10 1

Sort (cost=1,286.82..1,287.46 rows=255 width=12) (actual time=3.775..3.776 rows=10 loops=1)

  • Sort Key: documents.created_time
  • Sort Method: top-N heapsort Memory: 25kB
19. 3.741 3.741 ↑ 1.0 255 1

Seq Scan on documents (cost=0.00..1,281.31 rows=255 width=12) (actual time=0.072..3.741 rows=255 loops=1)

  • Filter: ((owner)::text = 'gesa.volkers'::text)
  • Rows Removed by Filter: 24,330
20. 0.001 0.096 ↑ 1.0 10 1

Limit (cost=13.49..13.52 rows=10 width=12) (actual time=0.095..0.096 rows=10 loops=1)

21. 0.011 0.095 ↑ 1.3 10 1

Sort (cost=13.49..13.52 rows=13 width=12) (actual time=0.095..0.095 rows=10 loops=1)

  • Sort Key: phases.created_time
  • Sort Method: quicksort Memory: 26kB
22. 0.084 0.084 ↑ 1.0 13 1

Seq Scan on phases (cost=0.00..13.25 rows=13 width=12) (actual time=0.046..0.084 rows=13 loops=1)

  • Filter: ((owner)::text = 'gesa.volkers'::text)
  • Rows Removed by Filter: 487
23. 0.000 0.017 ↑ 1.0 1 1

Limit (cost=3.97..3.98 rows=1 width=12) (actual time=0.017..0.017 rows=1 loops=1)

24. 0.002 0.017 ↑ 1.0 1 1

Sort (cost=3.97..3.98 rows=1 width=12) (actual time=0.017..0.017 rows=1 loops=1)

  • Sort Key: projects.created_time
  • Sort Method: quicksort Memory: 25kB
25. 0.015 0.015 ↑ 1.0 1 1

Seq Scan on projects (cost=0.00..3.96 rows=1 width=12) (actual time=0.014..0.015 rows=1 loops=1)

  • Filter: ((owner)::text = 'gesa.volkers'::text)
  • Rows Removed by Filter: 76
26. 0.005 6.848 ↑ 1.0 10 1

Limit (cost=2,330.19..2,330.21 rows=10 width=12) (actual time=6.845..6.848 rows=10 loops=1)

27. 0.021 6.843 ↑ 16.2 10 1

Sort (cost=2,330.19..2,330.59 rows=162 width=12) (actual time=6.843..6.843 rows=10 loops=1)

  • Sort Key: (max(samples.created_time))
  • Sort Method: top-N heapsort Memory: 25kB
28. 0.622 6.822 ↑ 1.2 130 1

HashAggregate (cost=2,325.07..2,326.69 rows=162 width=12) (actual time=6.808..6.822 rows=130 loops=1)

  • Group Key: samples.work_order_id
29. 6.200 6.200 ↓ 1.0 4,602 1

Seq Scan on samples (cost=0.00..2,302.09 rows=4,596 width=12) (actual time=0.038..6.200 rows=4,602 loops=1)

  • Filter: ((owner)::text = 'gesa.volkers'::text)
  • Rows Removed by Filter: 49,965
30. 0.001 2.992 ↑ 1.0 10 1

Limit (cost=1,226.51..1,226.53 rows=10 width=12) (actual time=2.991..2.992 rows=10 loops=1)

31. 0.105 2.991 ↑ 90.9 10 1

Sort (cost=1,226.51..1,228.78 rows=909 width=12) (actual time=2.990..2.991 rows=10 loops=1)

  • Sort Key: variants.created_time
  • Sort Method: top-N heapsort Memory: 25kB
32. 2.886 2.886 ↑ 1.0 909 1

Seq Scan on variants (cost=0.00..1,206.86 rows=909 width=12) (actual time=0.013..2.886 rows=909 loops=1)

  • Filter: ((owner)::text = 'gesa.volkers'::text)
  • Rows Removed by Filter: 17,720
33. 0.000 0.372 ↑ 1.0 10 1

Limit (cost=120.45..120.47 rows=10 width=12) (actual time=0.371..0.372 rows=10 loops=1)

34. 0.031 0.372 ↑ 17.1 10 1

Sort (cost=120.45..120.87 rows=171 width=12) (actual time=0.371..0.372 rows=10 loops=1)

  • Sort Key: work_orders.created_time
  • Sort Method: top-N heapsort Memory: 25kB
35. 0.341 0.341 ↑ 1.0 171 1

Seq Scan on work_orders (cost=0.00..116.75 rows=171 width=12) (actual time=0.055..0.341 rows=171 loops=1)

  • Filter: ((owner)::text = 'gesa.volkers'::text)
  • Rows Removed by Filter: 2,609