explain.depesz.com

PostgreSQL's explain analyze made readable

Result: T8Nq

Settings
# exclusive inclusive rows x rows loops node
1. 109.635 24,111.823 ↑ 1.0 1 1

Aggregate (cost=579,136.22..579,136.23 rows=1 width=0) (actual time=24,111.822..24,111.823 rows=1 loops=1)

2. 1,880.243 24,002.188 ↓ 1.5 1,000,609 1

Hash Join (cost=332,597.26..577,426.49 rows=683,890 width=0) (actual time=11,323.392..24,002.188 rows=1,000,609 loops=1)

  • Hash Cond: (user_data_pushwoosh.user_id = user_pushwoosh.user_id)
3. 10,884.503 17,194.076 ↑ 1.0 3,029,523 1

Bitmap Heap Scan on user_data_pushwoosh (cost=79,751.13..298,699.14 rows=3,046,772 width=8) (actual time=6,365.865..17,194.076 rows=3,029,523 loops=1)

  • Recheck Cond: (language = 'en'::text)
  • Filter: (country <> 'ITA'::text)
  • Rows Removed by Filter: 204
  • Heap Blocks: exact=133733
4. 6,309.573 6,309.573 ↓ 1.0 3,094,239 1

Bitmap Index Scan on user_data_pushwoosh_language_idx (cost=0.00..78,989.44 rows=3,048,134 width=0) (actual time=6,309.573..6,309.573 rows=3,094,239 loops=1)

  • Index Cond: (language = 'en'::text)
5. 2,074.062 4,927.869 ↓ 1.5 5,000,020 1

Hash (cost=210,632.70..210,632.70 rows=3,377,074 width=8) (actual time=4,927.869..4,927.869 rows=5,000,020 loops=1)

  • Buckets: 8388608 (originally 4194304) Batches: 1 (originally 1) Memory Usage: 260850kB
6. 2,853.807 2,853.807 ↓ 1.5 5,000,020 1

Seq Scan on user_pushwoosh (cost=0.00..210,632.70 rows=3,377,074 width=8) (actual time=0.549..2,853.807 rows=5,000,020 loops=1)

  • Filter: (app_id = ANY ('{-1,4,2,5,8,3,7,1}'::bigint[]))
Planning time : 0.477 ms
Execution time : 24,119.874 ms