explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N4Ve

Settings
# exclusive inclusive rows x rows loops node
1. 65.946 736.045 ↓ 0.0 100 1

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

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

Limit (cost=5,004.28..5,004.53 rows=100 width=37) (actual time=670.082..670.099 rows=100 loops=1)

3. 15.352 670.089 ↑ 2.0 100 1

Sort (cost=5,004.28..5,004.78 rows=200 width=37) (actual time=670.081..670.089 rows=100 loops=1)

  • Sort Key: (sum(a.total)) DESC
  • Sort Method: top-N heapsort Memory: 34kB
4. 609.228 654.737 ↓ 347.1 69,430 1

HashAggregate (cost=4,991.64..4,996.64 rows=200 width=37) (actual time=592.390..654.737 rows=69,430 loops=1)

  • Group Key: a.search_keyword
5. 10.220 45.509 ↑ 1.0 100,235 1

Append (cost=0.00..3,989.29 rows=100,235 width=49) (actual time=0.008..45.509 rows=100,235 loops=1)

6. 19.711 19.711 ↑ 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..19.711 rows=55,771 loops=1)

  • Filter: ((created_date >= '2020-01-01'::date) AND (created_date <= '2020-05-31'::date) AND (tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid))
7. 15.578 15.578 ↑ 1.0 44,464 1

Seq Scan on sr_searches_with_no_clicks_rollup_day_p2020q2_138075 a_1 (cost=0.00..1,548.12 rows=44,464 width=49) (actual time=0.011..15.578 rows=44,464 loops=1)

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