explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vv7g

Settings
# exclusive inclusive rows x rows loops node
1. 0.278 0.444 ↑ 1.0 10 1

GroupAggregate (cost=520.21..524.07 rows=10 width=78) (actual time=0.405..0.444 rows=10 loops=1)

  • Group Key: vhl_discard_settings.id, ((regexp_replace((vhl_discard_settings.number)::text, '[^\d]'::text, 'g'::text))::integer)
2. 0.028 0.166 ↑ 11.9 10 1

Sort (cost=520.21..520.51 rows=119 width=69) (actual time=0.165..0.166 rows=10 loops=1)

  • Sort Key: vhl_discard_settings.id, ((regexp_replace((vhl_discard_settings.number)::text, '[^\d]'::text, 'g'::text))::integer)
  • Sort Method: quicksort Memory: 25kB
3. 0.093 0.138 ↑ 11.9 10 1

Nested Loop Left Join (cost=0.57..516.11 rows=119 width=69) (actual time=0.100..0.138 rows=10 loops=1)

4. 0.035 0.035 ↑ 1.0 10 1

Seq Scan on vhl_discard_settings (cost=0.00..4.15 rows=10 width=42) (actual time=0.013..0.035 rows=10 loops=1)

  • Filter: (ent_id = 1,477)
  • Rows Removed by Filter: 162
5. 0.010 0.010 ↓ 0.0 0 10

Nested Loop Left Join (cost=0.57..51.01 rows=10 width=27) (actual time=0.001..0.001 rows=0 loops=10)

6. 0.000 0.000 ↓ 0.0 0 10

Index Scan using vhl_discard_settings_kvd_anal_vhldiscardsettings_id on vhl_discard_settings_kvd_anal (cost=0.15..4.73 rows=10 width=8) (actual time=0.000..0.000 rows=0 loops=10)

  • Index Cond: (vhl_discard_settings.id = vhldiscardsettings_id)
7. 0.000 0.000 ↓ 0.0 0

Index Scan using unidictrec_pkey on unidictrec (cost=0.42..4.62 rows=1 width=27) (never executed)

  • Index Cond: (vhl_discard_settings_kvd_anal.unidictrec_id = id)
Planning time : 1.199 ms
Execution time : 1.514 ms