explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3rIl

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 2,376.831 ↓ 0.0 0 1

Limit (cost=0.00..101,300.31 rows=1 width=0) (actual time=2,376.831..2,376.831 rows=0 loops=1)

2. 0.002 2,376.830 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.00..101,300.31 rows=1 width=0) (actual time=2,376.830..2,376.830 rows=0 loops=1)

  • Join Filter: (user_cards.user_id = users.id)
3. 2,376.828 2,376.828 ↓ 0.0 0 1

Seq Scan on users (cost=0.00..101,119.92 rows=1 width=4) (actual time=2,376.828..2,376.828 rows=0 loops=1)

  • Filter: ((deleted_at IS NULL) AND basic_setup AND ((fname)::text ~~* '%Іванович%'::text) AND ((name)::text ~~* '%Іван%'::text) AND ((sname)::text ~~* '%Івановч%'::text) AND (gender = 1))
  • Rows Removed by Filter: 1508669
4. 0.000 0.000 ↓ 0.0 0

Seq Scan on user_cards (cost=0.00..106.84 rows=5,884 width=4) (never executed)

Planning time : 2.047 ms
Execution time : 2,376.888 ms