explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tDxc : test

Settings
# exclusive inclusive rows x rows loops node
1. 0.111 0.692 ↓ 0.0 0 1

"QUERY PLAN": "Update on student (cost=0.43..8.45 rows=1 width=77) (actual time=0.692..0.692 rows=0 loops=1)

  • },
  • },
  • "QUERY PLAN": " Index Cond: (id = 1,619,900)
  • },
  • "QUERY PLAN": "Planning Time: 0.106 ms
  • },
  • "QUERY PLAN": "Execution Time: 0.726 ms
  • }]
2. 0.581 0.581 ↑ 1.0 1 1

"QUERY PLAN": " -> Index Scan using student_pkey on student (cost=0.43..8.45 rows=1 width=77) (actual time=0.580..0.581 rows=1 loops=1)