explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Yuqh

Settings
# exclusive inclusive rows x rows loops node
1. 0.205 15.650 ↓ 0.0 0 1

ModifyTable (cost=57.18..325.07 rows=80 width=34) (actual time=15.65..15.65 rows=0 loops=1)

  • Buffers: shared hit=1923
2. 0.110 15.445 ↑ 1.0 80 1

Nested Loop (cost=57.18..325.07 rows=80 width=34) (actual time=14.924..15.445 rows=80 loops=1)

  • Buffers: shared hit=1763
3. 0.090 14.935 ↑ 1.0 80 1

Aggregate (cost=56.76..57.56 rows=80 width=32) (actual time=14.898..14.935 rows=80 loops=1)

  • Buffers: shared hit=1442
4. 0.057 14.845 ↑ 1.0 80 1

Subquery Scan on ANY_subquery (cost=0..56.56 rows=80 width=32) (actual time=11.684..14.845 rows=80 loops=1)

  • Buffers: shared hit=1442
5. 0.021 14.788 ↑ 1.0 80 1

Limit (cost=0..55.76 rows=80 width=4) (actual time=11.672..14.788 rows=80 loops=1)

  • Buffers: shared hit=1442
6. 14.767 14.767 ↑ 134.6 80 1

Seq Scan on dim_company dim_company_1 (cost=0..7,502.82 rows=10,764 width=4) (actual time=11.67..14.767 rows=80 loops=1)

  • Filter: (dim_company_1.client_sk = 7)
  • Buffers: shared hit=1442
7. 0.400 0.400 ↑ 1.0 1 80

Index Scan using dim_company_company_sk_idx on dim_company dim_company (cost=0.42..3.34 rows=1 width=10) (actual time=0.005..0.005 rows=1 loops=80)

  • Index Cond: (dim_company.company_sk = "ANY_subquery".company_sk)
  • Buffers: shared hit=321