explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xFaQ

Settings
# exclusive inclusive rows x rows loops node
1. 441.880 13,801.477 ↑ 1.0 1 1

Aggregate (cost=647,551.85..647,551.86 rows=1 width=0) (actual time=13,801.476..13,801.477 rows=1 loops=1)

2. 2,556.967 13,359.597 ↓ 1.5 5,000,004 1

Merge Join (cost=6,803.40..639,112.94 rows=3,375,566 width=0) (actual time=170.538..13,359.597 rows=5,000,004 loops=1)

  • Merge Cond: (user_data_pushwoosh.user_id = user_pushwoosh.user_id)
3. 7,474.071 7,474.071 ↑ 1.0 15,032,423 1

Index Scan using user_data_pushwoosh_pkey on user_data_pushwoosh (cost=0.43..648,610.37 rows=15,038,362 width=8) (actual time=0.010..7,474.071 rows=15,032,423 loops=1)

  • Filter: (country <> 'ITA'::text)
  • Rows Removed by Filter: 204
4. 3,328.559 3,328.559 ↓ 1.5 5,000,005 1

Index Scan using user_pushwoosh_user_id_idx on user_pushwoosh (cost=0.43..365,514.81 rows=3,377,074 width=8) (actual time=0.006..3,328.559 rows=5,000,005 loops=1)

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