explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iiyU

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

Limit (cost=0.98..17.02 rows=1 width=56) (actual time=0.045..0.046 rows=1 loops=1)

2. 0.002 0.044 ↑ 1.0 1 1

Nested Loop (cost=0.98..17.02 rows=1 width=56) (actual time=0.044..0.044 rows=1 loops=1)

3. 0.032 0.032 ↑ 1.0 1 1

Index Scan using index_at_files_on_s3_key on at_files (cost=0.55..8.57 rows=1 width=16) (actual time=0.032..0.032 rows=1 loops=1)

  • Index Cond: ((s3_key)::text = 'customer/77/482c40f6-5dc1-4c10-91d7-2691cf4fa3c6'::text)
4. 0.010 0.010 ↑ 1.0 1 1

Index Scan using index_at_documents_on_at_file_id on at_documents (cost=0.42..8.44 rows=1 width=56) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: (at_file_id = at_files.id)
  • Filter: (deleted_at IS NULL)
Planning time : 22.393 ms
Execution time : 0.095 ms