explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SuM4

Settings
# exclusive inclusive rows x rows loops node
1. 42,233.868 89,091.138 ↓ 1.1 27,216,760 1

Hash Join (cost=299,837.70..2,638,401.83 rows=25,599,977 width=28) (actual time=11,571.815..89,091.138 rows=27,216,760 loops=1)

  • Hash Cond: (sl.subscription_id = s.id)
2. 35,291.539 35,291.539 ↓ 1.1 27,284,299 1

Seq Scan on subscription_log sl (cost=0.00..1,531,360.04 rows=25,668,379 width=20) (actual time=0.498..35,291.539 rows=27,284,299 loops=1)

  • Filter: (log_type = ANY ('{5,6,23,8,22,2,3,9}'::integer[]))
  • Rows Removed by Filter: 22373638
3. 2,040.817 11,565.731 ↑ 1.0 5,276,074 1

Hash (cost=207,977.60..207,977.60 rows=5,284,488 width=16) (actual time=11,565.731..11,565.731 rows=5,276,074 loops=1)

  • Buckets: 65536 Batches: 16 Memory Usage: 15501kB
4. 9,524.914 9,524.914 ↑ 1.0 5,276,074 1

Seq Scan on subscription s (cost=0.00..207,977.60 rows=5,284,488 width=16) (actual time=0.534..9,524.914 rows=5,276,074 loops=1)

  • Filter: ((NOT is_test) AND (status <> 1))
  • Rows Removed by Filter: 9315
Planning time : 7.624 ms
Execution time : 94,008.072 ms