explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aZ9D

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.242 ↑ 31.6 10 1

Bitmap Heap Scan on servicedelivery_idx (cost=166.45..1,444.40 rows=316 width=547) (actual time=0.241..0.242 rows=10 loops=1)

  • Recheck Cond: (xgap.servicedelivery_by_person_handle_fn(payload) && '{CRS_NAMED_PERSON_37_115791,CRS_NAMED_PERSON_37_112149,CRS_NAMED_PERSON_37_111449,CRS_NAMED_PERSON_37_110714,CRS_NAMED_PERSON_37_111519,CRS_NAMED_PERSON_37_112860,CRS_NAMED_PERSON_37_110357,CRS_NAMED_PERSON_37_110795,CRS_NAMED_PERSON_37_115034,CRS_NAMED_PERSON_37_112153}'::text[])
  • Heap Blocks: exact=1
2. 0.237 0.237 ↑ 31.6 10 1

Bitmap Index Scan on servicedelivery_by_person_handle_fngin_idx (cost=0.00..166.37 rows=316 width=0) (actual time=0.237..0.237 rows=10 loops=1)

  • Index Cond: (xgap.servicedelivery_by_person_handle_fn(payload) && '{CRS_NAMED_PERSON_37_115791,CRS_NAMED_PERSON_37_112149,CRS_NAMED_PERSON_37_111449,CRS_NAMED_PERSON_37_110714,CRS_NAMED_PERSON_37_111519,CRS_NAMED_PERSON_37_112860,CRS_NAMED_PERSON_37_110357,CRS_NAMED_PERSON_37_110795,CRS_NAMED_PERSON_37_115034,CRS_NAMED_PERSON_37_112153}'::text[])