explain.depesz.com

PostgreSQL's explain analyze made readable

Result: afas

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 2.586 ↓ 0.0 0 1

GroupAggregate (cost=7.82..7.86 rows=1 width=141) (actual time=2.586..2.586 rows=0 loops=1)

  • Group Key: id
2. 0.057 2.584 ↓ 0.0 0 1

Sort (cost=7.82..7.83 rows=1 width=61) (actual time=2.584..2.584 rows=0 loops=1)

  • Sort Key: id
  • Sort Method: quicksort Memory: 25kB
3. 2.527 2.527 ↓ 0.0 0 1

Index Scan using contacts_values_pkey on contacts_values (cost=0.56..7.81 rows=1 width=61) (actual time=2.527..2.527 rows=0 loops=1)

  • Index Cond: ((company_id = '\x4c2118ad54397f271b000000'::bytea) AND (id = ANY ('{"\\x5924d57d3693704775f96a42","\\x5924d5983693704775f96c66"}'::bytea[])) AND (field_id = '\x58d4116b58ac9c30cb7f7406'::bytea) AND (field_name = ANY ('{phone_other,first_name}'::text[])))
Planning time : 14.134 ms
Execution time : 2.778 ms