explain.depesz.com

PostgreSQL's explain analyze made readable

Result: r0g

Settings
# exclusive inclusive rows x rows loops node
1. 221.640 228,168.459 ↓ 0.0 0 1

Gather (cost=1,000.29..77,867,722.57 rows=42,038 width=90) (actual time=228,166.751..228,168.459 rows=0 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
  • Buffers: shared hit=3963407, temp read=4452201 written=40339
2. 227,943.487 227,946.819 ↓ 0.0 0 2

Parallel Seq Scan on capa_cartola (cost=0.29..77,862,518.77 rows=24,728 width=90) (actual time=227,946.819..227,946.819 rows=0 loops=2)

  • Filter: (NOT (SubPlan 1))
  • Rows Removed by Filter: 42038
  • Buffers: shared hit=3963407, temp read=4452201 written=40339
3.          

SubPlan (forParallel Seq Scan)

4. 0.667 3.332 ↑ 2.0 42,038 84,075

Materialize (cost=0.29..2,938.79 rows=84,075 width=8) (actual time=0.004..3.332 rows=42,038 loops=84,075)

  • Buffers: shared hit=3962066, temp read=4452201 written=40339
5. 2.665 2.665 ↑ 1.9 43,468 32,945

Index Only Scan using pk_capcuenta on capa_cuenta (cost=0.29..2,189.42 rows=84,075 width=8) (actual time=0.004..2.665 rows=43,468 loops=32,945)

  • Heap Fetches: 0
  • Buffers: shared hit=3962066
Planning time : 0.854 ms
Execution time : 228,169.505 ms