explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VDLI

Settings
# exclusive inclusive rows x rows loops node
1. 1,725.686 392,262.533 ↑ 1.0 1 1

Aggregate (cost=3,950,446.76..3,950,446.77 rows=1 width=8) (actual time=392,262.533..392,262.533 rows=1 loops=1)

  • Buffers: shared hit=207030905 read=4494615 dirtied=54 written=25345
2. 390,536.847 390,536.847 ↑ 8.3 12,117,951 1

Index Only Scan using wf_assignment_pkey on wf_assignment (cost=0.57..3,699,072.96 rows=100,549,520 width=0) (actual time=0.183..390,536.847 rows=12,117,951 loops=1)

  • Heap Fetches: 105741251
  • Buffers: shared hit=207030905 read=4494615 dirtied=54 written=25345
Planning time : 0.071 ms
Execution time : 392,262.554 ms