explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TZXC : order by start

Settings
# exclusive inclusive rows x rows loops node
1. 3.353 3.831 ↑ 1.1 40 1

Sort (cost=128.75..128.87 rows=46 width=75) (actual time=3.471..3.831 rows=40 loops=1)

  • Sort Key: start
  • Sort Method: quicksort Memory: 30kB
2. 0.447 0.478 ↑ 1.1 40 1

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

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

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