explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Glx9

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

Limit (cost=0.43..90,476.57 rows=1 width=569) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Index Scan Backward using tcollection_target_pkey on tcollection_target this_ (cost=0.43..633,333.40 rows=7 width=569) (actual rows= loops=)

  • Filter: (((document)::text ~~* '05971483683%'::text) AND (config = 7))