explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Lupk

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.034 ↓ 0.0 0 1

Nested Loop Left Join (cost=8.58..10.87 rows=1 width=23) (actual time=0.034..0.034 rows=0 loops=1)

2. 0.000 0.033 ↓ 0.0 0 1

Nested Loop (cost=8.45..10.37 rows=1 width=19) (actual time=0.033..0.033 rows=0 loops=1)

3. 0.007 0.033 ↓ 0.0 0 1

Hash Join (cost=8.31..9.98 rows=1 width=8) (actual time=0.033..0.033 rows=0 loops=1)

  • Hash Cond: (asor.security_object_id = b.sec_obj_id)
4. 0.013 0.013 ↑ 53.0 1 1

Seq Scan on acc_secur_obj_rel asor (cost=0.00..1.53 rows=53 width=16) (actual time=0.013..0.013 rows=1 loops=1)

5. 0.001 0.013 ↓ 0.0 0 1

Hash (cost=8.29..8.29 rows=1 width=4) (actual time=0.012..0.013 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
6. 0.012 0.012 ↓ 0.0 0 1

Index Scan using blocks_pkey on blocks b (cost=0.28..8.29 rows=1 width=4) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (block_number = '0'::text)
7. 0.000 0.000 ↓ 0.0 0

Index Scan using accounts_pkey on accounts a (cost=0.14..0.38 rows=1 width=23) (never executed)

  • Index Cond: (id = asor.account_id)
8. 0.000 0.000 ↓ 0.0 0

Index Scan using type_pkey on account_status a_s (cost=0.13..0.38 rows=1 width=12) (never executed)

  • Index Cond: (id = a.status_id)
Planning time : 0.521 ms
Execution time : 0.084 ms