explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EOoW

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 18,662.496 ↑ 1.0 10 1

Limit (cost=0.00..5.97 rows=10 width=228) (actual time=18,662.461..18,662.496 rows=10 loops=1)

2. 0.004 18,662.492 ↑ 34,550.3 10 1

Append (cost=0.00..206,197.84 rows=345,503 width=228) (actual time=18,662.459..18,662.492 rows=10 loops=1)

3. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on p_inbox (cost=0.00..0.00 rows=1 width=421) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ((datarilev > '2017-02-02'::date) AND (datarilev < '2017-02-03'::date))
4. 19.589 18,662.488 ↑ 34,550.2 10 1

Bitmap Heap Scan on p_inbox_201702 (cost=8,529.83..206,197.84 rows=345,502 width=228) (actual time=18,662.457..18,662.488 rows=10 loops=1)

  • Recheck Cond: ((datarilev > '2017-02-02'::date) AND (datarilev < '2017-02-03'::date))
  • Heap Blocks: exact=1
5. 18,642.899 18,642.899 ↑ 1.0 344,185 1

Bitmap Index Scan on p_inbox_201702_darilev (cost=0.00..8,443.45 rows=345,502 width=0) (actual time=18,642.899..18,642.899 rows=344,185 loops=1)

  • Index Cond: ((datarilev > '2017-02-02'::date) AND (datarilev < '2017-02-03'::date))
Planning time : 0.892 ms
Execution time : 18,662.553 ms