explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X3vL

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

Unique (cost=11.11..11.12 rows=1 width=16) (actual time=0.036..0.036 rows=0 loops=1)

  • Buffers: shared hit=1
2. 0.010 0.036 ↓ 0.0 0 1

Sort (cost=11.11..11.12 rows=1 width=16) (actual time=0.036..0.036 rows=0 loops=1)

  • Sort Key: offer_id, created DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
3. 0.026 0.026 ↓ 0.0 0 1

Seq Scan on mfi_redirect (cost=0.00..11.10 rows=1 width=16) (actual time=0.026..0.026 rows=0 loops=1)

  • Filter: ((created >= '2019-08-09 13:06:05.825723+00'::timestamp with time zone) AND (cookie_session_str = '4f1o58ala4btmhg1zbcv9g4xzu9u6yz5'::text) AND (offer_id = ANY ('{2002177,2001672,2001419,2002188,2002065,2000915,2000918,2002075,2002077 (...)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=1
Planning time : 0.335 ms
Execution time : 0.073 ms