explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EVV

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 122.377 ↓ 2.0 2 1

GroupAggregate (cost=10.33..10.36 rows=1 width=141) (actual time=122.373..122.377 rows=2 loops=1)

  • Group Key: id
2. 0.018 122.357 ↓ 2.0 2 1

Sort (cost=10.33..10.33 rows=1 width=61) (actual time=122.357..122.357 rows=2 loops=1)

  • Sort Key: id
  • Sort Method: quicksort Memory: 25kB
3. 0.010 122.339 ↓ 2.0 2 1

Bitmap Heap Scan on contacts_values (cost=9.20..10.32 rows=1 width=61) (actual time=122.336..122.339 rows=2 loops=1)

  • Recheck Cond: ((company_id = '\x4c2118ad54397f271b000000'::bytea) AND (field_name = ANY ('{phone_other,first_name,custom}'::text[])) AND (field_id = '\x58d4116b58ac9c30cb7f7406'::bytea) AND (id = ANY ('{"\\x5924d57d3693704775f96a42","\\x5924d5983693704775f96c66"}'::bytea[])))
  • Heap Blocks: exact=2
4. 122.329 122.329 ↓ 2.0 2 1

Bitmap Index Scan on ft_ix_contacts_values_value__tsv_gist (cost=0.00..9.20 rows=1 width=0) (actual time=122.328..122.329 rows=2 loops=1)

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