explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PLPtp

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 2.398 ↑ 51.0 1 1

Hash Left Join (cost=40.17..1,094.25 rows=51 width=374) (actual time=0.989..2.398 rows=1 loops=1)

  • Hash Cond: (d.id = e.institution_id)
  • Buffers: shared hit=220
2. 0.009 2.345 ↑ 51.0 1 1

Hash Left Join (cost=14.86..1,066.60 rows=51 width=178) (actual time=0.937..2.345 rows=1 loops=1)

  • Hash Cond: (c.guid = (d.guid)::text)
  • Buffers: shared hit=197
3. 0.003 2.239 ↑ 51.0 1 1

Nested Loop (cost=0.57..1,051.98 rows=51 width=211) (actual time=0.831..2.239 rows=1 loops=1)

  • Buffers: shared hit=186
4. 0.008 2.234 ↑ 51.0 1 1

Nested Loop Left Join (cost=0.29..720.05 rows=51 width=174) (actual time=0.827..2.234 rows=1 loops=1)

  • Buffers: shared hit=183
5. 2.221 2.221 ↑ 51.0 1 1

Seq Scan on account a (cost=0.00..360.11 rows=51 width=166) (actual time=0.815..2.221 rows=1 loops=1)

  • Filter: ((user_id)::text = '3459'::text)
  • Rows Removed by Filter: 10301
  • Buffers: shared hit=180
6. 0.005 0.005 ↑ 1.0 1 1

Index Scan using ix_aggregation_account_guid on aggregation_account b (cost=0.29..7.05 rows=1 width=24) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (a.aggregation_id = guid)
  • Buffers: shared hit=3
7. 0.002 0.002 ↑ 1.0 1 1

Index Scan using pk_user on "user" c (cost=0.29..6.50 rows=1 width=41) (actual time=0.002..0.002 rows=1 loops=1)

  • Index Cond: (id = a.institution_id)
  • Buffers: shared hit=3
8. 0.061 0.097 ↓ 1.1 159 1

Hash (cost=12.46..12.46 rows=146 width=20) (actual time=0.097..0.097 rows=159 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
  • Buffers: shared hit=11
9. 0.036 0.036 ↓ 1.1 159 1

Seq Scan on aggregation_institution d (cost=0.00..12.46 rows=146 width=20) (actual time=0.002..0.036 rows=159 loops=1)

  • Buffers: shared hit=11
10. 0.015 0.045 ↓ 1.0 107 1

Hash (cost=24.03..24.03 rows=103 width=8) (actual time=0.045..0.045 rows=107 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
  • Buffers: shared hit=23
11. 0.030 0.030 ↓ 1.0 107 1

Seq Scan on provider_institution e (cost=0.00..24.03 rows=103 width=8) (actual time=0.002..0.030 rows=107 loops=1)

  • Buffers: shared hit=23