explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Zhgh

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 2,169.357 ↓ 0.0 0 1

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

2. 0.001 2,169.355 ↓ 0.0 0 1

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

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

Seq Scan on users (cost=0.00..101,119.92 rows=1 width=4) (actual time=2,169.354..2,169.354 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: 1508675
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 : 1.683 ms
Execution time : 2,169.397 ms