explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gmOz

Settings
# exclusive inclusive rows x rows loops node
1. 14.439 2,026.312 ↑ 1.6 97,000 1

Gather (cost=2,985.07..190,817.18 rows=159,184 width=137) (actual time=14.565..2,026.312 rows=97,000 loops=1)

  • Workers Planned: 2
  • Workers Launched: 0
2. 123.157 2,011.873 ↓ 1.5 97,000 1

Parallel Hash Join (cost=1,985.07..173,898.78 rows=66,327 width=137) (actual time=13.997..2,011.873 rows=97,000 loops=1)

  • Hash Cond: (stats_page_view.session_id = stats_session.id)
  • Join Filter: (((stats_session.campaign_id)::numeric >= '1'::numeric) OR (((_hyper_5_4_chunk."values" ->> 'scrollTriggerValue'::text))::numeric <= '100'::numeric))
3. 439.546 1,875.333 ↑ 1.1 97,000 1

Nested Loop (cost=0.00..168,411.42 rows=105,638 width=104) (actual time=0.429..1,875.333 rows=97,000 loops=1)

4. 9.456 1,435.783 ↓ 10.3 97,000 1

Parallel Append (cost=0.00..157,589.36 rows=9,386 width=76) (actual time=0.389..1,435.783 rows=97,000 loops=1)

5. 1,426.326 1,426.326 ↓ 10.3 97,000 1

Parallel Seq Scan on _hyper_5_4_chunk (cost=0.00..157,542.43 rows=9,385 width=76) (actual time=0.388..1,426.326 rows=97,000 loops=1)

  • Filter: ((created_at >= '2019-03-11 09:37:00+00'::timestamp with time zone) AND (created_at <= '2019-05-10 09:37:59+00'::timestamp with time zone) AND ((property_id)::numeric = '1'::numeric))
  • Rows Removed by Filter: 4402999
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-03-11 09:37:00+00'::timestamp with time zone) AND (created_at <= '2019-05-10 09:37:59+00'::timestamp with time zone) AND ((property_id)::numeric = '1'::numeric))
7. 0.001 0.004 ↑ 2.0 1 97,000

Append (cost=0.00..1.13 rows=2 width=44) (actual time=0.004..0.004 rows=1 loops=97,000)

8. 0.000 0.000 ↓ 0.0 0 97,000

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

  • Filter: ((created_at >= '2019-03-11 09:37:00+00'::timestamp with time zone) AND (created_at <= '2019-05-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 97,000

Index Scan using "3_3_stats_page_view_id" on _hyper_3_3_chunk (cost=0.42..1.12 rows=1 width=44) (actual time=0.002..0.003 rows=1 loops=97,000)

  • Index Cond: ((id = _hyper_5_4_chunk.page_view_id) AND (created_at >= '2019-03-11 09:37:00+00'::timestamp with time zone) AND (created_at <= '2019-05-10 09:37:59+00'::timestamp with time zone))
  • Filter: ((property_id)::numeric = '1'::numeric)
10. 0.309 13.383 ↓ 10.2 970 1

Parallel Hash (cost=1,983.88..1,983.88 rows=95 width=53) (actual time=13.382..13.383 rows=970 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 104kB
11. 0.112 13.074 ↓ 10.2 970 1

Parallel Append (cost=0.00..1,983.88 rows=95 width=53) (actual time=0.012..13.074 rows=970 loops=1)

12. 0.011 0.011 ↓ 0.0 0 1

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

  • Filter: ((created_at >= '2019-03-11 09:37:00+00'::timestamp with time zone) AND (created_at <= '2019-05-10 09:37:59+00'::timestamp with time zone) AND ((property_id)::numeric = '1'::numeric))
13. 12.951 12.951 ↓ 7.3 970 1

Parallel Seq Scan on _hyper_2_2_chunk (cost=0.00..1,983.41 rows=132 width=52) (actual time=0.011..12.951 rows=970 loops=1)

  • Filter: ((created_at >= '2019-03-11 09:37:00+00'::timestamp with time zone) AND (created_at <= '2019-05-10 09:37:59+00'::timestamp with time zone) AND ((property_id)::numeric = '1'::numeric))
  • Rows Removed by Filter: 44030