explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mexw

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.068 ↓ 2.0 2 1

Limit (cost=0.69..16.72 rows=1 width=27) (actual time=0.065..0.068 rows=2 loops=1)

  • Buffers: shared hit=7
2. 0.066 0.066 ↓ 2.0 2 1

Index Scan using event_metadata_pkey on event_metadata (cost=0.69..16.72 rows=1 width=27) (actual time=0.064..0.066 rows=2 loops=1)

  • Index Cond: ((event_id)::text = 'crid:~~2F~~2Fjoery.tv~~2FE2E40-Single786-V11,imi:c67554870e2f6411bb09b6aac5e1beaaa3350b56'::text)
  • Filter: (channel_id = 'E2E40'::text)
  • Buffers: shared hit=7
Planning time : 0.148 ms
Execution time : 0.091 ms