explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BRFi : jezz

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 11.939 ↓ 6.0 6 1

Hash Join (cost=2,190.00..3,169.14 rows=1 width=5,684) (actual time=0.248..11.939 rows=6 loops=1)

  • Hash Cond: ((r.client_key)::text = (c.client_static_key)::text)
2.          

CTE clients_rescore

3. 0.014 0.074 ↑ 18.8 8 1

Nested Loop (cost=0.29..1,078.75 rows=150 width=32) (actual time=0.027..0.074 rows=8 loops=1)

4. 0.012 0.012 ↑ 18.8 8 1

Seq Scan on clients_fa_tmp cf (cost=0.00..11.50 rows=150 width=516) (actual time=0.006..0.012 rows=8 loops=1)

5. 0.048 0.048 ↑ 1.0 1 8

Index Scan using clients_pkey on clients c_1 (cost=0.29..7.10 rows=1 width=32) (actual time=0.006..0.006 rows=1 loops=8)

  • Index Cond: ((client_key)::text = (cf.client_key)::text)
6.          

CTE accounts_rescore

7. 0.013 0.092 ↑ 12.5 12 1

Nested Loop (cost=0.41..1,101.50 rows=150 width=54) (actual time=0.016..0.092 rows=12 loops=1)

8. 0.007 0.007 ↑ 12.5 12 1

Seq Scan on accounts_fa_tmp af (cost=0.00..11.50 rows=150 width=516) (actual time=0.003..0.007 rows=12 loops=1)

9. 0.072 0.072 ↑ 1.0 1 12

Index Scan using accounts_pkey on accounts a_1 (cost=0.41..7.26 rows=1 width=54) (actual time=0.006..0.006 rows=1 loops=12)

  • Index Cond: ((account_key)::text = (af.account_key)::text)
10. 6.095 11.831 ↑ 12.5 12 1

Hash Join (cost=4.88..983.44 rows=150 width=2,601) (actual time=0.143..11.831 rows=12 loops=1)

  • Hash Cond: ((r.account_key)::text = (a.account_key)::text)
11. 5.620 5.620 ↑ 1.0 24,150 1

Seq Scan on client_accounts r (cost=0.00..886.50 rows=24,150 width=44) (actual time=0.003..5.620 rows=24,150 loops=1)

12. 0.010 0.116 ↑ 12.5 12 1

Hash (cost=3.00..3.00 rows=150 width=3,096) (actual time=0.116..0.116 rows=12 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
13. 0.106 0.106 ↑ 12.5 12 1

CTE Scan on accounts_rescore a (cost=0.00..3.00 rows=150 width=3,096) (actual time=0.018..0.106 rows=12 loops=1)

14. 0.007 0.088 ↑ 18.8 8 1

Hash (cost=3.00..3.00 rows=150 width=3,096) (actual time=0.088..0.088 rows=8 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
15. 0.081 0.081 ↑ 18.8 8 1

CTE Scan on clients_rescore c (cost=0.00..3.00 rows=150 width=3,096) (actual time=0.029..0.081 rows=8 loops=1)