explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qR8

Settings
# exclusive inclusive rows x rows loops node
1. 0.027 0.027 ↑ 1.0 1 1

Index Scan Backward using aud_mst_pm_appointment_pkey on aud_mst_pm_appointment appointmen0_ (cost=0.42..5.44 rows=1 width=826) (actual time=0.023..0.027 rows=1 loops=1)

  • Index Cond: (appointment_id = 1000000002433::bigint)
  • Filter: (revision_type <> 0)
  • Rows Removed by Filter: 1
Planning time : 0.164 ms
Execution time : 0.065 ms