explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dKTi

Settings
# exclusive inclusive rows x rows loops node
1. 1.523 1,479.034 ↑ 13.2 3,873 1

Sort (cost=188,067.31..188,195.57 rows=51,307 width=48) (actual time=1,478.902..1,479.034 rows=3,873 loops=1)

  • Sort Key: (count(*)) DESC
  • Sort Method: quicksort Memory: 434kB
2. 139.654 1,477.511 ↑ 13.2 3,873 1

GroupAggregate (cost=167,910.38..184,053.34 rows=51,307 width=48) (actual time=1,330.647..1,477.511 rows=3,873 loops=1)

  • Group Key: (nimble_contact_value_normalize(CASE WHEN (length(value) < 1024) THEN value ELSE NULL::text END))
  • Filter: (count(*) > 2)
  • Rows Removed by Filter: 42,074
3. 101.683 1,337.857 ↑ 1.4 141,395 1

Sort (cost=167,910.38..168,419.70 rows=203,728 width=45) (actual time=1,330.589..1,337.857 rows=141,395 loops=1)

  • Sort Key: (nimble_contact_value_normalize(CASE WHEN (length(value) < 1024) THEN value ELSE NULL::text END))
  • Sort Method: quicksort Memory: 18,558kB
4. 1,236.174 1,236.174 ↑ 1.4 141,395 1

Index Scan using ix_contacts_values_value__norm on contacts_values (cost=0.69..149,945.36 rows=203,728 width=45) (actual time=0.179..1,236.174 rows=141,395 loops=1)

  • Index Cond: ((company_id = '\x4c2118ad54397f271b000000'::bytea) AND (field_name = 'title'::text) AND (field_id = '\x000000000000000000000000'::bytea))
Planning time : 0.210 ms
Execution time : 1,483.752 ms