explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Nsk2

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.180 ↑ 31.6 10 1

Bitmap Heap Scan on servicedelivery_idx (cost=203.16..2,199.22 rows=316 width=547) (actual time=0.179..0.180 rows=10 loops=1)

  • Recheck Cond: ((xgap.servicedelivery_by_person_handle_fn(payload) @> '{CRS_NAMED_PERSON_37_115791}'::text[]) OR (xgap.servicedelivery_by_person_handle_fn(payload) @> '{CRS_NAMED_PERSON_37_112149}'::text[]) OR (xgap.servicedelivery_by_person_handle_fn(payload) @> '{CRS_NAMED_PERSON_37_111449}'::text[]) OR (xgap.servicedelivery_by_person_handle_fn(payload) @> '{CRS_NAMED_PERSON_37_110714}'::text[]) OR (xgap.servicedelivery_by_person_handle_fn(payload) @> '{CRS_NAMED_PERSON_37_111519}'::text[]) OR (xgap.servicedelivery_by_person_handle_fn(payload) @> '{CRS_NAMED_PERSON_37_112860}'::text[]) OR (xgap.servicedelivery_by_person_handle_fn(payload) @> '{CRS_NAMED_PERSON_37_110357}'::text[]) OR (xgap.servicedelivery_by_person_handle_fn(payload) @> '{CRS_NAMED_PERSON_37_110795}'::text[]) OR (xgap.servicedelivery_by_person_handle_fn(payload) @> '{CRS_NAMED_PERSON_37_115034}'::text[]) OR (xgap.servicedelivery_by_person_handle_fn(payload) @> '{CRS_NAMED_PERSON_37_112153}'::text[]))
  • Heap Blocks: exact=1
2. 0.001 0.176 ↓ 0.0 0 1

BitmapOr (cost=203.16..203.16 rows=316 width=0) (actual time=0.176..0.176 rows=0 loops=1)

3. 0.025 0.025 ↑ 32.0 1 1

Bitmap Index Scan on servicedelivery_by_person_handle_fngin_idx (cost=0.00..20.24 rows=32 width=0) (actual time=0.025..0.025 rows=1 loops=1)

  • Index Cond: (xgap.servicedelivery_by_person_handle_fn(payload) @> '{CRS_NAMED_PERSON_37_115791}'::text[])
4. 0.017 0.017 ↑ 32.0 1 1

Bitmap Index Scan on servicedelivery_by_person_handle_fngin_idx (cost=0.00..20.24 rows=32 width=0) (actual time=0.017..0.017 rows=1 loops=1)

  • Index Cond: (xgap.servicedelivery_by_person_handle_fn(payload) @> '{CRS_NAMED_PERSON_37_112149}'::text[])
5. 0.018 0.018 ↑ 32.0 1 1

Bitmap Index Scan on servicedelivery_by_person_handle_fngin_idx (cost=0.00..20.24 rows=32 width=0) (actual time=0.018..0.018 rows=1 loops=1)

  • Index Cond: (xgap.servicedelivery_by_person_handle_fn(payload) @> '{CRS_NAMED_PERSON_37_111449}'::text[])
6. 0.015 0.015 ↑ 32.0 1 1

Bitmap Index Scan on servicedelivery_by_person_handle_fngin_idx (cost=0.00..20.24 rows=32 width=0) (actual time=0.015..0.015 rows=1 loops=1)

  • Index Cond: (xgap.servicedelivery_by_person_handle_fn(payload) @> '{CRS_NAMED_PERSON_37_110714}'::text[])
7. 0.016 0.016 ↑ 32.0 1 1

Bitmap Index Scan on servicedelivery_by_person_handle_fngin_idx (cost=0.00..20.24 rows=32 width=0) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: (xgap.servicedelivery_by_person_handle_fn(payload) @> '{CRS_NAMED_PERSON_37_111519}'::text[])
8. 0.017 0.017 ↑ 32.0 1 1

Bitmap Index Scan on servicedelivery_by_person_handle_fngin_idx (cost=0.00..20.24 rows=32 width=0) (actual time=0.017..0.017 rows=1 loops=1)

  • Index Cond: (xgap.servicedelivery_by_person_handle_fn(payload) @> '{CRS_NAMED_PERSON_37_112860}'::text[])
9. 0.017 0.017 ↑ 32.0 1 1

Bitmap Index Scan on servicedelivery_by_person_handle_fngin_idx (cost=0.00..20.24 rows=32 width=0) (actual time=0.016..0.017 rows=1 loops=1)

  • Index Cond: (xgap.servicedelivery_by_person_handle_fn(payload) @> '{CRS_NAMED_PERSON_37_110357}'::text[])
10. 0.017 0.017 ↑ 32.0 1 1

Bitmap Index Scan on servicedelivery_by_person_handle_fngin_idx (cost=0.00..20.24 rows=32 width=0) (actual time=0.017..0.017 rows=1 loops=1)

  • Index Cond: (xgap.servicedelivery_by_person_handle_fn(payload) @> '{CRS_NAMED_PERSON_37_110795}'::text[])
11. 0.017 0.017 ↑ 32.0 1 1

Bitmap Index Scan on servicedelivery_by_person_handle_fngin_idx (cost=0.00..20.24 rows=32 width=0) (actual time=0.017..0.017 rows=1 loops=1)

  • Index Cond: (xgap.servicedelivery_by_person_handle_fn(payload) @> '{CRS_NAMED_PERSON_37_115034}'::text[])
12. 0.016 0.016 ↑ 32.0 1 1

Bitmap Index Scan on servicedelivery_by_person_handle_fngin_idx (cost=0.00..20.24 rows=32 width=0) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: (xgap.servicedelivery_by_person_handle_fn(payload) @> '{CRS_NAMED_PERSON_37_112153}'::text[])