explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2g3S

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on webservice_baseproduct (cost=2,173.11..2,209.27 rows=9 width=931) (actual rows= loops=)

  • Recheck Cond: (((random_key)::text = ANY ('{37e6da6e-4236-4654-8d14-b150e351ace9,1cd3ba26-2ece-4e8d-a2db-ed3e285b5441,dcbb1d82-1b24-4bf9-a6f0-c5a0efc2e62a,646d9253-e0d9-4eef-bac8-c86a485cffc9,35a29caf-ff78-4041-b1c5-9232e59534df,0fda7f38-6a96-4016-aa57-00be49c2006b,ff71a406-28f2-450d-adad-2164fc80904d,5638eb63-2518-4fda-b10f-d2da8171966d,eb24d17d-9e39-4272-a28f-0d2fcb4d8bae}'::text[])) OR (random_keys @> '{37e6da6e-4236-4654-8d14-b150e351ace9,1cd3ba26-2ece-4e8d-a2db-ed3e285b5441,dcbb1d82-1b24-4bf9-a6f0-c5a0efc2e62a,646d9253-e0d9-4eef-bac8-c86a485cffc9,35a29caf-ff78-4041-b1c5-9232e59534df,0fda7f38-6a96-4016-aa57-00be49c2006b,ff71a406-28f2-450d-adad-2164fc80904d,0fda7f38-6a96-4016-aa57-00be49c2006b,5638eb63-2518-4fda-b10f-d2da8171966d,eb24d17d-9e39-4272-a28f-0d2fcb4d8bae}'::character varying(50)[]))
2. 0.000 0.000 ↓ 0.0

BitmapOr (cost=2,173.11..2,173.11 rows=9 width=0) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on webservice_baseproduct_random_key_key (cost=0.00..41.11 rows=9 width=0) (actual rows= loops=)

  • Index Cond: ((random_key)::text = ANY ('{37e6da6e-4236-4654-8d14-b150e351ace9,1cd3ba26-2ece-4e8d-a2db-ed3e285b5441,dcbb1d82-1b24-4bf9-a6f0-c5a0efc2e62a,646d9253-e0d9-4eef-bac8-c86a485cffc9,35a29caf-ff78-4041-b1c5-9232e59534df,0fda7f38-6a96-4016-aa57-00be49c2006b,ff71a406-28f2-450d-adad-2164fc80904d,5638eb63-2518-4fda-b10f-d2da8171966d,eb24d17d-9e39-4272-a28f-0d2fcb4d8bae}'::text[]))
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on webservice__random__3b4355_gin (cost=0.00..2,132.00 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (random_keys @> '{37e6da6e-4236-4654-8d14-b150e351ace9,1cd3ba26-2ece-4e8d-a2db-ed3e285b5441,dcbb1d82-1b24-4bf9-a6f0-c5a0efc2e62a,646d9253-e0d9-4eef-bac8-c86a485cffc9,35a29caf-ff78-4041-b1c5-9232e59534df,0fda7f38-6a96-4016-aa57-00be49c2006b,ff71a406-28f2-450d-adad-2164fc80904d,0fda7f38-6a96-4016-aa57-00be49c2006b,5638eb63-2518-4fda-b10f-d2da8171966d,eb24d17d-9e39-4272-a28f-0d2fcb4d8bae}'::character varying(50)[])