explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dFcQ

Settings
# exclusive inclusive rows x rows loops node
1. 225.280 22,414.389 ↓ 1.0 542,133 1

Gather (cost=1,000..596,818.94 rows=535,364 width=498) (actual time=2.236..22,414.389 rows=542,133 loops=1)

  • Buffers: shared read=480426
2. 22,189.109 22,189.109 ↑ 1.2 180,711 3

Seq Scan on fact_contract_view fact_contract_view (cost=0..542,282.54 rows=223,068 width=498) (actual time=4.526..22,189.109 rows=180,711 loops=3)

  • Filter: (fact_contract_view.client_sk = 11)
  • Buffers: shared read=480426