explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E0Zg

Settings
# exclusive inclusive rows x rows loops node
1. 214,774.166 214,774.166 ↑ 7.7 9 1

HashAggregate (cost=996,462.20..996,462.89 rows=69 width=45) (actual time=214,774.163..214,774.166 rows=9 loops=1)

  • Group Key: list_id
  • -> Bitmap Heap Scan on list_face (cost=372684.94..972214.88 rows=4849464 width=74) (actual time=209921.619..213384.010 rows=49721
  • Recheck Cond: ((list_id)::text = ANY ('{5f4b91e9-3b27-4e3a-9686-107cd3caf1cf,8182c394-c19e-445d-b2d2-08124d3d3695,b3453794-fd
  • Heap Blocks: exact=76745
  • -> Bitmap Index Scan on index_list_id_link_key (cost=0.00..371472.58 rows=4849464 width=0) (actual time=209888.830..209888.
  • Index Cond: ((list_id)::text = ANY ('{5f4b91e9-3b27-4e3a-9686-107cd3caf1cf,8182c394-c19e-445d-b2d2-08124d3d3695,b345379