explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4IQ1

Settings
# exclusive inclusive rows x rows loops node
1. 0.059 233.516 ↑ 1.0 1 1

Aggregate (cost=17,818.61..17,818.62 rows=1 width=32) (actual time=233.516..233.516 rows=1 loops=1)

2. 0.084 233.457 ↑ 1.0 10 1

Limit (cost=15,780.45..17,818.48 rows=10 width=13) (actual time=139.696..233.457 rows=10 loops=1)

3. 0.042 233.373 ↑ 14.9 10 1

Nested Loop Left Join (cost=15,780.45..46,147.13 rows=149 width=13) (actual time=139.695..233.373 rows=10 loops=1)

4. 17.130 233.101 ↑ 14.9 10 1

Hash Join (cost=15,780.16..45,336.41 rows=149 width=13) (actual time=139.667..233.101 rows=10 loops=1)

  • Hash Cond: (c.phone_id = p.id)
5. 76.438 76.438 ↑ 3.0 157,538 1

Seq Scan on client c (cost=0.00..28,332.37 rows=466,237 width=48) (actual time=0.006..76.438 rows=157,538 loops=1)

6. 0.000 139.533 ↑ 4.4 66 1

Hash (cost=15,776.54..15,776.54 rows=289 width=17) (actual time=139.533..139.533 rows=66 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
7. 4.027 139.580 ↑ 4.4 66 1

Gather (cost=1,000.00..15,776.54 rows=289 width=17) (actual time=21.782..139.580 rows=66 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
8. 135.553 135.553 ↑ 5.5 22 3

Parallel Seq Scan on client_phone p (cost=0.00..14,747.64 rows=120 width=17) (actual time=12.180..135.553 rows=22 loops=3)

  • Filter: (lower(main) ~~ '%093721%'::text)
  • Rows Removed by Filter: 300652
9. 0.230 0.230 ↓ 0.0 0 10

Index Scan using scoring_telephone_blocking_tel_index on scoring_telephone_blocking sbtel (cost=0.29..5.43 rows=1 width=14) (actual time=0.023..0.023 rows=0 loops=10)

  • Index Cond: (tel = p.main)
  • Filter: (scoring_telephone_blocking_type_id = 1)
  • Rows Removed by Filter: 0
Planning time : 2.957 ms
Execution time : 233.584 ms