explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Caon

Settings
# exclusive inclusive rows x rows loops node
1. 0.105 686.051 ↑ 226.0 5 1

Subquery Scan on __local_0__ (cost=0.15..636,864.50 rows=1,130 width=96) (actual time=683.958..686.051 rows=5 loops=1)

  • JIT:
  • Functions: 54
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 7.185 ms, Inlining 118.467 ms, Optimization 354.151 ms, Emission 209.100 ms, Total 688.902 ms
2. 682.851 682.851 ↑ 226.0 5 1

Index Scan using panels_pkey on panels __local_0___1 (cost=0.15..65.10 rows=1,130 width=44) (actual time=682.845..682.851 rows=5 loops=1)

3.          

SubPlan (for Subquery Scan)

4. 0.040 3.095 ↑ 1.0 1 5

Result (cost=563.51..563.52 rows=1 width=32) (actual time=0.619..0.619 rows=1 loops=5)

5.          

Initplan (for Result)

6. 0.153 3.055 ↑ 1.0 1 5

Aggregate (cost=563.50..563.51 rows=1 width=32) (actual time=0.611..0.611 rows=1 loops=5)

7. 0.155 0.305 ↑ 1.0 11 5

Sort (cost=1.85..1.88 rows=11 width=12) (actual time=0.059..0.061 rows=11 loops=5)

  • Sort Key: __local_9__.id
  • Sort Method: quicksort Memory: 25kB
8. 0.150 0.150 ↑ 1.0 11 5

Seq Scan on panels_tests __local_9__ (cost=0.00..1.66 rows=11 width=12) (actual time=0.028..0.030 rows=11 loops=5)

  • Filter: (panel_id = __local_0__.id)
  • Rows Removed by Filter: 42
9.          

SubPlan (for Aggregate)

10. 0.530 2.597 ↑ 1.0 1 53

Index Scan using tests_pkey on tests __local_2__ (cost=0.14..51.04 rows=1 width=32) (actual time=0.048..0.049 rows=1 loops=53)

  • Index Cond: (id = __local_9__.test_id)
11.          

SubPlan (for Index Scan)

12. 0.000 0.000 ↓ 0.0 0 53

Index Scan using labs_pkey on labs __local_3__ (cost=0.14..8.16 rows=1 width=32) (actual time=0.000..0.000 rows=0 loops=53)

  • Index Cond: (id = __local_2__.reference_lab_id)
13. 0.053 0.265 ↑ 1.0 1 53

Result (cost=8.21..8.21 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=53)

14.          

Initplan (for Result)

15. 0.053 0.212 ↑ 1.0 1 53

Aggregate (cost=8.20..8.21 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=53)

16. 0.106 0.159 ↓ 0.0 0 53

Sort (cost=8.17..8.18 rows=1 width=314) (actual time=0.003..0.003 rows=0 loops=53)

  • Sort Key: __local_5__.id
  • Sort Method: quicksort Memory: 25kB
17. 0.053 0.053 ↓ 0.0 0 53

Index Scan using tests_parent_id_idx on tests __local_5__ (cost=0.14..8.16 rows=1 width=314) (actual time=0.001..0.001 rows=0 loops=53)

  • Index Cond: (parent_id = __local_2__.id)
18. 0.106 1.802 ↑ 1.0 1 53

Result (cost=26.49..26.50 rows=1 width=32) (actual time=0.034..0.034 rows=1 loops=53)

19.          

Initplan (for Result)

20. 0.364 1.696 ↑ 1.0 1 53

Aggregate (cost=26.48..26.49 rows=1 width=32) (actual time=0.032..0.032 rows=1 loops=53)

21. 0.265 0.636 ↑ 1.0 3 53

Sort (cost=1.91..1.92 rows=3 width=11) (actual time=0.011..0.012 rows=3 loops=53)

  • Sort Key: __local_8__.id
  • Sort Method: quicksort Memory: 25kB
22. 0.371 0.371 ↑ 1.0 3 53

Seq Scan on tests_test_results __local_8__ (cost=0.00..1.89 rows=3 width=11) (actual time=0.004..0.007 rows=3 loops=53)

  • Filter: (test_id = __local_2__.id)
  • Rows Removed by Filter: 68
23.          

SubPlan (for Aggregate)

24. 0.696 0.696 ↑ 1.0 1 174

Index Scan using test_results_pkey on test_results __local_7__ (cost=0.15..8.17 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=174)

  • Index Cond: (value = __local_8__.result)