explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eK6

Settings
# exclusive inclusive rows x rows loops node
1. 2.358 95,182.186 ↑ 1.0 1 1

Aggregate (cost=25.79..25.80 rows=1 width=8) (actual time=95,182.186..95,182.186 rows=1 loops=1)

2. 3,143.902 95,179.828 ↓ 1,249.0 1,249 1

Nested Loop Semi Join (cost=0.85..25.79 rows=1 width=0) (actual time=53.175..95,179.828 rows=1,249 loops=1)

  • Join Filter: (items.item_id = item_texts_164.item_id)
  • Rows Removed by Join Filter: 24,033,033
3. 13.950 13.950 ↓ 1,467.0 1,467 1

Index Scan using items_164_table_id_created_by_id_idx on items_164 items (cost=0.42..8.44 rows=1 width=8) (actual time=0.067..13.950 rows=1,467 loops=1)

  • Index Cond: ((table_id = '2100000012668564'::bigint) AND (created_by_id = '2424388'::bigint))
  • Filter: (deleted_on IS NULL)
4. 92,021.976 92,021.976 ↓ 16,383.0 16,383 1,467

Index Scan using item_texts_164_unique_idx on item_texts_164 (cost=0.43..17.33 rows=1 width=8) (actual time=0.018..62.728 rows=16,383 loops=1,467)

  • Index Cond: ((table_id = '2100000012668564'::bigint) AND (field_id = ANY ('{2200000124712994,2200000124712999,2200000124716207}'::bigint[])))
  • Filter: (value ~~* '%3%'::text)
  • Rows Removed by Filter: 37,104
Planning time : 2.320 ms
Execution time : 95,182.238 ms