explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6wwvj

Settings
# exclusive inclusive rows x rows loops node
1. 2.185 2,859.776 ↑ 1.4 569 1

Hash Right Join (cost=71,304.99..71,439.32 rows=770 width=164) (actual time=2,854.932..2,859.776 rows=569 loops=1)

  • Hash Cond: (traffic_sessions.iccid = (sims.iccid)::text)
2. 3.295 2,856.391 ↑ 1.9 1,147 1

Finalize GroupAggregate (cost=71,161.94..71,268.06 rows=2,234 width=71) (actual time=2,852.747..2,856.391 rows=1,147 loops=1)

  • Group Key: traffic_sessions.iccid, traffic_sessions.carrier_country_code
3. 23.110 2,853.096 ↑ 1.3 3,312 1

Sort (cost=71,161.94..71,173.11 rows=4,468 width=71) (actual time=2,852.343..2,853.096 rows=3,312 loops=1)

  • Sort Key: traffic_sessions.iccid, traffic_sessions.carrier_country_code
  • Sort Method: quicksort Memory: 562kB
4. 17.570 2,829.986 ↑ 1.3 3,312 1

Gather (cost=70,416.34..70,891.06 rows=4,468 width=71) (actual time=2,819.310..2,829.986 rows=3,312 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 519.233 2,812.416 ↑ 2.0 1,104 3 / 3

Partial HashAggregate (cost=69,416.34..69,444.26 rows=2,234 width=71) (actual time=2,810.784..2,812.416 rows=1,104 loops=3)

  • Group Key: traffic_sessions.iccid, traffic_sessions.carrier_country_code
6. 2,293.183 2,293.183 ↑ 1.2 548,407 3 / 3

Parallel Seq Scan on traffic_sessions (cost=0.00..61,071.71 rows=667,570 width=39) (actual time=0.937..2,293.183 rows=548,407 loops=3)

  • Filter: ((end >= '2019-08-27 06:00:00+00'::timestamp with time zone) AND (end <= '2019-09-28 05:59:59.999+00'::timestamp with time zone))
  • Rows Removed by Filter: 266,191
7. 0.268 1.200 ↑ 1.0 569 1

Hash (cost=135.90..135.90 rows=572 width=112) (actual time=1.200..1.200 rows=569 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 103kB
8. 0.932 0.932 ↑ 1.0 569 1

Seq Scan on sims (cost=0.00..135.90 rows=572 width=112) (actual time=0.293..0.932 rows=569 loops=1)

  • Filter: ((NOT archived) AND ((clientSlug)::text = 'aware360'::text) AND ((providerSlug)::text = 'telus'::text))
  • Rows Removed by Filter: 1,091
Planning time : 1.493 ms
Execution time : 2,862.568 ms