explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eYA0

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 30,860.422 ↑ 50.2 4 1

Sort (cost=682,784.16..682,784.66 rows=201 width=76) (actual time=30,860.421..30,860.422 rows=4 loops=1)

  • Sort Key: (CASE COALESCE(data_stats_page_view."Page view - Consent") WHEN '[TOTAL]'::text THEN 0 ELSE 1 END), (CASE (COALESCE(data_stats_page_view."Page view - Consent") ~ '^([0-9]+[.]?[0-9]*|[.][0-9]+)$'::text) WHEN CASE_TEST_EXPR THEN lpad(COALESCE(data_stats_page_view."Page view - Consent"), 50, '0'::text) ELSE COALESCE(data_stats_page_view."Page view - Consent") END)
  • Sort Method: quicksort Memory: 25kB
2. 0.025 30,860.403 ↑ 50.2 4 1

Subquery Scan on data_stats_page_view (cost=0.43..682,776.47 rows=201 width=76) (actual time=30,860.393..30,860.403 rows=4 loops=1)

3. 529.180 30,860.378 ↑ 50.2 4 1

MixedAggregate (cost=0.43..682,772.95 rows=201 width=72) (actual time=30,860.374..30,860.378 rows=4 loops=1)

  • Hash Key: (COALESCE((_hyper_3_120_chunk.consent)::text, ''::text))
  • Group Key: ()
4. 196.355 30,331.198 ↓ 1.1 1,704,473 1

Result (cost=0.43..670,753.21 rows=1,602,365 width=48) (actual time=0.230..30,331.198 rows=1,704,473 loops=1)

5. 165.225 30,134.843 ↓ 1.1 1,704,473 1

Append (cost=0.43..654,729.56 rows=1,602,365 width=48) (actual time=0.229..30,134.843 rows=1,704,473 loops=1)

6. 26,056.235 26,056.235 ↓ 1.2 570,262 1

Index Scan using _hyper_3_120_chunk_stats_page_view_created_at_idx on _hyper_3_120_chunk (cost=0.43..235,920.77 rows=476,835 width=48) (actual time=0.229..26,056.235 rows=570,262 loops=1)

  • Index Cond: ((created_at >= '2020-05-31 22:00:00+00'::timestamp with time zone) AND (created_at <= '2020-06-30 21:59:59+00'::timestamp with time zone))
  • Filter: (property_id = 56)
  • Rows Removed by Filter: 1,310,697
7. 3,913.383 3,913.383 ↓ 1.0 1,134,211 1

Index Scan using _hyper_3_128_chunk_tmp_pageview_property_id_and_created_at on _hyper_3_128_chunk (cost=0.43..410,796.96 rows=1,125,530 width=48) (actual time=0.064..3,913.383 rows=1,134,211 loops=1)

  • Index Cond: ((property_id = 56) AND (created_at >= '2020-05-31 22:00:00+00'::timestamp with time zone) AND (created_at <= '2020-06-30 21:59:59+00'::timestamp with time zone))
Planning time : 8.569 ms
Execution time : 30,860.506 ms