explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qRCy

Settings
# exclusive inclusive rows x rows loops node
1. 0.170 16.066 ↑ 1.0 1 1

Aggregate (cost=2,358.51..2,358.52 rows=1 width=8) (actual time=16.066..16.066 rows=1 loops=1)

2. 2.048 15.896 ↓ 1,250.0 1,250 1

Nested Loop Semi Join (cost=0.85..2,358.51 rows=1 width=0) (actual time=0.049..15.896 rows=1,250 loops=1)

3. 2.104 2.104 ↓ 12.7 1,468 1

Index Scan using items_164_table_id_created_by_id_idx on items_164 items (cost=0.42..346.30 rows=116 width=8) (actual time=0.019..2.104 rows=1,468 loops=1)

  • Index Cond: ((table_id = '2100000012668564'::bigint) AND (created_by_id = '2424388'::bigint))
  • Filter: (deleted_on IS NULL)
4. 11.744 11.744 ↑ 1.0 1 1,468

Index Scan using item_texts_164_unique_idx on item_texts_164 (cost=0.43..17.20 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=1,468)

  • Index Cond: ((table_id = '2100000012668564'::bigint) AND (field_id = ANY ('{2200000124712994,2200000124712999,2200000124716207}'::bigint[])) AND (item_id = items.item_id))
  • Filter: (value ~~* '%3%'::text)
  • Rows Removed by Filter: 2
Planning time : 1.643 ms
Execution time : 16.108 ms