explain.depesz.com

PostgreSQL's explain analyze made readable

Result: G4q

Settings
# exclusive inclusive rows x rows loops node
1. 3.895 14.875 ↑ 1.0 100 1

Subquery Scan on p (cost=0.42..29.52 rows=100 width=32) (actual time=0.854..14.875 rows=100 loops=1)

2. 2.550 10.980 ↑ 1.0 100 1

Limit (cost=0.42..28.02 rows=100 width=36) (actual time=0.697..10.980 rows=100 loops=1)

3. 4.542 8.430 ↑ 540.9 100 1

GroupAggregate (cost=0.42..14,932.00 rows=54,094 width=36) (actual time=0.676..8.430 rows=100 loops=1)

  • Group Key: pt.person_id
4. 3.888 3.888 ↑ 638.7 101 1

Index Scan using person_translations__pk on person_translations pt (cost=0.42..13,933.27 rows=64,511 width=23) (actual time=0.482..3.888 rows=101 loops=1)

  • Index Cond: (person_id > 15000)
  • Filter: ((language_code = ANY ('{en,ru}'::bpchar[])) AND (full_name ~~* '%ma%'::text))
  • Rows Removed by Filter: 100
Planning time : 2.739 ms
Execution time : 16.224 ms