explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pJvZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.062 45.955 ↑ 1.0 1 1

Aggregate (cost=325.17..325.18 rows=1 width=32) (actual time=45.955..45.955 rows=1 loops=1)

2. 0.007 45.893 ↑ 1.0 10 1

Limit (cost=324.99..325.02 rows=10 width=36) (actual time=45.885..45.893 rows=10 loops=1)

3. 0.253 45.886 ↑ 8.2 10 1

Sort (cost=324.99..325.20 rows=82 width=36) (actual time=45.884..45.886 rows=10 loops=1)

  • Sort Key: a.obj_id DESC
  • Sort Method: top-N heapsort Memory: 29kB
4. 2.103 45.633 ↓ 9.0 737 1

Bitmap Heap Scan on application a (cost=5.05..323.22 rows=82 width=36) (actual time=43.630..45.633 rows=737 loops=1)

  • Recheck Cond: (m_telephone ~~ '%09739%'::text)
  • Rows Removed by Index Recheck: 76
  • Heap Blocks: exact=782
5. 43.530 43.530 ↓ 10.2 839 1

Bitmap Index Scan on application_m_telephone_trgr (cost=0.00..5.03 rows=82 width=0) (actual time=43.530..43.530 rows=839 loops=1)

  • Index Cond: (m_telephone ~~ '%09739%'::text)