explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CIQH

Settings
# exclusive inclusive rows x rows loops node
1. 6.392 1,732.512 ↓ 3.2 39,600 1

Gather (cost=2,297.97..128,262.98 rows=12,407 width=138) (actual time=34.352..1,732.512 rows=39,600 loops=1)

  • Workers Planned: 2
  • Workers Launched: 0
2. 62.335 1,726.120 ↓ 7.7 39,600 1

Parallel Hash Join (cost=1,297.97..126,022.28 rows=5,170 width=138) (actual time=33.731..1,726.120 rows=39,600 loops=1)

  • Hash Cond: (stats_page_view.session_id = _hyper_2_2_chunk.id)
  • Join Filter: (((_hyper_2_2_chunk.campaign_id)::numeric >= '1'::numeric) OR (((_hyper_5_4_chunk."values" ->> 'scrollTriggerValue'::text))::numeric <= '100'::numeric))
3. 232.888 1,631.175 ↓ 2.1 39,950 1

Nested Loop (cost=0.00..124,500.65 rows=19,376 width=104) (actual time=0.924..1,631.175 rows=39,950 loops=1)

4. 4.448 1,398.282 ↓ 9.9 40,012 1

Parallel Append (cost=0.00..118,394.37 rows=4,029 width=76) (actual time=0.896..1,398.282 rows=40,012 loops=1)

5. 1,393.833 1,393.833 ↓ 9.9 40,012 1

Parallel Index Scan using _hyper_5_4_chunk_stats_event_created_at_idx on _hyper_5_4_chunk (cost=0.43..118,374.22 rows=4,028 width=76) (actual time=0.894..1,393.833 rows=40,012 loops=1)

  • Index Cond: ((created_at >= '2019-04-05 09:37:00+00'::timestamp with time zone) AND (created_at <= '2019-04-10 09:37:59+00'::timestamp with time zone))
  • Filter: ((property_id)::numeric = '1'::numeric)
  • Rows Removed by Filter: 1872217
6. 0.001 0.001 ↓ 0.0 0 1

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

  • Filter: ((created_at >= '2019-04-05 09:37:00+00'::timestamp with time zone) AND (created_at <= '2019-04-10 09:37:59+00'::timestamp with time zone) AND ((property_id)::numeric = '1'::numeric))
7. 0.002 0.005 ↑ 2.0 1 40,012

Append (cost=0.00..1.50 rows=2 width=44) (actual time=0.005..0.005 rows=1 loops=40,012)

8. 0.000 0.000 ↓ 0.0 0 40,012

Seq Scan on stats_page_view (cost=0.00..0.00 rows=1 width=44) (actual time=0.000..0.000 rows=0 loops=40,012)

  • Filter: ((created_at >= '2019-04-05 09:37:00+00'::timestamp with time zone) AND (created_at <= '2019-04-10 09:37:59+00'::timestamp with time zone) AND (_hyper_5_4_chunk.page_view_id = id) AND ((property_id)::numeric = '1'::numeric))
9. 0.003 0.003 ↑ 1.0 1 40,012

Index Scan using "3_3_stats_page_view_id" on _hyper_3_3_chunk (cost=0.42..1.49 rows=1 width=44) (actual time=0.003..0.003 rows=1 loops=40,012)

  • Index Cond: ((id = _hyper_5_4_chunk.page_view_id) AND (created_at >= '2019-04-05 09:37:00+00'::timestamp with time zone) AND (created_at <= '2019-04-10 09:37:59+00'::timestamp with time zone))
  • Filter: ((property_id)::numeric = '1'::numeric)
10. 0.201 32.610 ↓ 9.7 396 1

Parallel Hash (cost=1,297.46..1,297.46 rows=41 width=54) (actual time=32.609..32.610 rows=396 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 72kB
11. 0.047 32.409 ↓ 9.7 396 1

Parallel Append (cost=0.00..1,297.46 rows=41 width=54) (actual time=0.050..32.409 rows=396 loops=1)

12. 32.362 32.362 ↓ 7.1 396 1

Parallel Index Scan using _hyper_2_2_chunk_stats_session_created_at_idx on _hyper_2_2_chunk (cost=0.29..1,297.26 rows=56 width=52) (actual time=0.048..32.362 rows=396 loops=1)

  • Index Cond: ((created_at >= '2019-04-05 09:37:00+00'::timestamp with time zone) AND (created_at <= '2019-04-10 09:37:59+00'::timestamp with time zone))
  • Filter: ((property_id)::numeric = '1'::numeric)
  • Rows Removed by Filter: 18527
13. 0.000 0.000 ↓ 0.0 0 1

Parallel Seq Scan on stats_session (cost=0.00..0.00 rows=1 width=262) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ((created_at >= '2019-04-05 09:37:00+00'::timestamp with time zone) AND (created_at <= '2019-04-10 09:37:59+00'::timestamp with time zone) AND ((property_id)::numeric = '1'::numeric))