explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9hkk

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.032 ↑ 1.0 1 1

Limit (cost=2.52..2.52 rows=1 width=12) (actual time=0.032..0.032 rows=1 loops=1)

2. 0.012 0.031 ↑ 1.0 1 1

Sort (cost=2.52..2.52 rows=1 width=12) (actual time=0.031..0.031 rows=1 loops=1)

  • Sort Key: lab_matrix_id, functional_structure_id, response_time_days
  • Sort Method: quicksort Memory: 25kB
3. 0.019 0.019 ↑ 1.0 1 1

Index Scan using index_technical_params_on_method_param_matrix_and_fstruct_ids on technical_parameters (cost=0.29..2.51 rows=1 width=12) (actual time=0.018..0.019 rows=1 loops=1)

  • Index Cond: ((analytical_method_id = 290) AND (analytical_parameter_id = 2,569))
  • Filter: (((lab_matrix_id = 28) OR (lab_matrix_id IS NULL)) AND ((functional_structure_id = 43) OR (functional_structure_id IS NULL)))