explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gSqP

Settings
# exclusive inclusive rows x rows loops node
1. 0.034 713.908 ↑ 1.0 1 1

Aggregate (cost=20,799.79..20,799.80 rows=1 width=32) (actual time=713.907..713.908 rows=1 loops=1)

2. 0.003 713.874 ↑ 10.0 1 1

Limit (cost=16,580.46..20,799.67 rows=10 width=13) (actual time=537.508..713.874 rows=1 loops=1)

3. 0.015 713.871 ↑ 48.0 1 1

Nested Loop Left Join (cost=16,580.46..36,832.65 rows=48 width=13) (actual time=537.507..713.871 rows=1 loops=1)

4. 130.377 713.824 ↑ 48.0 1 1

Hash Join (cost=16,580.04..36,637.88 rows=48 width=13) (actual time=537.461..713.824 rows=1 loops=1)

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

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

6. 0.000 457.012 ↑ 46.5 2 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 34.871 457.106 ↑ 46.5 2 1

Gather (cost=1,000.00..16,578.88 rows=93 width=17) (actual time=454.293..457.106 rows=2 loops=1)

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

Parallel Seq Scan on client_phone p (cost=0.00..15,569.58 rows=39 width=17) (actual time=421.333..422.235 rows=1 loops=3)

  • Filter: (lower(main) ~~ '%+380931355176%'::text)
  • Rows Removed by Filter: 310805
9. 0.032 0.032 ↓ 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.032..0.032 rows=0 loops=1)

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