explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KIxh

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 118.761 ↓ 0.0 100 1

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

  • Task Count: 1
  • Tasks Shown: All
  • -> Task
  • Node: host=localhost port=9,701 dbname=postgres
2. 0.008 130.988 ↑ 1.0 100 1

Limit (cost=8,677.79..8,678.04 rows=100 width=37) (actual time=130.975..130.988 rows=100 loops=1)

3. 10.140 130.980 ↑ 260.0 100 1

Sort (cost=8,677.79..8,742.80 rows=26,003 width=37) (actual time=130.974..130.980 rows=100 loops=1)

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

GroupAggregate (cost=6,336.76..7,683.98 rows=26,003 width=37) (actual time=45.256..120.840 rows=40,748 loops=1)

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

Sort (cost=6,336.76..6,476.19 rows=55,771 width=49) (actual time=45.239..49.991 rows=55,771 loops=1)

  • Sort Key: a.search_keyword
  • Sort Method: quicksort Memory: 7,533kB
6. 13.290 13.290 ↑ 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.006..13.290 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 : 118.790 ms