explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CE4F

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 232.990 ↓ 10.0 10 1

Limit (cost=9.13..9.13 rows=1 width=566) (actual time=232.987..232.99 rows=10 loops=1)

  • Buffers: shared hit=63,049
2. 0.969 232.986 ↓ 10.0 10 1

Sort (cost=9.13..9.13 rows=1 width=566) (actual time=232.985..232.986 rows=10 loops=1)

  • Sort Key: "cdx_coll_a4f76899-34b7-4439-810b-98149dcb9ca7".date DESC
  • Sort Method: top-N heapsort Memory: 30kB
  • Buffers: shared hit=63,049
3. 0.243 232.017 ↓ 2,437.0 2,437 1

Append (cost=1.07..9.12 rows=1 width=566) (actual time=0.095..232.017 rows=2,437 loops=1)

  • Buffers: shared hit=63,049
4. 231.774 231.774 ↓ 2,437.0 2,437 1

Index Scan using "cdx_coll_a4f76899-34b7-4439-810b-98149dcb9ca7_url_idx1" on cdx_coll_a4f76899-34b7-4439-810b-98149dcb9ca7 cdx_coll_a4f76899-34b7-4439-810b-98149dcb9ca7 (cost=1.07..9.11 rows=1 width=566) (actual time=0.094..231.774 rows=2,437 loops=1)

  • Index Cond: (("cdx_coll_a4f76899-34b7-4439-810b-98149dcb9ca7".url ~>=~ 'http://www.defra.gov.uk/animalh/'::text) AND ("cdx_coll_a4f76899-34b7-4439-810b-98149dcb9ca7".url ~<~ 'http://www.defra.gov.uk/animalh0'::text))
  • Filter: (("cdx_coll_a4f76899-34b7-4439-810b-98149dcb9ca7".url ~~ 'http://www.defra.gov.uk/animalh/%'::text) AND ("cdx_coll_a4f76899-34b7-4439-810b-98149dcb9ca7".org_id = 'a4f76899-34b7-4439-810b-98149dcb9ca7'::text) AND ("cdx_coll_a4f76899-34b7-4439-810b-98149dcb9ca7".collection_id = 'a4f76899-34b7-4439-810b-98149dcb9ca7'::text) AND ("cdx_coll_a4f76899-34b7-4439-810b-98149dcb9ca7".status = ANY ('{200,201,202}'::integer[])) AND ("cdx_coll_a4f76899-34b7-4439-810b-98149dcb9ca7".date >= to_timestamp('20060323000000'::text, 'YYYYMMDDHH24MISS'::text)) AND ("cdx_coll_a4f76899-34b7-4439-810b-98149dcb9ca7".date <= to_timestamp('20060325235959'::text, 'YYYYMMDDHH24MISS'::text)))
  • Buffers: shared hit=63,049
Planning time : 0.524 ms
Execution time : 233.021 ms