explain.depesz.com

PostgreSQL's explain analyze made readable

Result: whpf

Settings
# exclusive inclusive rows x rows loops node
1. 15.757 423.968 ↓ 0.0 100 1

Custom Scan (Citus Adaptive) (cost=0.00..0.00 rows=0 width=0) (actual time=423.962..423.968 rows=100 loops=1)

  • Task Count: 1
  • Tasks Shown: All
  • -> Task
  • Node: host=localhost port=9701 dbname=postgres
2. 0.011 408.211 ↑ 1.0 100 1

Limit (cost=2,510.35..2,510.60 rows=100 width=37) (actual time=408.194..408.211 rows=100 loops=1)

3. 9.683 408.200 ↑ 2.0 100 1

Sort (cost=2,510.35..2,510.85 rows=200 width=37) (actual time=408.193..408.200 rows=100 loops=1)

  • Sort Key: (sum(a.total)) DESC
  • Sort Method: top-N heapsort Memory: 35kB
4. 377.340 398.517 ↓ 203.7 40,748 1

HashAggregate (cost=2,497.70..2,502.70 rows=200 width=37) (actual time=361.083..398.517 rows=40,748 loops=1)

  • Group Key: a.search_keyword
5. 21.177 21.177 ↑ 1.0 55,771 1

Seq Scan on sr_searches_with_no_clicks_rollup_day_p2020q1_138043 a (cost=0.00..1,939.99 rows=55,771 width=49) (actual time=0.008..21.177 rows=55,771 loops=1)

  • Filter: ((created_date >= '2020-01-01'::date) AND (created_date <= '2020-03-31'::date) AND (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid))
Planning time : 0.083 ms
Execution time : 423.997 ms