explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DiiN

Settings
# exclusive inclusive rows x rows loops node
1. 0.459 0.494 ↑ 1.1 40 1

Bitmap Heap Scan on times (cost=4.87..127.48 rows=46 width=75) (actual time=0.051..0.494 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. 0.035 0.035 ↑ 1.1 40 1

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

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