Skip to content

Instantly share code, notes, and snippets.

@AshishKapoor

AshishKapoor/explain.log

Created September 22, 2022 07:17
Show Gist options
  • Save AshishKapoor/fc076a53de0d201fcad3d8a7b8373994 to your computer and use it in GitHub Desktop.
Save AshishKapoor/fc076a53de0d201fcad3d8a7b8373994 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
explain.log
Limit (cost=4895237.19..4897350.43 rows=10000 width=48) (actual time=16791.597..23517.086 rows=1000 loops=1)
-> Finalize GroupAggregate (cost=4895237.19..5922277.78 rows=4860039 width=48) (actual time=16791.595..23516.865 rows=1000 loops=1)
Group Key: sensor_id, (time_bucket('1 day'::interval, "time"))
-> Gather Merge (cost=4895237.19..5800776.80 rows=4860039 width=48) (actual time=16790.127..23513.261 rows=2000 loops=1)
Workers Planned: 1
Workers Launched: 1
-> Partial GroupAggregate (cost=4894237.18..5253022.41 rows=4860039 width=48) (actual time=16774.942..23280.625 rows=1000 loops=2)
Group Key: sensor_id, (time_bucket('1 day'::interval, "time"))
-> Sort (cost=4894237.18..4965708.34 rows=28588464 width=22) (actual time=16763.580..19623.318 rows=24300250 loops=2)
Sort Key: sensor_id DESC, (time_bucket('1 day'::interval, "time"))
Sort Method: external merge Disk: 772720kB
Worker 0: Sort Method: external merge Disk: 795816kB
-> Parallel Seq Scan on pg_fill_measurements (cost=0.00..666913.80 rows=28588464 width=22) (actual time=0.038..3786.923 rows=24300250 loops=2)
Planning Time: 0.353 ms
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment