explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vaPN

Settings
# exclusive inclusive rows x rows loops node
1. 0.078 702.759 ↑ 226.0 5 1

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

2. 700.041 700.041 ↑ 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=700.035..700.041 rows=5 loops=1)

3.          

SubPlan (for Subquery Scan)

4. 0.025 2.640 ↑ 1.0 1 5

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

5.          

Initplan (for Result)

6. 0.176 2.615 ↑ 1.0 1 5

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

7. 0.115 0.160 ↑ 1.0 11 5

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

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

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

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

SubPlan (for Aggregate)

10. 0.530 2.279 ↑ 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.043..0.043 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.000 0.212 ↑ 1.0 1 53

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

14.          

Initplan (for Result)

15. 0.106 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.053 0.106 ↓ 0.0 0 53

Sort (cost=8.17..8.18 rows=1 width=314) (actual time=0.002..0.002 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.053 1.537 ↑ 1.0 1 53

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

19.          

Initplan (for Result)

20. 0.258 1.484 ↑ 1.0 1 53

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

21. 0.212 0.530 ↑ 1.0 3 53

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

  • Sort Key: __local_8__.id
  • Sort Method: quicksort Memory: 25kB
22. 0.318 0.318 ↑ 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.006 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.003..0.004 rows=1 loops=174)

  • Index Cond: (value = __local_8__.result)