explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b5AO

Settings
# exclusive inclusive rows x rows loops node
1. 0.032 708.874 ↑ 1.0 1 1

Aggregate (cost=20,783.70..20,783.71 rows=1 width=32) (actual time=708.873..708.874 rows=1 loops=1)

2. 0.003 708.842 ↑ 10.0 1 1

Limit (cost=16,564.36..20,783.57 rows=10 width=13) (actual time=532.594..708.842 rows=1 loops=1)

3. 0.015 708.839 ↑ 48.0 1 1

Nested Loop Left Join (cost=16,564.36..36,816.56 rows=48 width=13) (actual time=532.592..708.839 rows=1 loops=1)

4. 130.427 708.797 ↑ 48.0 1 1

Hash Join (cost=16,563.95..36,621.78 rows=48 width=13) (actual time=532.552..708.797 rows=1 loops=1)

  • Hash Cond: (c.phone_id = p.id)
5. 125.985 125.985 ↓ 1.0 482,749 1

Seq Scan on client c (cost=0.00..18,792.66 rows=481,966 width=48) (actual time=0.007..125.985 rows=482,749 loops=1)

6. 0.000 452.385 ↑ 46.5 2 1

Hash (cost=16,562.79..16,562.79 rows=93 width=17) (actual time=452.385..452.385 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 12.001 452.480 ↑ 46.5 2 1

Gather (cost=1,000.00..16,562.79 rows=93 width=17) (actual time=451.473..452.480 rows=2 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
8. 440.479 440.479 ↑ 39.0 1 3

Parallel Seq Scan on client_phone p (cost=0.00..15,553.49 rows=39 width=17) (actual time=440.378..440.479 rows=1 loops=3)

  • Filter: (lower(main) ~~ '%+380931355176%'::text)
  • Rows Removed by Filter: 310799
9. 0.027 0.027 ↓ 0.0 0 1

Index Only Scan using scoring_telephone_blocking_tel_scoring_telephone_blocking_t_key on scoring_telephone_blocking sbtel (cost=0.41..4.05 rows=1 width=13) (actual time=0.027..0.027 rows=0 loops=1)

  • Index Cond: ((tel = p.main) AND (scoring_telephone_blocking_type_id = 1))
  • Heap Fetches: 0
Planning time : 3.720 ms
Execution time : 709.055 ms