explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nsDN

Settings
# exclusive inclusive rows x rows loops node
1. 505,627.775 505,627.775 ↑ 1.0 18,224,010 1

Seq Scan on dataset.results_test r (cost=0.00..4,343,701.40 rows=18,618,717 width=142) (actual time=18,058.458..505,627.775 rows=18,224,010 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
  • Filter: (r.dataset_id = 'f3877597-9114-4ace-ad6f-e8a68435c0ba'::uuid)
  • Rows Removed by Filter: 81,212,890
  • Buffers: shared read=3,100,907 dirtied=560,432 written=355,635
  • I/O Timings: read=393,649.124 write=8,975.348
Planning time : 1.093 ms