explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XeVU

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.006 ↑ 1.0 1 1

Aggregate (cost=4.20..4.21 rows=1 width=0) (actual time=0.006..0.006 rows=1 loops=1)

2. 0.004 0.004 ↓ 0.0 0 1

Index Only Scan using pr_data_ih_fact_idx2 on pr_data_ih_fact "PC0" (cost=0.14..4.19 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (pxoutcometime > '2020-08-21 17:35:19'::timestamp without time zone)
  • Heap Fetches: 0
Planning time : 0.110 ms
Execution time : 0.037 ms