explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Oapk

Settings
# exclusive inclusive rows x rows loops node
1. 1,015.695 14,498.753 ↑ 5.8 1,900,723 1

WindowAgg (cost=34,264,292.47..34,593,939.22 rows=10,988,225 width=49) (actual time=13,186.898..14,498.753 rows=1,900,723 loops=1)

2. 10,031.658 13,483.058 ↑ 5.8 1,900,723 1

Sort (cost=34,264,292.47..34,291,763.03 rows=10,988,225 width=49) (actual time=13,186.886..13,483.058 rows=1,900,723 loops=1)

  • Sort Key: (((split_part((uuid)::text, '_'::text, 1) || '_'::text) || split_part((uuid)::text, '_'::text, 2))), "timestamp
  • Sort Method: quicksort Memory: 352628kB
3. 2,664.530 3,451.400 ↑ 5.8 1,900,723 1

Bitmap Heap Scan on billings (cost=405,349.89..32,603,674.99 rows=10,988,225 width=49) (actual time=826.830..3,451.400 rows=1,900,723 loops=1)

  • Recheck Cond: (("timestamp" >= '2018-11-14 00:00:00'::timestamp without time zone) AND ("timestamp" < '2018-11-14 08:00:00'::timestamp without time zone))
  • Heap Blocks: exact=113020
4. 786.870 786.870 ↑ 3.0 3,613,654 1

Bitmap Index Scan on idx_billing_timestamp (cost=0.00..402,602.83 rows=10,988,225 width=0) (actual time=786.870..786.870 rows=3,613,654 loops=1)

  • Index Cond: (("timestamp" >= '2018-11-14 00:00:00'::timestamp without time zone) AND ("timestamp" < '2018-11-14 08:00:00'::timestamp without time zone))