explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NoBl

Settings
# exclusive inclusive rows x rows loops node
1. 8.784 90.016 ↓ 2.1 14,850 1

Nested Loop Left Join (cost=1.28..18,137.57 rows=6,913 width=4) (actual time=0.043..90.016 rows=14,850 loops=1)

2. 21.832 21.832 ↓ 2.1 14,850 1

Index Scan using uq_object_id_timestamp on table_a a (cost=0.70..7,038.49 rows=6,913 width=8) (actual time=0.028..21.832 rows=14,850 loops=1)

  • Index Cond: ((object_id = 13) AND (timestamp < '2019-12-06'::timestamp with time zone) AND (timestamp > '2019-12-03'::timestamp with time zone))
3. 59.400 59.400 ↓ 0.0 0 14,850

Index Only Scan using table_b_a_id on table_b b (cost=0.57..1.60 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=14,850)

  • Index Cond: (a_id = a.id)
  • Heap Fetches: 0
Planning time : 1,908.550 ms
Execution time : 91.004 ms