explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UPLS : pgsql-performance_David_Wheeler_Query

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

Limit (cost=1.29..25.38 rows=1 width=80) (actual time=0.770..0.771 rows=1 loops=1)

2. 0.005 0.771 ↑ 1.0 1 1

Nested Loop (cost=1.29..25.38 rows=1 width=80) (actual time=0.770..0.771 rows=1 loops=1)

3. 0.005 0.698 ↑ 1.0 1 1

Nested Loop (cost=0.86..16.91 rows=1 width=76) (actual time=0.697..0.698 rows=1 loops=1)

4. 0.647 0.647 ↑ 1.0 1 1

Index Scan using binding_tid_binding_uuid_key on binding (cost=0.43..8.45 rows=1 width=28) (actual time=0.647..0.647 rows=1 loops=1)

  • Index Cond: ((tid = 2082003407) AND (binding_uuid = '4f61dcd5-97a0-4098-b9ae-c1546c31b2e6'::uuid))
5. 0.046 0.046 ↑ 1.0 1 1

Index Scan using subscription_binding_idx on subscription_binding (cost=0.43..8.45 rows=1 width=64) (actual time=0.045..0.046 rows=1 loops=1)

  • Index Cond: ((tid = 2082003407) AND (binding = binding.binding))
6. 0.068 0.068 ↑ 1.0 1 1

Index Scan using subscription_pkey on subscription (cost=0.43..8.45 rows=1 width=28) (actual time=0.068..0.068 rows=1 loops=1)

  • Index Cond: ((tid = 2082003407) AND (subscription = subscription_binding.subscription))
Planning time : 2,429.682 ms
Execution time : 0.914 ms