explain.depesz.com

PostgreSQL's explain analyze made readable

Result: u1rR

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 4.044 ↓ 0.0 0 1

GroupAggregate (cost=7.26..7.30 rows=1 width=141) (actual time=4.044..4.044 rows=0 loops=1)

  • Group Key: id
2. 0.046 4.043 ↓ 0.0 0 1

Sort (cost=7.26..7.27 rows=1 width=61) (actual time=4.043..4.043 rows=0 loops=1)

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

Bitmap Heap Scan on contacts_values (cost=6.13..7.25 rows=1 width=61) (actual time=3.997..3.997 rows=0 loops=1)

  • Recheck Cond: ((company_id = '\x4c2118ad54397f271b000000'::bytea) AND (field_name = ANY ('{phone_other,first_name}'::text[])) AND (field_id = '\x58d4116b58ac9c30cb7f7406'::bytea) AND (id = ANY ('{"\\x5924d57d3693704775f96a42","\\x5924d5983693704775f96c66"}'::bytea[])))
4. 3.988 3.988 ↓ 0.0 0 1

Bitmap Index Scan on ft_ix_contacts_values_value__tsv_gist (cost=0.00..6.13 rows=1 width=0) (actual time=3.987..3.988 rows=0 loops=1)

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