explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1Wsv

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 20,161.842 ↓ 6.0 6 1

Limit (cost=20.54..20.55 rows=1 width=1,250) (actual time=20,161.840..20,161.842 rows=6 loops=1)

2. 1.101 20,161.837 ↓ 6.0 6 1

Sort (cost=20.54..20.55 rows=1 width=1,250) (actual time=20,161.836..20,161.837 rows=6 loops=1)

  • Sort Key: objects_object.created DESC, objects_object.id
  • Sort Method: top-N heapsort Memory: 31kB
3. 2.608 20,160.736 ↓ 1,327.0 1,327 1

Nested Loop (cost=14.76..20.53 rows=1 width=1,250) (actual time=14.545..20,160.736 rows=1,327 loops=1)

  • Join Filter: (objects_object.collection_id = objects_collection.id)
4. 20,141.302 20,154.147 ↓ 1,327.0 1,327 1

Bitmap Heap Scan on objects_object (cost=14.76..18.79 rows=1 width=1,250) (actual time=14.527..20,154.147 rows=1,327 loops=1)

  • Recheck Cond: ((data ? 'action_id'::text) AND (data ? 'user_id'::text))
  • Filter: (((data ->> 'user_id'::text) = '8631c7d2-8943-4913-bf84-e8bbaa795d1a'::text) AND ((data ->> 'action_id'::text) = ANY ('{3,7,8,9,10,11,12,13,14}'::text[])))
  • Rows Removed by Filter: 59863
  • Heap Blocks: exact=8233
5. 0.454 12.845 ↓ 0.0 0 1

BitmapAnd (cost=14.76..14.76 rows=1 width=0) (actual time=12.845..12.845 rows=0 loops=1)

6. 4.094 4.094 ↓ 339.9 61,190 1

Bitmap Index Scan on catasta_action_id_text_463aee70 (cost=0.00..5.19 rows=180 width=0) (actual time=4.094..4.094 rows=61,190 loops=1)

7. 8.297 8.297 ↓ 611.8 110,131 1

Bitmap Index Scan on catasta_user_id_text_0e157dcf (cost=0.00..9.32 rows=180 width=0) (actual time=8.297..8.297 rows=110,131 loops=1)

8. 3.981 3.981 ↑ 1.0 1 1,327

Seq Scan on objects_collection (cost=0.00..1.73 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=1,327)

  • Filter: ((name)::text = 'actions'::text)
  • Rows Removed by Filter: 24