explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TTD5

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 848.248 ↑ 1.5 6,327 1

Gather Merge (cost=506,700.88..507,773.36 rows=9,192 width=64) (actual time=841.861..848.248 rows=6,327 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 7.128 2,520.987 ↑ 2.2 2,109 3

Sort (cost=505,700.86..505,712.35 rows=4,596 width=64) (actual time=839.552..840.329 rows=2,109 loops=3)

  • Sort Key: "Id
  • Sort Method: quicksort Memory: 268kB
3. 2,513.859 2,513.859 ↑ 2.2 2,109 3

Parallel Seq Scan on "Tasks" (cost=0.00..505,421.28 rows=4,596 width=64) (actual time=0.025..837.953 rows=2,109 loops=3)

  • Filter: (date(("CreationTime" + '02:00:00'::interval hour)) = '2019-06-24'::date)
  • Rows Removed by Filter: 733280
Planning time : 0.124 ms