explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rwPO

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=96,048,151.32..96,466,390.93 rows=1 width=16) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=96,048,151.32..96,466,390.93 rows=1 width=16) (actual rows= loops=)

  • Join Filter: (kraken_activity_entry.prey_id = propertysource.site_entry_identifier)
3. 0.000 0.000 ↓ 0.0

Sort (cost=96,048,151.32..96,048,151.33 rows=1 width=24) (actual rows= loops=)

  • Sort Key: (min(kraken_activity_entry.end_time))
4. 0.000 0.000 ↓ 0.0

HashAggregate (cost=96,048,151.30..96,048,151.31 rows=1 width=24) (actual rows= loops=)

  • Group Key: kraken_activity_entry.prey_id
5. 0.000 0.000 ↓ 0.0

Nested Loop Anti Join (cost=0.57..96,048,151.30 rows=1 width=24) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on kraken_activity_entry (cost=0.00..11,710,911.40 rows=143,568,331 width=24) (actual rows= loops=)

  • Filter: (last_status = 0)
7. 0.000 0.000 ↓ 0.0

Index Only Scan using prey_id_last_status on kraken_activity_entry k (cost=0.57..3.12 rows=6 width=16) (actual rows= loops=)

  • Index Cond: ((prey_id = kraken_activity_entry.prey_id) AND (last_status = ANY ('{2,5,3}'::integer[])))
8. 0.000 0.000 ↓ 0.0

Seq Scan on propertysource (cost=0.00..385,748.78 rows=2,599,265 width=16) (actual rows= loops=)

  • Filter: (socialmediasource = ANY ('{0,1,2,3,4,5,7,14,17,18,19,20,21,22,23,24,25,27,28,30,31,36,37,38,40}'::integer[]))