explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qn5f

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 96.459 ↑ 2.0 1 1

Sort (cost=4,856.94..4,856.95 rows=2 width=57) (actual time=96.459..96.459 rows=1 loops=1)

  • Sort Key: group_id, username
  • Sort Method: quicksort Memory: 25kB
2. 96.443 96.443 ↑ 2.0 1 1

Seq Scan on group_user this_ (cost=0.00..4,856.93 rows=2 width=57) (actual time=5.283..96.443 rows=1 loops=1)

  • Filter: (((group_id)::text ~~* 'dji18h01'::text) AND ((username)::text ~~* 'suresh'::text))
  • Rows Removed by Filter: 122100