explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SlPs : Optimization for: plan #BUEI

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.011 622.126 ↓ 7.3 182 1

Limit (cost=74,588.38..74,588.45 rows=25 width=12) (actual time=622.108..622.126 rows=182 loops=1)

2. 0.138 622.115 ↓ 7.3 182 1

Sort (cost=74,588.38..74,588.45 rows=25 width=12) (actual time=622.106..622.115 rows=182 loops=1)

  • Sort Key: cosignatur0_.datebegin
  • Sort Method: quicksort Memory: 33kB
3. 0.155 621.977 ↓ 7.3 182 1

Group (cost=2.41..74,587.8 rows=25 width=12) (actual time=5.777..621.977 rows=182 loops=1)

4. 4.981 621.822 ↓ 9.8 244 1

Nested Loop (cost=2.41..74,587.74 rows=25 width=12) (actual time=5.775..621.822 rows=244 loops=1)

  • Filter: ((lower((cosignerco1_.mail)::text) ~~ '%dart%'::text) OR ((cosignerco1_.phone)::text ~~ '%dart%'::text) OR (lower((cosignerco1_.firstname)::text) ~~ '%dart%'::text) OR (lower((cosignerco1_.lastname)::text) ~~ '%dart%'::text) OR (lower((((cosignerco1_.firstname)::text || ' '::text) || (cosignerco1_.lastname)::text)) ~~ '%dart%'::text) OR (lower((file3_.name)::text) ~~ '%dart%'::text) OR (lower((token4_.token)::text) ~~ '%dart%'::text))
5. 0.000 612.326 ↓ 2.8 1,505 1

Nested Loop (cost=1.98..74,265.49 rows=536 width=106) (actual time=5.587..612.326 rows=1,505 loops=1)

6. 1.244 608.254 ↓ 3.4 1,375 1

Nested Loop (cost=1.56..74,040.76 rows=402 width=102) (actual time=5.562..608.254 rows=1,375 loops=1)

7. 263.397 602.885 ↓ 3.4 1,375 1

Merge Join (cost=1.13..73,828.65 rows=403 width=66) (actual time=5.507..602.885 rows=1,375 loops=1)

8. 153.244 153.244 ↓ 1.0 626,933 1

Index Scan using cosignatureevent_pkey on cosignatureevent cosignatur0_ (cost=0.42..25,248.8 rows=625,476 width=16) (actual time=0.004..153.244 rows=626,933 loops=1)

9. 186.244 186.244 ↓ 1.0 762,564 1

Index Scan using cosigner_idx_cosignature_event on cosigner cosignerco1_ (cost=0.42..34,020.65 rows=762,043 width=62) (actual time=0.003..186.244 rows=762,564 loops=1)

10. 4.125 4.125 ↑ 1.0 1 1,375

Index Scan using token_pkey on token token4_ (cost=0.42..0.52 rows=1 width=44) (actual time=0.003..0.003 rows=1 loops=1,375)

  • Index Cond: (id = cosignerco1_.token)
11. 4.125 4.125 ↑ 3.0 1 1,375

Index Scan using cosignaturefile_idx_cosignatureevent on cosignaturefile cosignatur2_ (cost=0.42..0.53 rows=3 width=8) (actual time=0.002..0.003 rows=1 loops=1,375)

  • Index Cond: (cosignatur0_.id = cosignatureevent)
12. 4.515 4.515 ↑ 1.0 1 1,505

Index Scan using file_pkey on file file3_ (cost=0.42..0.55 rows=1 width=30) (actual time=0.003..0.003 rows=1 loops=1,505)

  • Index Cond: (cosignatur2_.file = id)
Planning time : 1.829 ms
Execution time : 622.258 ms