explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xUSU : Insert

Settings
# exclusive inclusive rows x rows loops node
1. 121,537.202 339,115.519 ↓ 0.0 0 1

Insert on dataset.results_test (cost=0.00..1,946,459.10 rows=17,750,864 width=296) (actual time=339,115.517..339,115.519 rows=0 loops=1)

  • Buffers: shared hit=92,401,308 read=1,386,999 dirtied=1,196,428 written=1,659,096
  • I/O Timings: read=144,449.519 write=12,776.355
2. 217,578.317 217,578.317 ↓ 1.0 18,224,010 1

Seq Scan on dataset.results_test rt (cost=0.00..1,946,459.10 rows=17,750,864 width=296) (actual time=8,382.806..217,578.317 rows=18,224,010 loops=1)

  • Output: rt.key, rt.ukey, '9055a3c6-08b5-4e69-8c01-64273cea9e81'::uuid, rt.monitoring_location_ukey, rt.parameter_ukey, rt.activity_ukey, rt.analytical_method_ukey, rt.detection_quantitation_limit_ukey, rt.measure, rt.value_type, rt.detection_condition, rt.status_id, rt.comment, rt.analysis_start_date, rt.analysis_start_time, rt.analysis_start_time_zone, rt.laboratory, rt.laboratory_sample_id, rt.measure_normalized, rt.guidelines, rt.embargo, rt.create_timestamp, rt.update_timestamp
  • Filter: (rt.dataset_id = 'f3877597-9114-4ace-ad6f-e8a68435c0ba'::uuid)
  • Rows Removed by Filter: 26,540,860
  • Buffers: shared read=1,386,848 dirtied=558,778 written=501,200
  • I/O Timings: read=144,446.396 write=6,461.636
Planning time : 1.419 ms