explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WKaM

Settings
# exclusive inclusive rows x rows loops node
1. 109.491 1,238.147 ↑ 5.8 620 1

GroupAggregate (cost=97,955.41..99,837.78 rows=3,568 width=110) (actual time=1,104.840..1,238.147 rows=620 loops=1)

  • Group Key: query.date, query."s.geo_country_code
2. 72.656 1,128.656 ↓ 2.6 92,899 1

Sort (cost=97,955.41..98,044.63 rows=35,685 width=106) (actual time=1,104.656..1,128.656 rows=92,899 loops=1)

  • Sort Key: query.date, query."s.geo_country_code
  • Sort Method: external merge Disk: 8568kB
3. 18.630 1,056.000 ↓ 2.6 92,899 1

Subquery Scan on query (cost=93,625.02..94,071.09 rows=35,685 width=106) (actual time=1,008.418..1,056.000 rows=92,899 loops=1)

4. 125.753 1,037.370 ↓ 2.6 92,899 1

Sort (cost=93,625.02..93,714.24 rows=35,685 width=114) (actual time=1,008.414..1,037.370 rows=92,899 loops=1)

  • Sort Key: s.id, p_1.id
  • Sort Method: external merge Disk: 8568kB
5. 89.829 911.617 ↓ 2.6 92,899 1

WindowAgg (cost=88,867.79..89,670.70 rows=35,685 width=114) (actual time=793.386..911.617 rows=92,899 loops=1)

6. 113.423 821.788 ↓ 2.6 92,899 1

Sort (cost=88,867.79..88,957.00 rows=35,685 width=98) (actual time=793.361..821.788 rows=92,899 loops=1)

  • Sort Key: p_1.id
  • Sort Method: external merge Disk: 7104kB
7. 39.596 708.365 ↓ 2.6 92,899 1

Hash Join (cost=75,805.39..85,053.46 rows=35,685 width=98) (actual time=608.768..708.365 rows=92,899 loops=1)

  • Hash Cond: (p_1.session_id = s.id)
8. 12.861 664.246 ↓ 12.3 92,899 1

Gather (cost=75,051.48..83,034.55 rows=7,568 width=88) (actual time=604.210..664.246 rows=92,899 loops=1)

  • Workers Planned: 2
  • Workers Launched: 0
9. 27.015 651.385 ↓ 29.5 92,899 1

Parallel Hash Join (cost=74,051.48..81,277.75 rows=3,153 width=88) (actual time=603.587..651.385 rows=92,899 loops=1)

  • Hash Cond: (p_1.id = e_1.page_view_id)
10. 1.096 21.729 ↓ 2.4 9,290 1

Parallel Append (cost=0.00..7,198.44 rows=3,919 width=36) (actual time=0.025..21.729 rows=9,290 loops=1)

11. 20.632 20.632 ↓ 1.7 9,290 1

Parallel Index Scan using _hyper_3_3_chunk_idx_pageview_property_id_and_created_at on _hyper_3_3_chunk p_1 (cost=0.42..7,178.84 rows=5,532 width=36) (actual time=0.024..20.632 rows=9,290 loops=1)

  • Index Cond: ((property_id = 2) AND (created_at >= '2019-04-01 00:00:00+00'::timestamp with time zone) AND (created_at <= '2019-04-10 23:59:59+00'::timestamp with time zone))
12. 0.001 0.001 ↓ 0.0 0 1

Parallel Seq Scan on stats_page_view p (cost=0.00..0.00 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((created_at >= '2019-04-01 00:00:00+00'::timestamp with time zone) AND (created_at <= '2019-04-10 23:59:59+00'::timestamp with time zone) AND (property_id = 2))
13. 26.017 602.641 ↓ 2.2 92,899 1

Parallel Hash (cost=73,528.20..73,528.20 rows=41,862 width=68) (actual time=602.641..602.641 rows=92,899 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 7584kB
14. 9.662 576.624 ↓ 2.2 92,899 1

Parallel Append (cost=0.00..73,528.20 rows=41,862 width=68) (actual time=0.021..576.624 rows=92,899 loops=1)

15. 566.961 566.961 ↓ 2.2 92,899 1

Parallel Index Scan using _hyper_5_4_chunk_idx_event_property_id_and_created_at on _hyper_5_4_chunk e_1 (cost=0.43..73,318.89 rows=41,861 width=68) (actual time=0.019..566.961 rows=92,899 loops=1)

  • Index Cond: ((property_id = 2) AND (created_at >= '2019-04-01 00:00:00+00'::timestamp with time zone) AND (created_at <= '2019-04-10 23:59:59+00'::timestamp with time zone))
16. 0.001 0.001 ↓ 0.0 0 1

Parallel Seq Scan on stats_event e (cost=0.00..0.00 rows=1 width=68) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((created_at >= '2019-04-01 00:00:00+00'::timestamp with time zone) AND (created_at <= '2019-04-10 23:59:59+00'::timestamp with time zone) AND (property_id = 2))
17. 0.477 4.523 ↑ 1.0 929 1

Hash (cost=742.13..742.13 rows=943 width=26) (actual time=4.523..4.523 rows=929 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 61kB
18. 0.093 4.046 ↑ 1.0 929 1

Append (cost=0.00..742.13 rows=943 width=26) (actual time=0.021..4.046 rows=929 loops=1)

19. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on stats_session s (cost=0.00..0.00 rows=1 width=62) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: ((created_at >= '2019-04-01 00:00:00+00'::timestamp with time zone) AND (created_at <= '2019-04-10 23:59:59+00'::timestamp with time zone) AND (property_id = 2))
20. 3.948 3.948 ↑ 1.0 929 1

Index Scan using _hyper_2_2_chunk_idx_session_property_id_and_created_at on _hyper_2_2_chunk s_1 (cost=0.29..737.41 rows=942 width=26) (actual time=0.016..3.948 rows=929 loops=1)

  • Index Cond: ((property_id = 2) AND (created_at >= '2019-04-01 00:00:00+00'::timestamp with time zone) AND (created_at <= '2019-04-10 23:59:59+00'::timestamp with time zone))
Planning time : 1.044 ms
Execution time : 1,246.806 ms