explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wtyG

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 0.041 ↓ 0.0 0 1

Update on chaallan_details (cost=0.43..8.45 rows=1 width=1,886) (actual time=0.041..0.041 rows=0 loops=1)

  • Planning time: 0.074 ms
  • Trigger trigger_chaallan_audit: time=2.287 calls=1
  • Execution time: 2.358 ms
2. 0.023 0.023 ↑ 1.0 1 1

Index Scan using chaallan_details_pkey on chaallan_details (cost=0.43..8.45 rows=1 width=1,886) (actual time=0.023..0.023 rows=1 loops=1)

  • Index Cond: ((transid)::text = 'P21C610-2019031207658'::text)