explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LA0y

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.004 ↓ 0.0 0 1

Index Scan using ixpi_userid_entrydate2userid on payableitem payableitem0 (cost=0.27..2.30 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((userid = 2) AND (entrydate >= '2019-10-04'::date) AND (entrydate <= '2019-10-04'::date))
  • Filter: (upper(originuri) ~~ 'URN:REPLICON-TENANT:328534EA1C3B4E2C9A68936B8E7D700B:TIMESHEET:%'::text)
  • Buffers: shared hit=2
Planning time : 0.349 ms
Execution time : 0.019 ms