explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XSx1 : using the index when retrieving 6 mil records from 136 mil total

Settings
# exclusive inclusive rows x rows loops node
1. 17,585.849 17,585.849 ↓ 1.0 6,265,396 1

Index Scan using results_test_dataset_id_idx on dataset.results_test r (cost=0.57..3,017,667.72 rows=5,983,333 width=142) (actual time=0.024..17,585.849 rows=6,265,396 loops=1)

  • Output: dataset_id, key, detection_condition, measure_normalized, guidelines, create_timestamp, update_timestamp, activity_ukey, analytical_method_ukey, parameter_ukey, detection_quantitation_limit_ukey, monitoring_location_ukey
  • Index Cond: (r.dataset_id = 'cf1547d6-497b-4d58-903e-b440326ffef0'::uuid)
  • Buffers: shared hit=5,469 read=208,720
  • I/O Timings: read=14,194.549
Planning time : 0.549 ms