explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fcM

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 184.355 ↓ 0.0 1 1

Aggregate (cost=0.00..0.00 rows=0 width=0) (actual time=184.355..184.355 rows=1 loops=1)

  • Output: (pg_catalog.sum(remote_scan." "))::bigint
2. 184.225 184.340 ↓ 0.0 64 1

Custom Scan (Citus Adaptive) (cost=0.00..0.00 rows=0 width=0) (actual time=184.332..184.340 rows=64 loops=1)

  • Output: remote_scan."
  • Task Count: 64
  • Tasks Shown: One of 64
  • -> Task
  • Node: host=10.0.0.130 port=5432 dbname=citus
3. 0.002 0.115 ↑ 1.0 1 1

Aggregate (cost=554.84..554.85 rows=1 width=8) (actual time=0.115..0.115 rows=1 loops=1)

  • Output: sum(fact_publishers_v4.views)
  • Buffers: shared hit=45
4. 0.000 0.113 ↓ 0.0 0 1

Append (cost=0.42..554.80 rows=15 width=4) (actual time=0.113..0.113 rows=0 loops=1)

  • Buffers: shared hit=45
5. 0.010 0.010 ↓ 0.0 0 1

Index Scan using fact_publishers_64_v4_2020_02_01_siteid_idx_264474 on public.fact_publishers_64_v4_2020_02_01_264474 fact_publishers_v4 (cost=0.42..39.17 rows=1 width=4) (actual time=0.010..0.010 rows=0 loops=1)

  • Output: fact_publishers_v4.views
  • Index Cond: (fact_publishers_v4.siteid = 165850)
  • Filter: ((fact_publishers_v4.country = 'United States'::text) AND (fact_publishers_v4.state = 'California'::text) AND (fact_publishers_v4.adsizeid = 16) AND (fact_publishers_v4.osid = 30) AND (fact_publishers_v4.browserid = 10))
  • Buffers: shared hit=3
6. 0.006 0.006 ↓ 0.0 0 1

Index Scan using fact_publishers_64_v4_2020_02_02_siteid_idx_264538 on public.fact_publishers_64_v4_2020_02_02_264538 fact_publishers_v4_1 (cost=0.42..72.33 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)

  • Output: fact_publishers_v4_1.views
  • Index Cond: (fact_publishers_v4_1.siteid = 165850)
  • Filter: ((fact_publishers_v4_1.country = 'United States'::text) AND (fact_publishers_v4_1.state = 'California'::text) AND (fact_publishers_v4_1.adsizeid = 16) AND (fact_publishers_v4_1.osid = 30) AND (fact_publishers_v4_1.browserid = 10))
  • Buffers: shared hit=3
7. 0.007 0.007 ↓ 0.0 0 1

Index Scan using fact_publishers_64_v4_2020_02_03_siteid_idx_264602 on public.fact_publishers_64_v4_2020_02_03_264602 fact_publishers_v4_2 (cost=0.42..38.89 rows=1 width=4) (actual time=0.007..0.007 rows=0 loops=1)

  • Output: fact_publishers_v4_2.views
  • Index Cond: (fact_publishers_v4_2.siteid = 165850)
  • Filter: ((fact_publishers_v4_2.country = 'United States'::text) AND (fact_publishers_v4_2.state = 'California'::text) AND (fact_publishers_v4_2.adsizeid = 16) AND (fact_publishers_v4_2.osid = 30) AND (fact_publishers_v4_2.browserid = 10))
  • Buffers: shared hit=3
8. 0.006 0.006 ↓ 0.0 0 1

Index Scan using fact_publishers_64_v4_2020_02_04_siteid_idx_264666 on public.fact_publishers_64_v4_2020_02_04_264666 fact_publishers_v4_3 (cost=0.42..65.88 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)

  • Output: fact_publishers_v4_3.views
  • Index Cond: (fact_publishers_v4_3.siteid = 165850)
  • Filter: ((fact_publishers_v4_3.country = 'United States'::text) AND (fact_publishers_v4_3.state = 'California'::text) AND (fact_publishers_v4_3.adsizeid = 16) AND (fact_publishers_v4_3.osid = 30) AND (fact_publishers_v4_3.browserid = 10))
  • Buffers: shared hit=3
9. 0.006 0.006 ↓ 0.0 0 1

Index Scan using fact_publishers_64_v4_2020_02_05_siteid_idx_264730 on public.fact_publishers_64_v4_2020_02_05_264730 fact_publishers_v4_4 (cost=0.42..28.28 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)

  • Output: fact_publishers_v4_4.views
  • Index Cond: (fact_publishers_v4_4.siteid = 165850)
  • Filter: ((fact_publishers_v4_4.country = 'United States'::text) AND (fact_publishers_v4_4.state = 'California'::text) AND (fact_publishers_v4_4.adsizeid = 16) AND (fact_publishers_v4_4.osid = 30) AND (fact_publishers_v4_4.browserid = 10))
  • Buffers: shared hit=3
10. 0.006 0.006 ↓ 0.0 0 1

Index Scan using fact_publishers_64_v4_2020_02_06_siteid_idx_264794 on public.fact_publishers_64_v4_2020_02_06_264794 fact_publishers_v4_5 (cost=0.42..37.52 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)

  • Output: fact_publishers_v4_5.views
  • Index Cond: (fact_publishers_v4_5.siteid = 165850)
  • Filter: ((fact_publishers_v4_5.country = 'United States'::text) AND (fact_publishers_v4_5.state = 'California'::text) AND (fact_publishers_v4_5.adsizeid = 16) AND (fact_publishers_v4_5.osid = 30) AND (fact_publishers_v4_5.browserid = 10))
  • Buffers: shared hit=3
11. 0.006 0.006 ↓ 0.0 0 1

Index Scan using fact_publishers_64_v4_2020_02_07_siteid_idx_264858 on public.fact_publishers_64_v4_2020_02_07_264858 fact_publishers_v4_6 (cost=0.42..21.60 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)

  • Output: fact_publishers_v4_6.views
  • Index Cond: (fact_publishers_v4_6.siteid = 165850)
  • Filter: ((fact_publishers_v4_6.country = 'United States'::text) AND (fact_publishers_v4_6.state = 'California'::text) AND (fact_publishers_v4_6.adsizeid = 16) AND (fact_publishers_v4_6.osid = 30) AND (fact_publishers_v4_6.browserid = 10))
  • Buffers: shared hit=3
12. 0.005 0.005 ↓ 0.0 0 1

Index Scan using fact_publishers_64_v4_2020_02_08_siteid_idx_264922 on public.fact_publishers_64_v4_2020_02_08_264922 fact_publishers_v4_7 (cost=0.42..30.32 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=1)

  • Output: fact_publishers_v4_7.views
  • Index Cond: (fact_publishers_v4_7.siteid = 165850)
  • Filter: ((fact_publishers_v4_7.country = 'United States'::text) AND (fact_publishers_v4_7.state = 'California'::text) AND (fact_publishers_v4_7.adsizeid = 16) AND (fact_publishers_v4_7.osid = 30) AND (fact_publishers_v4_7.browserid = 10))
  • Buffers: shared hit=3
13. 0.005 0.005 ↓ 0.0 0 1

Index Scan using fact_publishers_64_v4_2020_02_09_siteid_idx_264986 on public.fact_publishers_64_v4_2020_02_09_264986 fact_publishers_v4_8 (cost=0.42..39.63 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=1)

  • Output: fact_publishers_v4_8.views
  • Index Cond: (fact_publishers_v4_8.siteid = 165850)
  • Filter: ((fact_publishers_v4_8.country = 'United States'::text) AND (fact_publishers_v4_8.state = 'California'::text) AND (fact_publishers_v4_8.adsizeid = 16) AND (fact_publishers_v4_8.osid = 30) AND (fact_publishers_v4_8.browserid = 10))
  • Buffers: shared hit=3
14. 0.006 0.006 ↓ 0.0 0 1

Index Scan using fact_publishers_64_v4_2020_02_10_siteid_idx_265050 on public.fact_publishers_64_v4_2020_02_10_265050 fact_publishers_v4_9 (cost=0.42..27.50 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)

  • Output: fact_publishers_v4_9.views
  • Index Cond: (fact_publishers_v4_9.siteid = 165850)
  • Filter: ((fact_publishers_v4_9.country = 'United States'::text) AND (fact_publishers_v4_9.state = 'California'::text) AND (fact_publishers_v4_9.adsizeid = 16) AND (fact_publishers_v4_9.osid = 30) AND (fact_publishers_v4_9.browserid = 10))
  • Buffers: shared hit=3
15. 0.006 0.006 ↓ 0.0 0 1

Index Scan using fact_publishers_64_v4_2020_02_11_siteid_idx_265114 on public.fact_publishers_64_v4_2020_02_11_265114 fact_publishers_v4_10 (cost=0.42..40.53 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)

  • Output: fact_publishers_v4_10.views
  • Index Cond: (fact_publishers_v4_10.siteid = 165850)
  • Filter: ((fact_publishers_v4_10.country = 'United States'::text) AND (fact_publishers_v4_10.state = 'California'::text) AND (fact_publishers_v4_10.adsizeid = 16) AND (fact_publishers_v4_10.osid = 30) AND (fact_publishers_v4_10.browserid = 10))
  • Buffers: shared hit=3
16. 0.013 0.013 ↓ 0.0 0 1

Index Scan using fact_publishers_64_v4_2020_02_12_siteid_idx_265178 on public.fact_publishers_64_v4_2020_02_12_265178 fact_publishers_v4_11 (cost=0.42..25.42 rows=1 width=4) (actual time=0.013..0.013 rows=0 loops=1)

  • Output: fact_publishers_v4_11.views
  • Index Cond: (fact_publishers_v4_11.siteid = 165850)
  • Filter: ((fact_publishers_v4_11.country = 'United States'::text) AND (fact_publishers_v4_11.state = 'California'::text) AND (fact_publishers_v4_11.adsizeid = 16) AND (fact_publishers_v4_11.osid = 30) AND (fact_publishers_v4_11.browserid = 10))
  • Buffers: shared hit=3
17. 0.010 0.010 ↓ 0.0 0 1

Index Scan using fact_publishers_64_v4_2020_02_13_siteid_idx_265242 on public.fact_publishers_64_v4_2020_02_13_265242 fact_publishers_v4_12 (cost=0.42..26.47 rows=1 width=4) (actual time=0.010..0.010 rows=0 loops=1)

  • Output: fact_publishers_v4_12.views
  • Index Cond: (fact_publishers_v4_12.siteid = 165850)
  • Filter: ((fact_publishers_v4_12.country = 'United States'::text) AND (fact_publishers_v4_12.state = 'California'::text) AND (fact_publishers_v4_12.adsizeid = 16) AND (fact_publishers_v4_12.osid = 30) AND (fact_publishers_v4_12.browserid = 10))
  • Buffers: shared hit=3
18. 0.009 0.009 ↓ 0.0 0 1

Index Scan using fact_publishers_64_v4_2020_02_14_siteid_idx_265306 on public.fact_publishers_64_v4_2020_02_14_265306 fact_publishers_v4_13 (cost=0.42..19.90 rows=1 width=4) (actual time=0.009..0.009 rows=0 loops=1)

  • Output: fact_publishers_v4_13.views
  • Index Cond: (fact_publishers_v4_13.siteid = 165850)
  • Filter: ((fact_publishers_v4_13.country = 'United States'::text) AND (fact_publishers_v4_13.state = 'California'::text) AND (fact_publishers_v4_13.adsizeid = 16) AND (fact_publishers_v4_13.osid = 30) AND (fact_publishers_v4_13.browserid
  • Index Cond: (fact_publishers_v4_8.siteid = 165850)
  • Filter: ((fact_publishers_v4_8.country = 'United States'::text) AND (fact_publishers_v4_8.state = 'California'::text) AND (fact_publishers_v4_8.adsizeid = 16) AND (fact_publishers_v4_8.osid = 30) AND (fact_publishers_v4_8.browserid = 10))
  • Buffers: shared hit=3
19. 0.006 0.006 ↓ 0.0 0 1

Index Scan using fact_publishers_64_v4_2020_02_10_siteid_idx_265050 on public.fact_publishers_64_v4_2020_02_10_265050 fact_publishers_v4_9 (cost=0.42..27.50 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)

  • Output: fact_publishers_v4_9.views
  • Index Cond: (fact_publishers_v4_9.siteid = 165850)
  • Filter: ((fact_publishers_v4_9.country = 'United States'::text) AND (fact_publishers_v4_9.state = 'California'::text) AND (fact_publishers_v4_9.adsizeid = 16) AND (fact_publishers_v4_9.osid = 30) AND (fact_publishers_v4_9.browserid = 10))
  • Buffers: shared hit=3
20. 0.006 0.006 ↓ 0.0 0 1

Index Scan using fact_publishers_64_v4_2020_02_11_siteid_idx_265114 on public.fact_publishers_64_v4_2020_02_11_265114 fact_publishers_v4_10 (cost=0.42..40.53 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)

  • Output: fact_publishers_v4_10.views
  • Index Cond: (fact_publishers_v4_10.siteid = 165850)
  • Filter: ((fact_publishers_v4_10.country = 'United States'::text) AND (fact_publishers_v4_10.state = 'California'::text) AND (fact_publishers_v4_10.adsizeid = 16) AND (fact_publishers_v4_10.osid = 30) AND (fact_publishers_v4_10.browserid = 10))
  • Buffers: shared hit=3
21. 0.013 0.013 ↓ 0.0 0 1

Index Scan using fact_publishers_64_v4_2020_02_12_siteid_idx_265178 on public.fact_publishers_64_v4_2020_02_12_265178 fact_publishers_v4_11 (cost=0.42..25.42 rows=1 width=4) (actual time=0.013..0.013 rows=0 loops=1)

  • Output: fact_publishers_v4_11.views
  • Index Cond: (fact_publishers_v4_11.siteid = 165850)
  • Filter: ((fact_publishers_v4_11.country = 'United States'::text) AND (fact_publishers_v4_11.state = 'California'::text) AND (fact_publishers_v4_11.adsizeid = 16) AND (fact_publishers_v4_11.osid = 30) AND (fact_publishers_v4_11.browserid = 10))
  • Buffers: shared hit=3
22. 0.010 0.010 ↓ 0.0 0 1

Index Scan using fact_publishers_64_v4_2020_02_13_siteid_idx_265242 on public.fact_publishers_64_v4_2020_02_13_265242 fact_publishers_v4_12 (cost=0.42..26.47 rows=1 width=4) (actual time=0.010..0.010 rows=0 loops=1)

  • Output: fact_publishers_v4_12.views
  • Index Cond: (fact_publishers_v4_12.siteid = 165850)
  • Filter: ((fact_publishers_v4_12.country = 'United States'::text) AND (fact_publishers_v4_12.state = 'California'::text) AND (fact_publishers_v4_12.adsizeid = 16) AND (fact_publishers_v4_12.osid = 30) AND (fact_publishers_v4_12.browserid = 10))
  • Buffers: shared hit=3
23. 0.009 0.009 ↓ 0.0 0 1

Index Scan using fact_publishers_64_v4_2020_02_14_siteid_idx_265306 on public.fact_publishers_64_v4_2020_02_14_265306 fact_publishers_v4_13 (cost=0.42..19.90 rows=1 width=4) (actual time=0.009..0.009 rows=0 loops=1)

  • Output: fact_publishers_v4_13.views
  • Index Cond: (fact_publishers_v4_13.siteid = 165850)
  • Filter: ((fact_publishers_v4_13.country = 'United States'::text) AND (fact_publishers_v4_13.state = 'California'::text) AND (fact_publishers_v4_13.adsizeid = 16) AND (fact_publishers_v4_13.osid = 30) AND (fact_publishers_v4_13.browserid = 10))
  • Buffers: shared hit=3
24. 0.010 0.010 ↓ 0.0 0 1

Index Scan using fact_publishers_64_v4_2020_02_15_siteid_idx_265370 on public.fact_publishers_64_v4_2020_02_15_265370 fact_publishers_v4_14 (cost=0.42..41.29 rows=1 width=4) (actual time=0.010..0.010 rows=0 loops=1)

  • Output: fact_publishers_v4_14.views
  • Index Cond: (fact_publishers_v4_14.siteid = 165850)
  • Filter: ((fact_publishers_v4_14.country = 'United States'::text) AND (fact_publishers_v4_14.state = 'California'::text) AND (fact_publishers_v4_14.adsizeid = 16) AND (fact_publishers_v4_14.osid = 30) AND (fact_publishers_v4_14.browserid = 10))
  • Buffers: shared hit=3
Planning time : 2.745 ms
Execution time : 184.396 ms