explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KoqN

Settings
# exclusive inclusive rows x rows loops node
1. 0.232 0.326 ↑ 97.4 178 1

Bitmap Heap Scan on cities_unrestricted_points (cost=495.42..68,117.05 rows=17,343 width=26) (actual time=0.114..0.326 rows=178 loops=1)

  • Recheck Cond: ((edge_id = ANY ('{9008633862306576,9008633862306550,140060152343226615,9008633773968080}'::bigint[])) AND ("timestamp" >= 1,569,801,600) AND ("timestamp" <= 1,569,888,000))
  • Heap Blocks: exact=80
2. 0.094 0.094 ↑ 97.4 178 1

Bitmap Index Scan on edge_id_timestamp (cost=0.00..491.08 rows=17,343 width=0) (actual time=0.094..0.094 rows=178 loops=1)

  • Index Cond: ((edge_id = ANY ('{9008633862306576,9008633862306550,140060152343226615,9008633773968080}'::bigint[])) AND ("timestamp" >= 1,569,801,600) AND ("timestamp" <= 1,569,888,000))