explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fDqc

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 5,447.670 ↓ 0.0 0 1

Limit (cost=0.00..121,806.79 rows=10 width=465) (actual time=5,447.670..5,447.670 rows=0 loops=1)

2. 5,447.668 5,447.668 ↓ 0.0 0 1

Seq Scan on shopify_change_requests (cost=0.00..864,828.24 rows=71 width=465) (actual time=5,447.668..5,447.668 rows=0 loops=1)

  • Filter: (((action)::text = 'remove-and-append-tags'::text) AND ((field)::text = 'tags'::text) AND ((new_value -> 'append'::text) ? 'PTPA'::text) AND (created_at > (('now'::cstring)::date - 10)))
  • Rows Removed by Filter: 8,861,078
Planning time : 0.146 ms
Execution time : 5,447.698 ms