explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1iVZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.085 ↑ 1.0 1 1

Subquery Scan on q (cost=10.89..10.95 rows=1 width=60) (actual time=0.085..0.085 rows=1 loops=1)

2. 0.004 0.083 ↑ 1.0 1 1

GroupAggregate (cost=10.89..10.91 rows=1 width=32) (actual time=0.083..0.083 rows=1 loops=1)

  • Group Key: ar.id, ap.id
3. 0.009 0.079 ↑ 1.0 1 1

Sort (cost=10.89..10.89 rows=1 width=24) (actual time=0.079..0.079 rows=1 loops=1)

  • Sort Key: ap.id
  • Sort Method: quicksort Memory: 25kB
4. 0.000 0.070 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.96..10.88 rows=1 width=24) (actual time=0.069..0.070 rows=1 loops=1)

  • Join Filter: (arv.result_id = ar.id)
5. 0.002 0.060 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.54..8.23 rows=1 width=20) (actual time=0.059..0.060 rows=1 loops=1)

  • Join Filter: (ar.id = arr.result_id)
6. 0.001 0.048 ↑ 1.0 1 1

Nested Loop (cost=1.12..5.58 rows=1 width=16) (actual time=0.047..0.048 rows=1 loops=1)

7. 0.013 0.039 ↑ 1.0 1 1

Nested Loop (cost=0.84..5.28 rows=1 width=12) (actual time=0.038..0.039 rows=1 loops=1)

8. 0.017 0.017 ↑ 1.0 1 1

Index Scan using analytical_results_pkey on analytical_results ar (cost=0.42..2.64 rows=1 width=12) (actual time=0.016..0.017 rows=1 loops=1)

  • Index Cond: (id = 433,566)
9. 0.009 0.009 ↑ 1.0 1 1

Index Scan using sample_parameters_pkey on sample_parameters sp (cost=0.42..2.64 rows=1 width=8) (actual time=0.008..0.009 rows=1 loops=1)

  • Index Cond: (id = ar.sample_parameter_id)
10. 0.008 0.008 ↑ 1.0 1 1

Index Scan using analytical_parameters_pkey on analytical_parameters ap (cost=0.28..0.30 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: (id = sp.parameter_id)
11. 0.010 0.010 ↑ 1.0 1 1

Index Scan using index_analytical_result_reviews_result_id on analytical_result_reviews arr (cost=0.42..2.64 rows=1 width=8) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: (result_id = 433,566)
12. 0.011 0.011 ↓ 0.0 0 1

Index Scan using index_analytical_result_validations_result_id on analytical_result_validations arv (cost=0.42..2.64 rows=1 width=8) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (result_id = 433,566)