explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vp1x : One

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=147.60..12,631.60 rows=247,160 width=1,844) (actual rows= loops=)

  • Hash Cond: (t2._accountctrref = t18._idrref)
2. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=126.80..7,648.78 rows=247,160 width=1,065) (actual rows= loops=)

  • Hash Cond: (t2._accountdtrref = t17._idrref)
3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=106.00..7,362.01 rows=247,160 width=1,055) (actual rows= loops=)

  • Hash Cond: (t2._fld2162ctrref = t16._idrref)
4. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=88.18..7,073.76 rows=247,160 width=1,000) (actual rows= loops=)

  • Hash Cond: (t2._fld2162dtrref = t15._idrref)
5. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=70.36..6,787.59 rows=247,160 width=945) (actual rows= loops=)

  • Hash Cond: (t2._fld2160rref = t14._idrref)
6. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=69.28..6,158.00 rows=247,160 width=913) (actual rows= loops=)

  • Hash Cond: (t2._fld2163ctrref = t13._idrref)
7. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=48.36..5,870.93 rows=247,160 width=905) (actual rows= loops=)

  • Hash Cond: (t2._fld2163dtrref = t12._idrref)
8. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=27.44..5,585.11 rows=247,160 width=897) (actual rows= loops=)

  • Hash Cond: (t2._kindct3rref = t11._idrref)
9. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=23.23..5,311.98 rows=247,160 width=857) (actual rows= loops=)

  • Hash Cond: (t2._kindct2rref = t10._idrref)
10. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=19.02..5,006.00 rows=247,160 width=817) (actual rows= loops=)

  • Hash Cond: (t2._kindct1rref = t9._idrref)
11. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=14.81..4,695.31 rows=247,160 width=777) (actual rows= loops=)

  • Hash Cond: (t2._kinddt3rref = t8._idrref)
12. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=10.60..4,418.66 rows=247,160 width=737) (actual rows= loops=)

  • Hash Cond: (t2._kinddt2rref = t7._idrref)
13. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=6.39..4,107.97 rows=247,160 width=697) (actual rows= loops=)

  • Hash Cond: (t2._kinddt1rref = t6._idrref)
14. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=2.18..3,797.28 rows=247,160 width=657) (actual rows= loops=)

  • Hash Cond: (t2._fld2161ctrref = t5._idrref)
15. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=1.09..3,536.68 rows=247,160 width=625) (actual rows= loops=)

  • Hash Cond: (t2._fld2161dtrref = t4._idrref)
16. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..3,276.07 rows=247,160 width=593) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Seq Scan on _reference210 t3 (cost=0.00..553.79 rows=6,179 width=0) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..3.56 rows=40 width=593) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Seq Scan on tt1 t2 (cost=0.00..3.48 rows=40 width=593) (actual rows= loops=)

  • Filter: ((_period >= '2019-01-01 00:00:00'::timestamp without time zone) AND (_period <= '2019-01-31 00:00:00'::timestamp without time zone))
20. 0.000 0.000 ↓ 0.0

Hash (cost=1.08..1.08 rows=1 width=64) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 5kB
21. 0.000 0.000 ↓ 0.0

Seq Scan on _reference55 t4 (cost=0.00..1.08 rows=1 width=64) (actual rows= loops=)

  • Filter: (_fld2105 = '0'::numeric)
22. 0.000 0.000 ↓ 0.0

Hash (cost=1.08..1.08 rows=1 width=64) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 5kB
23. 0.000 0.000 ↓ 0.0

Seq Scan on _reference55 t5 (cost=0.00..1.08 rows=1 width=64) (actual rows= loops=)

  • Filter: (_fld2105 = '0'::numeric)
24. 0.000 0.000 ↓ 0.0

Hash (cost=3.61..3.61 rows=55 width=57) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
25. 0.000 0.000 ↓ 0.0

Seq Scan on _chrc2086 t6 (cost=0.00..3.61 rows=55 width=57) (actual rows= loops=)

  • Filter: (_fld2105 = '0'::numeric)
26. 0.000 0.000 ↓ 0.0

Hash (cost=3.61..3.61 rows=55 width=57) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
27. 0.000 0.000 ↓ 0.0

Seq Scan on _chrc2086 t7 (cost=0.00..3.61 rows=55 width=57) (actual rows= loops=)

  • Filter: (_fld2105 = '0'::numeric)
28. 0.000 0.000 ↓ 0.0

Hash (cost=3.61..3.61 rows=55 width=57) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
29. 0.000 0.000 ↓ 0.0

Seq Scan on _chrc2086 t8 (cost=0.00..3.61 rows=55 width=57) (actual rows= loops=)

  • Filter: (_fld2105 = '0'::numeric)
30. 0.000 0.000 ↓ 0.0

Hash (cost=3.61..3.61 rows=55 width=57) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
31. 0.000 0.000 ↓ 0.0

Seq Scan on _chrc2086 t9 (cost=0.00..3.61 rows=55 width=57) (actual rows= loops=)

  • Filter: (_fld2105 = '0'::numeric)
32. 0.000 0.000 ↓ 0.0

Hash (cost=3.61..3.61 rows=55 width=57) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
33. 0.000 0.000 ↓ 0.0

Seq Scan on _chrc2086 t10 (cost=0.00..3.61 rows=55 width=57) (actual rows= loops=)

  • Filter: (_fld2105 = '0'::numeric)
34. 0.000 0.000 ↓ 0.0

Hash (cost=3.61..3.61 rows=55 width=57) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
35. 0.000 0.000 ↓ 0.0

Seq Scan on _chrc2086 t11 (cost=0.00..3.61 rows=55 width=57) (actual rows= loops=)

  • Filter: (_fld2105 = '0'::numeric)
36. 0.000 0.000 ↓ 0.0

Hash (cost=16.96..16.96 rows=360 width=25) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 22kB
37. 0.000 0.000 ↓ 0.0

Seq Scan on _reference275 t12 (cost=0.00..16.96 rows=360 width=25) (actual rows= loops=)

  • Filter: (_fld2105 = '0'::numeric)
38. 0.000 0.000 ↓ 0.0

Hash (cost=16.96..16.96 rows=360 width=25) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 22kB
39. 0.000 0.000 ↓ 0.0

Seq Scan on _reference275 t13 (cost=0.00..16.96 rows=360 width=25) (actual rows= loops=)

  • Filter: (_fld2105 = '0'::numeric)
40. 0.000 0.000 ↓ 0.0

Hash (cost=1.08..1.08 rows=1 width=64) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 5kB
41. 0.000 0.000 ↓ 0.0

Seq Scan on _reference310 t14 (cost=0.00..1.08 rows=1 width=64) (actual rows= loops=)

  • Filter: (_fld2105 = '0'::numeric)
42. 0.000 0.000 ↓ 0.0

Hash (cost=15.41..15.41 rows=219 width=72) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
43. 0.000 0.000 ↓ 0.0

Seq Scan on _reference552 t15 (cost=0.00..15.41 rows=219 width=72) (actual rows= loops=)

  • Filter: (_fld2105 = '0'::numeric)
44. 0.000 0.000 ↓ 0.0

Hash (cost=15.41..15.41 rows=219 width=72) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
45. 0.000 0.000 ↓ 0.0

Seq Scan on _reference552 t16 (cost=0.00..15.41 rows=219 width=72) (actual rows= loops=)

  • Filter: (_fld2105 = '0'::numeric)
46. 0.000 0.000 ↓ 0.0

Hash (cost=16.40..16.40 rows=400 width=27) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
47. 0.000 0.000 ↓ 0.0

Seq Scan on _acc26 t17 (cost=0.00..16.40 rows=400 width=27) (actual rows= loops=)

  • Filter: (_fld2105 = '0'::numeric)
48. 0.000 0.000 ↓ 0.0

Hash (cost=16.40..16.40 rows=400 width=27) (actual rows= loops=)

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
49. 0.000 0.000 ↓ 0.0

Seq Scan on _acc26 t18 (cost=0.00..16.40 rows=400 width=27) (actual rows= loops=)

  • Filter: (_fld2105 = '0'::numeric)