explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BsU7

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 0.065 ↓ 1.8 9 1

Sort (cost=4.61..4.62 rows=5 width=745) (actual time=0.064..0.065 rows=9 loops=1)

  • Sort Key: deleted DESC, contact_id
  • Sort Method: quicksort Memory: 36kB
2. 0.046 0.046 ↓ 1.8 9 1

Index Scan using ix_company_id_op_id_contact_type on contacts_trashbin (cost=0.29..4.55 rows=5 width=745) (actual time=0.034..0.046 rows=9 loops=1)

  • Index Cond: ((company_id = '\x5cd25b986a8da2a1e420fbc4'::bytea) AND (op_id = '\x000000000000000000000000'::bytea))
  • Filter: (((deleted = '2021-06-10 15:43:26.049+00'::timestamp with time zone) AND (contact_id >= '\x5ecba587f92ea10bb4d78e88'::bytea)) OR (deleted < '2021-06-10 15:43:26.049+00'::timestamp with time zone))
Planning time : 0.692 ms
Execution time : 0.113 ms