explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mulN

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 45,155.667 ↓ 0.0 0 1

Nested Loop (cost=1.59..621,465.96 rows=236 width=182) (actual time=45,155.666..45,155.667 rows=0 loops=1)

2. 0.001 45,155.665 ↓ 0.0 0 1

Nested Loop (cost=1.15..620,069.05 rows=236 width=174) (actual time=45,155.664..45,155.665 rows=0 loops=1)

  • Join Filter: ((((genericnod2_.pathtoparent)::text || (subscriber0_.node_id)::text) || ':'::text) ~~ (((genericnod3_.pathtoparent)::text || (user1_.homenode_id)::text) || ':%'::text))
3. 0.004 45,155.664 ↓ 0.0 0 1

Nested Loop (cost=0.72..391,880.89 rows=47,105 width=209) (actual time=45,155.664..45,155.664 rows=0 loops=1)

4. 0.003 0.112 ↑ 1.0 1 1

Nested Loop (cost=0.72..16.77 rows=1 width=35) (actual time=0.107..0.112 rows=1 loops=1)

5. 0.066 0.066 ↑ 1.0 1 1

Index Scan using tuser_pkey on tuser user1_ (cost=0.29..8.31 rows=1 width=8) (actual time=0.064..0.066 rows=1 loops=1)

  • Index Cond: (id = '333156'::bigint)
6. 0.043 0.043 ↑ 1.0 1 1

Index Scan using tgenericnode_pkey on tgenericnode genericnod3_ (cost=0.43..8.45 rows=1 width=35) (actual time=0.039..0.043 rows=1 loops=1)

  • Index Cond: (id = user1_.homenode_id)
7. 45,155.548 45,155.548 ↓ 0.0 0 1

Seq Scan on tsubscriber subscriber0_ (cost=0.00..391,393.07 rows=47,105 width=174) (actual time=45,155.548..45,155.548 rows=0 loops=1)

  • Filter: (lower((emailaddress)::text) ~~ 'vanessa@alivetherapy.co.uk%'::text)
  • Rows Removed by Filter: 9,432,757
8. 0.000 0.000 ↓ 0.0 0

Index Scan using tgenericnode_pkey on tgenericnode genericnod2_ (cost=0.43..4.81 rows=1 width=35) (never executed)

  • Index Cond: (id = subscriber0_.node_id)
9. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_tbasesubscriber on tbasesubscriber subscriber0_1_ (cost=0.43..5.91 rows=1 width=16) (never executed)

  • Index Cond: (id = subscriber0_.id)
Planning time : 25.506 ms
Execution time : 45,155.825 ms