explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fTMB

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

Nested Loop (cost=1.30..316.67 rows=1 width=7,593) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.73..100.68 rows=4 width=7,529) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Index Scan using contents_pkey on contents (cost=0.44..50.71 rows=6 width=7,529) (actual rows= loops=)

  • Index Cond: (id = ANY ('{20953573,20953574,20960321,21052819,21722815,21722816}'::integer[]))
  • Filter: (deleted_at IS NULL)
4. 0.000 0.000 ↓ 0.0

Index Scan using container_types_pkey on container_types (cost=0.29..8.32 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = contents.container_type_id)
  • Filter: ((height <= 14.25) AND (width <= 100.0))
5. 0.000 0.000 ↓ 0.0

Index Scan using index_content_translations_on_content_id on content_translations (cost=0.56..53.99 rows=1 width=64) (actual rows= loops=)

  • Index Cond: (content_id = contents.id)
  • Filter: ((deleted_at IS NULL) AND (deleted_at IS NULL) AND ((locale)::text = 'en'::text) AND (((contents.item_number)::text ~~* '%Blanks%'::text) OR ((name)::text ~~* '%Blanks%'::text)))