explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XBHO

Settings
# exclusive inclusive rows x rows loops node
1. 3,624.328 3,624.328 ↓ 0.0 0 1

Seq Scan on payment_payment (cost=0.00..841,717.58 rows=1 width=2,048) (actual time=3,624.328..3,624.328 rows=0 loops=1)

  • Filter: ((tenant_id = 101) AND (created_user_id = 101) AND (location_id = 101) AND (posting_date = '2019-05-10 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 4916085
Planning time : 0.167 ms
Execution time : 3,624.383 ms