explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QAkV : before index on start meet

Settings
# exclusive inclusive rows x rows loops node
1. 9.765 11.985 ↑ 1.1 40 1

Bitmap Heap Scan on times (cost=4.87..127.48 rows=46 width=75) (actual time=2.993..11.985 rows=40 loops=1)

  • Recheck Cond: ((host = '100c899e-d945-4bfc-95ef-891587ae686b'::uuid) AND (start >= '1567980000000'::bigint) AND (start <= '1568584800000'::bigint))
  • Heap Blocks: exact=24
2. 2.220 2.220 ↑ 1.1 40 1

Bitmap Index Scan on times_pkey (cost=0.00..4.86 rows=46 width=0) (actual time=2.212..2.220 rows=40 loops=1)

  • Index Cond: ((host = '100c899e-d945-4bfc-95ef-891587ae686b'::uuid) AND (start >= '1567980000000'::bigint) AND (start <= '1568584800000'::bigint))
Planning time : 11.901 ms
Execution time : 14.730 ms