explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jaE6 : partition_5_monthly

Settings
# exclusive inclusive rows x rows loops node
1. 202.250 3,690.418 ↓ 0.0 100 1

Custom Scan (Citus Adaptive) (cost=0.00..0.00 rows=0 width=0) (actual time=3,690.408..3,690.418 rows=100 loops=1)

  • Output: remote_scan.search_keyword, remote_scan.user_count, remote_scan.session_count, remote_scan.search_count
  • Task Count: 1
  • Tasks Shown: All
  • -> Task
  • Node: host=localhost port=9702 dbname=postgres
2. 0.025 3,488.168 ↑ 1.0 100 1

Limit (cost=20,706.65..20,706.90 rows=100 width=51) (actual time=3,488.130..3,488.168 rows=100 loops=1)

  • Output: a.search_keyword, ((hll_cardinality(hll_union_agg(a.users)))::bigint), ((hll_cardinality(hll_union_agg(a.sessions)))::bigint), (sum(a.total))
  • Buffers: shared hit=7357
3. 111.286 3,488.143 ↑ 2.0 100 1

Sort (cost=20,706.65..20,707.15 rows=200 width=51) (actual time=3,488.128..3,488.143 rows=100 loops=1)

  • Output: a.search_keyword, ((hll_cardinality(hll_union_agg(a.users)))::bigint), ((hll_cardinality(hll_union_agg(a.sessions)))::bigint), (sum(a.total))
  • Sort Key: (sum(a.total)) DESC
  • Sort Method: top-N heapsort Memory: 38kB
  • Buffers: shared hit=7357
4. 3,099.950 3,376.857 ↓ 1,481.4 296,279 1

HashAggregate (cost=20,694.01..20,699.01 rows=200 width=51) (actual time=3,004.046..3,376.857 rows=296,279 loops=1)

  • Output: a.search_keyword, (hll_cardinality(hll_union_agg(a.users)))::bigint, (hll_cardinality(hll_union_agg(a.sessions)))::bigint, sum(a.total)
  • Group Key: a.search_keyword
  • Buffers: shared hit=7357
5. 64.416 276.907 ↑ 1.0 410,213 1

Append (cost=0.00..16,591.88 rows=410,213 width=56) (actual time=0.011..276.907 rows=410,213 loops=1)

  • Buffers: shared hit=7355
6. 14.305 14.305 ↑ 1.0 29,873 1

Seq Scan on partitions.sr_rollup_day_p2018_01_107921 a (cost=0.00..1,058.18 rows=29,873 width=55) (actual time=0.011..14.305 rows=29,873 loops=1)

  • Output: a.search_keyword, a.users, a.sessions, a.total
  • Filter: ((a.created_date >= '2018-01-02'::date) AND (a.created_date <= '2018-12-30'::date) AND (a.tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid))
  • Rows Removed by Filter: 80
  • Buffers: shared hit=534
7. 15.547 15.547 ↑ 1.0 32,548 1

Seq Scan on partitions.sr_rollup_day_p2018_02_107953 a_1 (cost=0.00..1,151.59 rows=32,548 width=55) (actual time=0.011..15.547 rows=32,548 loops=1)

  • Output: a_1.search_keyword, a_1.users, a_1.sessions, a_1.total
  • Filter: ((a_1.created_date >= '2018-01-02'::date) AND (a_1.created_date <= '2018-12-30'::date) AND (a_1.tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid))
  • Buffers: shared hit=582
8. 17.833 17.833 ↑ 1.0 36,947 1

Seq Scan on partitions.sr_rollup_day_p2018_03_107985 a_2 (cost=0.00..1,306.57 rows=36,947 width=55) (actual time=0.012..17.833 rows=36,947 loops=1)

  • Output: a_2.search_keyword, a_2.users, a_2.sessions, a_2.total
  • Filter: ((a_2.created_date >= '2018-01-02'::date) AND (a_2.created_date <= '2018-12-30'::date) AND (a_2.tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid))
  • Buffers: shared hit=660
9. 16.516 16.516 ↑ 1.0 34,579 1

Seq Scan on partitions.sr_rollup_day_p2018_04_108017 a_3 (cost=0.00..1,225.13 rows=34,579 width=56) (actual time=0.013..16.516 rows=34,579 loops=1)

  • Output: a_3.search_keyword, a_3.users, a_3.sessions, a_3.total
  • Filter: ((a_3.created_date >= '2018-01-02'::date) AND (a_3.created_date <= '2018-12-30'::date) AND (a_3.tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid))
  • Buffers: shared hit=620
10. 16.932 16.932 ↑ 1.0 35,951 1

Seq Scan on partitions.sr_rollup_day_p2018_05_108049 a_4 (cost=0.00..1,275.14 rows=35,951 width=56) (actual time=0.013..16.932 rows=35,951 loops=1)

  • Output: a_4.search_keyword, a_4.users, a_4.sessions, a_4.total
  • Filter: ((a_4.created_date >= '2018-01-02'::date) AND (a_4.created_date <= '2018-12-30'::date) AND (a_4.tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid))
  • Buffers: shared hit=646
11. 18.098 18.098 ↑ 1.0 33,299 1

Seq Scan on partitions.sr_rollup_day_p2018_06_108081 a_5 (cost=0.00..1,180.73 rows=33,299 width=56) (actual time=0.013..18.098 rows=33,299 loops=1)

  • Output: a_5.search_keyword, a_5.users, a_5.sessions, a_5.total
  • Filter: ((a_5.created_date >= '2018-01-02'::date) AND (a_5.created_date <= '2018-12-30'::date) AND (a_5.tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid))
  • Buffers: shared hit=598
12. 20.765 20.765 ↑ 1.0 35,237 1

Seq Scan on partitions.sr_rollup_day_p2018_07_108113 a_6 (cost=0.00..1,248.65 rows=35,237 width=56) (actual time=0.015..20.765 rows=35,237 loops=1)

  • Output: a_6.search_keyword, a_6.users, a_6.sessions, a_6.total
  • Filter: ((a_6.created_date >= '2018-01-02'::date) AND (a_6.created_date <= '2018-12-30'::date) AND (a_6.tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid))
  • Buffers: shared hit=632
13. 20.871 20.871 ↑ 1.0 37,226 1

Seq Scan on partitions.sr_rollup_day_p2018_08_108145 a_7 (cost=0.00..1,315.45 rows=37,226 width=55) (actual time=0.013..20.871 rows=37,226 loops=1)

  • Output: a_7.search_keyword, a_7.users, a_7.sessions, a_7.total
  • Filter: ((a_7.created_date >= '2018-01-02'::date) AND (a_7.created_date <= '2018-12-30'::date) AND (a_7.tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid))
  • Buffers: shared hit=664
14. 18.071 18.071 ↑ 1.0 33,394 1

Seq Scan on partitions.sr_rollup_day_p2018_09_108177 a_8 (cost=0.00..1,181.39 rows=33,394 width=55) (actual time=0.011..18.071 rows=33,394 loops=1)

  • Output: a_8.search_keyword, a_8.users, a_8.sessions, a_8.total
  • Filter: ((a_8.created_date >= '2018-01-02'::date) AND (a_8.created_date <= '2018-12-30'::date) AND (a_8.tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid))
  • Buffers: shared hit=597
15. 20.630 20.630 ↑ 1.0 39,234 1

Seq Scan on partitions.sr_rollup_day_p2018_10_108209 a_9 (cost=0.00..1,390.60 rows=39,234 width=56) (actual time=0.011..20.630 rows=39,234 loops=1)

  • Output: a_9.search_keyword, a_9.users, a_9.sessions, a_9.total
  • Filter: ((a_9.created_date >= '2018-01-02'::date) AND (a_9.created_date <= '2018-12-30'::date) AND (a_9.tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid))
  • Buffers: shared hit=704
16. 18.502 18.502 ↑ 1.0 36,037 1

Seq Scan on partitions.sr_rollup_day_p2018_11_108241 a_10 (cost=0.00..1,275.65 rows=36,037 width=55) (actual time=0.012..18.502 rows=36,037 loops=1)

  • Output: a_10.search_keyword, a_10.users, a_10.sessions, a_10.total
  • Filter: ((a_10.created_date >= '2018-01-02'::date) AND (a_10.created_date <= '2018-12-30'::date) AND (a_10.tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid))
  • Buffers: shared hit=645
17. 14.421 14.421 ↑ 1.0 25,888 1

Seq Scan on partitions.sr_rollup_day_p2018_12_108273 a_11 (cost=0.00..931.73 rows=25,888 width=56) (actual time=0.010..14.421 rows=25,888 loops=1)

  • Output: a_11.search_keyword, a_11.users, a_11.sessions, a_11.total
  • Filter: ((a_11.created_date >= '2018-01-02'::date) AND (a_11.created_date <= '2018-12-30'::date) AND (a_11.tenant_id = '11850a62-19ac-477d-9cd7-837f3d716885'::uuid))
  • Rows Removed by Filter: 325
  • Buffers: shared hit=473
Planning time : 0.098 ms
Execution time : 3,690.452 ms