explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4DHM

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 3.402 ↓ 0.0 0 1

ModifyTable on public.gitlab_subscription_histories (cost=0.00..830.24 rows=1 width=6) (actual time=3.402..3.402 rows=0 loops=1)

  • Buffers: shared hit=177
2. 3.399 3.399 ↓ 0.0 0 1

Seq Scan on public.gitlab_subscription_histories (cost=0.00..830.24 rows=1 width=6) (actual time=3.399..3.399 rows=0 loops=1)

  • Filter: (gitlab_subscription_histories.change_type = 0)
  • Rows Removed by Filter: 9,779
  • Buffers: shared hit=177