explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BlY5

Settings
# exclusive inclusive rows x rows loops node
1. 0.078 0.482 ↑ 1.0 1 1

GroupAggregate (cost=156.07..17,673.54 rows=1 width=36) (actual time=0.479..0.482 rows=1 loops=1)

  • Group Key: wo_i.id
2. 0.033 0.404 ↓ 1.2 6 1

Nested Loop (cost=156.07..17,673.50 rows=5 width=520) (actual time=0.228..0.404 rows=6 loops=1)

3. 0.032 0.317 ↓ 1.2 6 1

Nested Loop (cost=155.78..17,633.63 rows=5 width=8) (actual time=0.195..0.317 rows=6 loops=1)

4. 0.080 0.080 ↑ 1.0 1 1

Index Only Scan using work_orders_pkey on work_orders wo_i (cost=0.29..8.31 rows=1 width=4) (actual time=0.076..0.080 rows=1 loops=1)

  • Index Cond: (id = 32910)
  • Heap Fetches: 1
5. 0.055 0.205 ↓ 1.2 6 1

Nested Loop (cost=155.49..17,625.27 rows=5 width=8) (actual time=0.104..0.205 rows=6 loops=1)

6. 0.042 0.078 ↑ 6.0 6 1

Bitmap Heap Scan on sample_parameters sp (cost=155.07..16,950.93 rows=36 width=12) (actual time=0.060..0.078 rows=6 loops=1)

  • Recheck Cond: (work_order_id = 32910)
  • Filter: ((state)::text = 'validated'::text)
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=4
7. 0.036 0.036 ↑ 303.5 24 1

Bitmap Index Scan on index_sample_parameters_work_order_id (cost=0.00..155.06 rows=7,284 width=0) (actual time=0.034..0.036 rows=24 loops=1)

  • Index Cond: (work_order_id = 32910)
8. 0.072 0.072 ↑ 3.0 1 6

Index Scan using index_analytical_results_sample_parameter_id on analytical_results results (cost=0.42..18.70 rows=3 width=4) (actual time=0.010..0.012 rows=1 loops=6)

  • Index Cond: (sample_parameter_id = sp.id)
  • Filter: (value_id IS NOT NULL)
9. 0.054 0.054 ↑ 1.0 1 6

Index Scan using samples_pkey on samples s (cost=0.29..7.97 rows=1 width=520) (actual time=0.009..0.009 rows=1 loops=6)

  • Index Cond: (id = sp.sample_id)
Planning time : 1.034 ms
Execution time : 0.695 ms