explain.depesz.com

PostgreSQL's explain analyze made readable

Result: exXc

Settings
# exclusive inclusive rows x rows loops node
1. 41,882.600 79,597.863 ↓ 1.1 27,216,767 1

Hash Join (cost=299,837.70..2,638,401.83 rows=25,599,977 width=28) (actual time=4,299.697..79,597.863 rows=27,216,767 loops=1)

  • Hash Cond: (sl.subscription_id = s.id)
2. 33,423.047 33,423.047 ↓ 1.1 27,284,306 1

Seq Scan on subscription_log sl (cost=0.00..1,531,360.04 rows=25,668,379 width=20) (actual time=0.200..33,423.047 rows=27,284,306 loops=1)

  • Filter: (log_type = ANY ('{5,6,23,8,22,2,3,9}'::integer[]))
  • Rows Removed by Filter: 22373647
3. 1,959.641 4,292.216 ↑ 1.0 5,276,076 1

Hash (cost=207,977.60..207,977.60 rows=5,284,488 width=16) (actual time=4,292.216..4,292.216 rows=5,276,076 loops=1)

  • Buckets: 65536 Batches: 16 Memory Usage: 15501kB
4. 2,332.575 2,332.575 ↑ 1.0 5,276,076 1

Seq Scan on subscription s (cost=0.00..207,977.60 rows=5,284,488 width=16) (actual time=0.010..2,332.575 rows=5,276,076 loops=1)

  • Filter: ((NOT is_test) AND (status <> 1))
  • Rows Removed by Filter: 9315
Planning time : 4.241 ms
Execution time : 84,532.507 ms